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