public static void InputAccessPower(string shkafName, int powerCurrent, int powerPast, int accessCurrent, int accessPast) { var query = from f in db.ShkafStatements where f.ShkafID == int.Parse(shkafName) && ((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.ShkafStatements.DeleteAllOnSubmit(query); } ShkafStatement statPast = new ShkafStatement { ShkafID = int.Parse(shkafName), Year = DateTime.Now.AddMonths(-1).Year, Month = DateTime.Now.AddMonths(-1).Month, Power = (powerPast == 1 ? true : false), AccessQuantity = accessPast }; db.ShkafStatements.InsertOnSubmit(statPast); ShkafStatement statCurrent = new ShkafStatement { ShkafID = int.Parse(shkafName), Year = DateTime.Now.Year, Month = DateTime.Now.Month, Power = (powerCurrent == 1 ? true : false), AccessQuantity = accessCurrent }; db.ShkafStatements.InsertOnSubmit(statCurrent); db.SubmitChanges(); }
private void detach_ShkafStatements(ShkafStatement entity) { this.SendPropertyChanging(); entity.Shkaf = null; }
private void attach_ShkafStatements(ShkafStatement entity) { this.SendPropertyChanging(); entity.Shkaf = this; }
partial void DeleteShkafStatement(ShkafStatement instance);
partial void UpdateShkafStatement(ShkafStatement instance);
partial void InsertShkafStatement(ShkafStatement instance);