public async Task<IHttpActionResult> GetTransactionService(FormDataCollection form) { string parameter1 = ""; var httpRequest = HttpContext.Current.Request; string tranid = form.Get("transactionid"); var _db = new ApplicationDbContext(); var foo = (from c in _db.Transaction where c.Transaction_Code == tranid select c).FirstOrDefault(); foo.Payment_Status = "Paid"; _db.SaveChanges(); try { // string currentUserId = User.Identity.GetUserId(); Subscription_Details aaa = new Subscription_Details(); aaa.Payment_Date =foo.Transaction_Date.Value; aaa.Subscription_Code = foo.Subscription_Code; aaa.Transaction_id = foo.Transaction_Code; aaa.user_id = foo.user_id; aaa.Used = false; if (foo.Subscription_Code == "NG002") { aaa.Expiry_Date = foo.Transaction_Date.Value.AddMonths(1); } else if (foo.Subscription_Code == "NG003") { aaa.Expiry_Date = foo.Transaction_Date.Value.AddYears(1); } else { aaa.Expiry_Date = null; } _db.Subscription_Details.Add(aaa); var kk = _db.SaveChanges(); _db.SaveChanges(); // _db.SaveChanges(); // return aaa.Transaction_Code; return Ok(); } catch (Exception ee) { return BadRequest(); ; // return ee.Message; ; } }
public void AddSubscription_Detail3(Subscription_Detail2 foo) { string parameter1 = ""; var httpRequest = HttpContext.Current.Request; try { var _db = new ApplicationDbContext(); // string currentUserId = User.Identity.GetUserId(); Subscription_Details aaa = new Subscription_Details(); aaa.Payment_Date = foo.Payment_Date; aaa.Subscription_Code = foo.Subscription_Code; aaa.user_id = foo.user_id; aaa.Transaction_id = foo.Transaction_Code; aaa.Service = foo.Service; aaa.Used = false; if (foo.Subscription_Code == "NG002") { aaa.Expiry_Date = foo.Payment_Date.AddMonths(1); } else if (foo.Subscription_Code == "NG003") { aaa.Expiry_Date = foo.Payment_Date.AddYears(1); } else { aaa.Expiry_Date = null; } _db.Subscription_Details.Add(aaa); var kk = _db.SaveChanges(); var cc = (from c in _db.Transaction where c.Transaction_Code == foo.Transaction_Code select c).FirstOrDefault(); cc.Payment_Status = "Paid"; _db.SaveChanges(); // _db.SaveChanges(); // return aaa.Transaction_Code; // return Ok(); } catch (Exception ee) { // return BadRequest(); ; // return ee.Message; ; } }