public static void InputTarifs(int counterID, float tarif1Current, float tarif2Current, float tarif3Current,
float tarif4Current, float tarif1Past, float tarif2Past, float tarif3Past, float tarif4Past)
{
var query = from f in db.CounterStatements
where f.CounterID == counterID &&
((f.Year == DateTime.Now.Year && f.Month == DateTime.Now.Month) ||
(f.Year == DateTime.Now.AddMonths(-1).Year&& f.Month == DateTime.Now.AddMonths(-1).Month))
select f;
if (query.Any())
{
db.CounterStatements.DeleteAllOnSubmit(query);
}
CounterStatement statPast = new CounterStatement
{
CounterID = counterID,
Year = DateTime.Now.AddMonths(-1).Year,
Month = DateTime.Now.AddMonths(-1).Month,
Tarif1 = (decimal)tarif1Past,
Tarif2 = (decimal)tarif2Past,
Tarif3 = (decimal)tarif3Past,
Tarif4 = (decimal)tarif4Past
};
db.CounterStatements.InsertOnSubmit(statPast);
CounterStatement statCurrent = new CounterStatement
{
CounterID = counterID,
Year = DateTime.Now.Year,
Month = DateTime.Now.Month,
Tarif1 = (decimal)tarif1Current,
Tarif2 = (decimal)tarif2Current,
Tarif3 = (decimal)tarif3Current,
Tarif4 = (decimal)tarif4Current
};
db.CounterStatements.InsertOnSubmit(statCurrent);
db.SubmitChanges();
}
partial void DeleteCounterStatement(CounterStatement instance);
private void detach_CounterStatements(CounterStatement entity)
{
this.SendPropertyChanging();
entity.Counter = null;
}
partial void UpdateCounterStatement(CounterStatement instance);
private void attach_CounterStatements(CounterStatement entity)
{
this.SendPropertyChanging();
entity.Counter = this;
}
partial void InsertCounterStatement(CounterStatement instance);