public void Save()
{
DataBaseLayer.LoterejaEntities dbc = new DataBaseLayer.LoterejaEntities();
var result = dbc.drawings.Where(item => item.id_draw == id_draw).FirstOrDefault();
if (result != null)
{
result.count_winner = Winners.Count;
if (PriceElements != null)
{
string elements = "";
foreach (int i in PriceElements)
{
elements = elements + i + ",";
}
elements.Trim().Trim(',');
result.result = elements;
}
dbc.SaveChanges();
}
}
public void Save(string ip, string elements)
{
DataBaseLayer.LoterejaEntities dbc = new DataBaseLayer.LoterejaEntities();
DataBaseLayer.winner model = new DataBaseLayer.winner()
{
date = DateTime.Now,
ip = ip,
elements = elements,
email = email,
name = name,
phone = phone
};
dbc.winners.Add(model);
dbc.SaveChanges();
}
public static settings Get()
{
DataBaseLayer.LoterejaEntities dbc = new DataBaseLayer.LoterejaEntities();
var query = from sett in dbc.settings
let maxDate = dbc.settings.Select(item => item.date).Max()
where sett.date == maxDate
select new settings()
{
id_settings = sett.id_settings,
countValue = sett.countValue,
maxValue = sett.maxValue,
minJackPot = sett.minJackPot,
minValue = sett.minValue,
stepJackPot = sett.stepJackPot,
timeAfterDraw = sett.timeAfterDraw,
timeBeforeDraw = sett.timeBeforeDraw,
timeDraw = sett.timeDraw
};
settings result = null;
if (query.Any())
{
result = query.First();
}
else
{
result = SetDefaultValue();
}
return result;
}
public static void Insert(settings model)
{
try
{
DataBaseLayer.LoterejaEntities dbc = new DataBaseLayer.LoterejaEntities();
dbc.settings.Add((DataBaseLayer.setting)model);
dbc.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static DataBaseLayer.create_draw_Result Create(int JackPot, int stepJackPot)
{
DataBaseLayer.LoterejaEntities dbc = new DataBaseLayer.LoterejaEntities();
return dbc.create_draw(JackPot, stepJackPot).FirstOrDefault();
}
