public HttpResponseMessage Post([FromUri] int id, [FromBody] tbl_Customer customer) { System.Data.Entity.DbContextTransaction transaction = entities.Database.BeginTransaction(); tbl_Card card = new tbl_Card(); try { tbl_Card c = entities.tbl_Card.Where(ca => ca.Customer_Id == customer.Customer_Id).FirstOrDefault(); if (c != null) { return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Customer already activated.")); } proc_ActivateCustomer_Result rslt = entities.proc_ActivateCustomer(customer.Customer_Id).FirstOrDefault(); card.Customer_Id = customer.Customer_Id; card.Card_Number = RandomDigits(10); card.Valid_till = DateTime.Today.AddYears(2).Date; card.Card_Type = customer.Card_Type; card.Total_credit = customer.Card_Type == "Gold" ? 50000 : 100000; card.credit_used = 0; card.Card_cost = customer.Card_Type == "Gold" ? 1000 : 2000; card.Status = "Activated"; tbl_Admin admin = entities.tbl_Admin.Where(a => a.Admin_Id == id).FirstOrDefault(); card.ApprovedBy = id; entities.tbl_Card.Add(card); entities.SaveChanges(); proc_ActivateCard_Result result = entities.proc_ActivateCard(customer.Customer_Id).FirstOrDefault(); transaction.Commit(); return(Request.CreateResponse(HttpStatusCode.Created, card)); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Could not add card")); } }
public HttpResponseMessage Get(int id)//customerId { tbl_Card card = entities.tbl_Card.Where(c => c.Customer_Id == id).FirstOrDefault(); if (card != null) { return(Request.CreateResponse(HttpStatusCode.OK, card)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Card does not exist..")); } }