public Bid Get(int id) { var pt = db.Bids.Where(x => x.Id == id).FirstOrDefault(); if (pt != null) { Bid pd = new Bid(); pd.Id = pt.Id; pd.Amount = pt.Amount.HasValue ? pt.Amount.Value : 0; DAL.User user = db.Users.Where(x => x.Id == pt.BidderId).FirstOrDefault(); if (user != null) { pd.User = new User(); pd.User.Email = user.Email; pd.User.Password = user.Password; pd.User.Address = user.Address; DAL.Bank b = db.Banks.Where(x => x.Id == user.BankDetailId).FirstOrDefault(); if (b != null) { pd.User.BankDetails = new Bank(); pd.User.BankDetails.Id = b.Id; pd.User.BankDetails.AccountNumber = b.AccountNbr; pd.User.BankDetails.Balance = b.Balance.HasValue ? b.Balance.Value : 0; } } pd.AuctionId = pt.AuctionId.HasValue ? pt.AuctionId.Value : 0; return(pd); } return(null); }
public User Get(int id) { var user = db.Users.Where(x => x.Id == id).FirstOrDefault(); if (user != null) { User u = new User(); u.Id = u.Id; u.Email = user.Email; u.Password = user.Password; u.Address = user.Address; DAL.Bank b = db.Banks.Where(x => x.Id == user.BankDetailId).FirstOrDefault(); if (b != null) { u.BankDetails = new Bank(); u.BankDetails.Id = b.Id; u.BankDetails.AccountNumber = b.AccountNbr; u.BankDetails.Balance = b.Balance.HasValue ? b.Balance.Value : 0; } u.Role = UtilityHelper.HelperClass.GetRoleType(user.RoleId.HasValue ? user.RoleId.Value : user.RoleId.Value); return(u); } return(null); }
public void Save(Bank bank) { DAL.Bank pd = new DAL.Bank(); pd.AccountNbr = bank.AccountNumber; pd.Balance = bank.Balance; db.Banks.InsertOnSubmit(pd); db.SubmitChanges(); }
public void DeleteBank(int id) { DAL.Bank p = db.Banks.Where(x => x.Id == id).FirstOrDefault(); if (p != null) { db.Banks.DeleteOnSubmit(p); db.SubmitChanges(); } }
public void UpdateBankDetail(Bank bank) { DAL.Bank pd = db.Banks.Where(x => x.Id == bank.Id).FirstOrDefault(); if (pd != null) { pd.AccountNbr = bank.AccountNumber; pd.Balance = bank.Balance; db.SubmitChanges(); } }
public List <Auction> All() { var auctions = db.Auctions.Where(x => x.IsDeleted == null || x.IsDeleted == false); List <Auction> lstAuctions = new List <Auction>(); foreach (DAL.Auction pt in auctions) { Auction pd = new Auction(); pd.Id = pt.Id; pd.Expired = pt.Expired.HasValue ? pt.Expired.Value : DateTime.Now; pd.Product = new Product(); pd.Product.Id = pt.Id; pd.Product.BuyoutPrice = pt.Product.BuyoutPrice.HasValue ? pt.Product.BuyoutPrice.Value : 0; pd.Product.ProductDesigner = pt.Product.ProductDesigner; pd.Product.Provision = pt.Product.Provision.HasValue ? pt.Product.Provision.Value : 0; pd.Product.StartPrice = pt.Product.StartPrice.HasValue ? pt.Product.StartPrice.Value : 0; pd.Product.SupplierId = pt.Product.SupplierId.HasValue ? pt.Product.SupplierId.Value : 0; pd.Product.Type = UtilityHelper.HelperClass.GetProductType(pt.Product.TypeId.HasValue ? pt.Product.TypeId.Value : 0); if (pt.BidWinnerId.HasValue) { DAL.User user = db.Users.Where(x => x.Id == pt.BidWinnerId).FirstOrDefault(); if (user != null) { pd.BidWinner = new User(); pd.BidWinner.Email = user.Email; pd.BidWinner.Password = user.Password; pd.BidWinner.Address = user.Address; DAL.Bank b = db.Banks.Where(x => x.Id == user.BankDetailId).FirstOrDefault(); if (b != null) { pd.BidWinner.BankDetails = new Bank(); pd.BidWinner.BankDetails.Id = b.Id; pd.BidWinner.BankDetails.AccountNumber = b.AccountNbr; pd.BidWinner.BankDetails.Balance = b.Balance.HasValue ? b.Balance.Value : 0; } } } pd.Start = pt.Start.HasValue ? pt.Start.Value : DateTime.MinValue; lstAuctions.Add(pd); } return(lstAuctions); }