public ResponseData AddAccountDetails(AccountDetails act)
{
ResponseData response = new ResponseData();
try{
var validation = db.AccountDetails.Where(x => x.Name.ToLower() == act.Name.ToLower());
if (validation.Count() > 0)
{
response.Message = CustomMessage.SameAct;
response.Code = (int)HttpStatusCode.BadRequest;
return(response);
}
if (act.MontlyCl == 0)
{
response.Message = CustomMessage.MinAmt;
response.Code = (int)HttpStatusCode.BadRequest;
return(response);
}
db.AccountDetails.Add(act);
db.SaveChanges();
response.Message = CustomMessage.DataSaved;
response.Code = (int)HttpStatusCode.OK;
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseData AddPayments(PaymentDetails payment)
{
try{
response = new ResponseData();
if (payment.TransactionAmount == 0)
{
response.Message = CustomMessage.MinAmt;
response.Code = (int)HttpStatusCode.BadRequest;
return(response);
}
AccountDetails act;
act = db.AccountDetails.Find(payment.AccountId);
int currentMonth = DateTime.Now.Month;
IQueryable <PaymentDetails> objPayments = db.PaymentDetails.Where(x => x.AccountId == payment.AccountId && payment.TransactionDate.Value.Month == currentMonth);
int usedLimit = objPayments.Select(x => x.TransactionAmount.Value).Sum();
if (usedLimit + payment.TransactionAmount <= act.MontlyCl)
{
db.PaymentDetails.Add(payment);
db.SaveChanges();
response.Message = CustomMessage.Paid;
response.Code = (int)HttpStatusCode.OK;
}
else
{
response.Message = CustomMessage.NoBalance;
response.Code = (int)HttpStatusCode.BadRequest;
}
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddUser(UserMaster user)
{
try
{
db.UserMaster.Add(user);
db.SaveChanges();
return(CustomMessage.DataSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseData AddAccountDetails(AccountDetails act)
{
ResponseData response = new ResponseData();
try{
db.AccountDetails.Add(act);
db.SaveChanges();
response.Message = CustomMessage.DataSaved;
response.Code = (int)HttpStatusCode.OK;
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddUser(UserMaster user)
{
EncryptDecrypt objEncDec = new EncryptDecrypt();
try
{
user.Password = objEncDec.EncryptData(user.Password);
user.UserId = 0;
db.UserMaster.Add(user);
db.SaveChanges();
return(CustomMessage.DataSaved);
}
catch (Exception ex)
{
throw ex;
}
}
