public static int CreateNewStatisticForUser(int userId, Statistic statType, float val)
{
try
{
int id;
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var statisticData = new UserStatisticDataProvider
{
user_id = userId,
value = val,
statistic_type = (byte)statType
};
data.UserStatisticDataProviders.InsertOnSubmit(statisticData);
data.SubmitChanges();
id = statisticData.id;
}
return id;
}
catch (Exception)
{
return 0;
}
}