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);
}
}
}
