public Store_Sale GetSaleInfoBySaleID(int SaleID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Store_Sale.Where(x => x.Store_Sale_ID == SaleID).FirstOrDefault()); } }
public Store_Branches GetBranchByBranchID(int BranchID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Store_Branches.Where(x => x.Store_Branch_ID == BranchID).FirstOrDefault()); } }
public Boolean SaveStore(Store_Info storeinfo) { if (string.IsNullOrEmpty(storeinfo.Store_Info_ID.ToString())) // New Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { dbContext.Store_Info.Add(storeinfo); dbContext.SaveChanges(); return(true); } } else // Update Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { Store_Info info = dbContext.Store_Info.Where(x => x.Store_Info_ID == storeinfo.Store_Info_ID).FirstOrDefault(); info.Store_Name = storeinfo.Store_Name; info.Is_Active = storeinfo.Is_Active; info.Updated_On = DateTime.Now; info.Updated_By = "User"; dbContext.SaveChanges(); return(true); } } }
public Utility.Data.Utility GetUtilityByID(int UtilityID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Utilities.Where(x => x.Utility_ID == UtilityID).FirstOrDefault()); } }
public List <City> GetAllCities() { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Cities.ToList()); } }
public List <Store_Branches> GetStoreBranches(int StoreInfoID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Store_Branches.Where(x => x.Store_Info_ID == StoreInfoID).ToList()); } }
public List <Store_Info> GetStoreByUtilityID(int UtilityID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { return(dbContext.Store_Info.Where(x => x.Utility_ID == UtilityID).ToList()); } }
public Boolean SaveUtility(Utility.Data.Utility utility) { if (string.IsNullOrEmpty(utility.Utility_ID.ToString())) // New Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { dbContext.Utilities.Add(utility); dbContext.SaveChanges(); return(true); } } else // Update Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { Utility.Data.Utility Utility = dbContext.Utilities.Where(x => x.Utility_ID == utility.Utility_ID).FirstOrDefault(); Utility.Utility_Name = utility.Utility_Name; Utility.Is_Active = utility.Is_Active; Utility.City_ID = utility.City_ID; Utility.Updated_On = DateTime.Now; Utility.Updated_By = "user"; return(true); } } }
public List <Store_Sale> GetStoreSaleInfo(int Store_Info_ID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { List <Store_Sale> storesale = dbContext.Store_Sale.Where(x => x.Store_Info_ID == Store_Info_ID).ToList(); return(storesale); } }
public List <Store_Branches> GetBranchByStoreID(int Store_Info_ID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { List <Store_Branches> Branches = dbContext.Store_Branches.Where(x => x.Store_Info_ID == Store_Info_ID).ToList(); return(Branches); } }
public List <Store_Info> GetStoreInfoByUtilityID(int UtilityID) { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { List <Store_Info> StoreInforamtion = dbContext.Store_Info.Include("Store_Branches").Include("Store_Sale").Where(x => x.Utility_ID == UtilityID).ToList(); return(StoreInforamtion); } }
public List <Utility.Data.Utility> GetAllUtilities() { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { List <Utility.Data.Utility> Utilities = dbContext.Utilities.ToList(); return(Utilities); } }
public List <Utility.Data.Utility> GetAllUtilities() { List <Utility.Data.Utility> Utility; using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { Utility = dbContext.Utilities.OrderBy(x => x.Utility_Name).ToList(); return(Utility); } }
public Boolean SaveSaleData(Store_Sale storeSale) { if (string.IsNullOrEmpty(storeSale.Store_Sale_ID.ToString())) // New Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { dbContext.Store_Sale.Add(storeSale); dbContext.SaveChanges(); return(true); } } else // Update Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { Store_Sale storesale = dbContext.Store_Sale.Where(x => x.Store_Sale_ID == storeSale.Store_Sale_ID).FirstOrDefault(); dbContext.SaveChanges(); return(true); } } }
public Boolean SaveStoreBranch(Store_Branches storeBranch) { if (string.IsNullOrEmpty(storeBranch.Store_Branch_ID.ToString())) // New Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { dbContext.Store_Branches.Add(storeBranch); dbContext.SaveChanges(); return(true); } } else // Update Record { using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext()) { Store_Branches branches = dbContext.Store_Branches.Where(x => x.Store_Branch_ID == storeBranch.Store_Branch_ID).FirstOrDefault(); branches.Branch_Address = storeBranch.Branch_Address; branches.Branch_Name = storeBranch.Branch_Name; branches.Is_Active = storeBranch.Is_Active; dbContext.SaveChanges(); return(true); } } }