public PaymentAccountDTO Update(PaymentAccountDTO accountDTO)
{
var sql = DbConnection.iceCreamDb.PaymentAccounts.Where(x => x.PaymentAccId == accountDTO.PaymentAccId).FirstOrDefault();
sql.PaymentAccId = accountDTO.PaymentAccId;
sql.CardHolder = accountDTO.CardHolder;
sql.CardNumber = accountDTO.CardNumber;
DbConnection.iceCreamDb.SaveChanges();
return(accountDTO);
}
public PaymentAccountDTO Insert(PaymentAccountDTO accountDTO)
{
PaymentAccount payment = new PaymentAccount
{
PaymentAccId = accountDTO.PaymentAccId,
CardHolder = accountDTO.CardHolder,
CardNumber = accountDTO.CardNumber,
};
DbConnection.iceCreamDb.PaymentAccounts.Add(payment);
DbConnection.iceCreamDb.SaveChanges();
return(accountDTO);
}
public PaymentAccountDTO GetId(int Id)
{
PaymentAccountDTO accountDTO = new PaymentAccountDTO();
var sql = DbConnection.iceCreamDb.PaymentAccounts.Where(x => x.PaymentAccId == Id).FirstOrDefault();
if (sql != null)
{
accountDTO.PaymentAccId = sql.PaymentAccId;
accountDTO.CardHolder = sql.CardHolder;
accountDTO.CardNumber = Convert.ToInt16(sql.CardNumber);
return(accountDTO);
}
return(accountDTO);
}
public List <PaymentAccountDTO> GetAll()
{
List <PaymentAccountDTO> ListBook = new List <PaymentAccountDTO>();
var sql = (from s in DbConnection.iceCreamDb.PaymentAccounts select s).ToList();
foreach (var s in sql)
{
PaymentAccountDTO accountDTO = new PaymentAccountDTO
{
PaymentAccId = s.PaymentAccId,
CardHolder = s.CardHolder,
CardNumber = Convert.ToInt16(s.CardNumber),
};
ListBook.Add(accountDTO);
}
return(ListBook);
}
public PaymentAccountDTO UpdatePaymentAcc(PaymentAccountDTO accountDTO)
{
return(PaymentAccountDAO.GetInstance().Update(accountDTO));
}
public PaymentAccountDTO InsertPaymentAcc(PaymentAccountDTO accountDTO)
{
return(PaymentAccountDAO.GetInstance().Insert(accountDTO));
}
