public List <DATA.Domains.AccountHolder> getaccountholders()
{
using (BmsDbContext context = new BmsDbContext())
{
return(context.AccountHolder.ToList());
}
}
public List <DATA.Domains.Ledger> GetLedger(DateTime toDate, DateTime fromDate, int accounthoderId, int insertiontypeId, int trademarkId)
{
using (BmsDbContext context = new BmsDbContext())
{
var result = from trademark in context.Trademark
join accountHolder in context.AccountHolder on trademark.Id equals accountHolder.TradeMarkID
join ledger in context.ledger on accountHolder.Id equals ledger.AccountHolderId
where ledger.CreatedOn >= fromDate && ledger.CreatedOn <= toDate
select ledger;
List <DATA.Domains.Ledger> response = new List <DATA.Domains.Ledger>();
if (accounthoderId > 0)
{
response.AddRange(result.Where(x => x.AccountHolderId == accounthoderId).ToList());
}
if (insertiontypeId > 0)
{
response.AddRange(result.Where(x => x.InsertionTypeId == insertiontypeId).ToList());
}
return(response);
}
}
public List <AccountHolderType> GetAccountHolderType()
{
using (BmsDbContext context = new BmsDbContext())
{
return(context.AccountHolderType.ToList());
}
}
public List <DATA.Domains.InsertionType> getInsertionType()
{
using (BmsDbContext context = new BmsDbContext())
{
return(context.InsertionType.ToList());
}
}
public List <DATA.Domains.Category> GetCategorybyTrademarkId(int TrademarkId)
{
using (BmsDbContext context = new BmsDbContext())
{
return(context.Category.Where(x => x.TradeMarkId == TrademarkId).ToList());
}
}
public List <Trademark> Get()
{
using (BmsDbContext context = new BmsDbContext())
{
return(context.Trademark.ToList());
}
}
public DATA.Domains.User GetById(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var user = context.User.Where(x => x.Id == id).FirstOrDefault();
return(user);
}
}
public DATA.Domains.User GetEmail(string email)
{
using (BmsDbContext context = new BmsDbContext())
{
var getEmail = context.User.Where(x => x.Email == email).FirstOrDefault();
return(getEmail);
}
}
public DATA.Domains.User Authenticate(string emailAddress, string password)
{
using (BmsDbContext context = new BmsDbContext())
{
var getEmail = context.User.Where(x => x.Email == emailAddress && x.Password == password).FirstOrDefault();
return(getEmail);
}
}
public DATA.Domains.AccountHolder GetContact(string contact)
{
using (BmsDbContext context = new BmsDbContext())
{
var getcontacts = context.AccountHolder.Where(x => x.Contact == contact).FirstOrDefault();
return(getcontacts);
}
}
public DATA.Domains.AccountHolder GetByID(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var accountholderToGet = context.AccountHolder.Include("AccountHolderType").Where(x => x.Id == id).FirstOrDefault();
return(accountholderToGet);
}
}
public DATA.Domains.Trademark GetById(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var getTradeMark = context.Trademark.Where(x => x.Id == id).FirstOrDefault();
return(getTradeMark);
}
}
public void SaveLedger(DATA.Domains.Ledger ledger)
{
using (BmsDbContext context = new BmsDbContext())
{
context.ledger.Add(ledger);
context.SaveChanges();
}
}
public void SavePurchaseItems(List <DATA.Domains.PurchaseItem> products)
{
using (BmsDbContext context = new BmsDbContext())
{
context.PurchaseItem.AddRange(products);
context.SaveChanges();
}
}
public DATA.Domains.Product GetById(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var product = context.Product.Where(x => x.Id == id).FirstOrDefault();
return(product);
}
}
public void SaveSoldItems(List <SoldItems> soldproducts)
{
using (BmsDbContext context = new BmsDbContext())
{
context.SoldItem.AddRange(soldproducts);
context.SaveChanges();
}
}
public List <DATA.Domains.Product> Get(int trademarkId)
{
using (BmsDbContext context = new BmsDbContext())
{
var products = context.Product.Include("Category").Where(x => x.Category.TradeMarkId == trademarkId && !x.IsDeleted).ToList();
return(products);
}
}
public void Delete(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var delete = context.AccountHolder.Where(x => x.Id == id).FirstOrDefault();
delete.IsDeleted = true;
context.SaveChanges();
}
}
public void Delete(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var deleteproduct = context.Product.Where(x => x.Id == id).FirstOrDefault();
deleteproduct.IsDeleted = true;
context.SaveChanges();
}
}
public int Add(Trademark trademark)
{
using (BmsDbContext context = new BmsDbContext())
{
var TradeMarkToAdd = context.Trademark.Add(trademark);
context.SaveChanges();
return(TradeMarkToAdd.Id);
}
}
public List <DATA.Domains.Ledger> GetLedgerByPurchaseId(int purchaseId)
{
using (BmsDbContext context = new BmsDbContext())
{
var ledger = context.ledger.Where(x => x.PurchaseId == purchaseId && x.AmountIn == 0).ToList();
return(ledger);
}
}
public DATA.Domains.Product EditProduct(int Id)
{
using (BmsDbContext context = new BmsDbContext())
{
var product = context.Product.Where(x => x.Id == Id && !x.IsDeleted).FirstOrDefault();
return(product);
}
}
public void Add(DATA.Domains.AccountHolder accountHolder)
{
using (BmsDbContext context = new BmsDbContext())
{
accountHolder.TradeMarkID = context.Trademark.FirstOrDefault().Id;
context.AccountHolder.Add(accountHolder);
context.SaveChanges();
}
}
public void update(DATA.Domains.User user)
{
using (BmsDbContext context = new BmsDbContext())
{
var usertouptade = context.User.Where(x => x.Id == user.Id).FirstOrDefault();
usertouptade.Password = user.Password;
context.SaveChanges();
}
}
public List <DATA.Domains.AccountHolder> Get(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var trademark = context.Trademark.Where(x => x.Id == id).FirstOrDefault();
var accountholder = context.AccountHolder.Include("AccountHolderType").Where(x => x.TradeMarkID == trademark.Id).ToList();
return(accountholder);
//return context.AccountHolder.Include("AccountHolderType").ToList();
}
}
public int Add(DATA.Domains.Product product)
{
using (BmsDbContext context = new BmsDbContext())
{
var productToAdd = context.Product.Add(product);
context.SaveChanges();
return(productToAdd.Id);
}
}
public List <DATA.Domains.User> GetUser(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var trademarkuser = context.Trademark.Where(x => x.Id == id).FirstOrDefault();
var user = context.User.Where(y => y.Id == trademarkuser.Id).ToList();
return(user);
//return context.User.ToList();
}
}
public DATA.Domains.AccountHolder gettrademarakaccountholder(int id)
{
using (BmsDbContext context = new BmsDbContext())
{
var trademark = context.Trademark.Where(x => x.Id == id).FirstOrDefault();
var accountholder = context.AccountHolder.Where(y => y.TradeMarkUniqueKey == trademark.UniqueKey).FirstOrDefault();
return(accountholder);
}
}
public void SaveCategory(DATA.Domains.Category category)
{
using (BmsDbContext context = new BmsDbContext())
{
var validate = context.Category.Where(name => name.Name == category.Name).FirstOrDefault();
if (validate == null)
{
context.Category.Add(category);
context.SaveChanges();
}
}
}
public Sale GenerateSale()
{
using (BmsDbContext context = new BmsDbContext())
{
var sale = context.Sale.Add(new Sale {
CreatedOn = DateTime.UtcNow.ToLocalTime()
});
context.SaveChanges();
return(sale);
}
}
