public HttpResponseMessage DeleteBenificiary(int id, string account_no)
{
DbContextTransaction trans = entities.Database.BeginTransaction();
try
{
int accountNo = Convert.ToInt32(account_no);
tblBeneficiary beneficiary = entities.tblBeneficiaries.Where(b => b.beneficiary_account_number == id && b.account_number == accountNo).FirstOrDefault();
if (beneficiary == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Beneficiary not found"));
}
else
{
entities.tblBeneficiaries.Remove(beneficiary);
entities.SaveChanges();
trans.Commit();
return(Request.CreateResponse <tblBeneficiary>(HttpStatusCode.OK, beneficiary));
}
}
catch (Exception)
{
trans.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Oops! Something went wrong. Unable to Delete Beneficiary!"));
}
}
public HttpResponseMessage AddBenificiary(tblBeneficiary beneficiary)
{
tblBalance balance = entities.tblBalances.Where(b => b.account_number == beneficiary.account_number).FirstOrDefault();
if (beneficiary == null)
{
entities.tblBeneficiaries.Add(beneficiary);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, beneficiary));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Benificiary already exists"));
}
}
public HttpResponseMessage AddBenificiary(tblBeneficiary beneficiary)
{
DbContextTransaction trans = entities.Database.BeginTransaction();
try
{
tblNetBanking customer = entities.tblNetBankings.Where(c => c.account_number == beneficiary.beneficiary_account_number).FirstOrDefault();
if (customer == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Benificiary Account Number does not exist"));
}
else
{
if (beneficiary.account_number == beneficiary.beneficiary_account_number)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid Account Number"));
}
tblBeneficiary beneficiary1 = entities.tblBeneficiaries.Where(b => b.beneficiary_account_number == beneficiary.beneficiary_account_number && b.account_number == beneficiary.account_number).FirstOrDefault();
if (beneficiary1 == null)
{
beneficiary.customer_id = customer.user_id;
entities.tblBeneficiaries.Add(beneficiary);
entities.SaveChanges();
trans.Commit();
return(Request.CreateResponse <tblBeneficiary>(HttpStatusCode.Created, beneficiary));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Benificiary already added"));
}
}
}
catch (Exception)
{
trans.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to add Beneficiary"));
}
}
