private int CreateSale(int inHandCash) { DB.Sale today = GetToday(); if (today == null) { var sale = new DB.Sale { Date = DateTime.Now, TotalSold = 0, IsDividedAmongPartners = false, OtherExpenses = 0, TotalAcheived = 0, Discount = 0, TotalLess = 0, TotalWastages = 0, TotalDiscountNumber = 0, InHandCashChange = inHandCash, ActualAcheivedFromEmployee = 0, ActualLossProfitAfterCollection = 0, IsInventorySet = false }; db.Sales.Add(sale); db.SaveChanges(); return(sale.SaleID); } else { return(today.SaleID); } }
public static void SyncZoneInDatabase() { using (var db = new DB.JustFoodDBEntities()) { var zones = db.TimeZones.ToList(); var change = false; foreach (var timezone in SystemTimeZones) { if (!zones.Any(n => n.TimeZoneInfoId == timezone.Id)) { //not in the database. var timeZoneDb = new DB.TimeZone() { TimeZoneInfoId = timezone.Id, TimeZoneDisplay = timezone.DisplayName }; change = true; db.TimeZones.Add(timeZoneDb); } } if (change) { db.SaveChanges(); } dbTimeZones = db.TimeZones.ToList(); } }