예제 #1
0
         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; ;
             }




         }
예제 #2
0
        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; ;
            }




        }