public async Task<IHttpActionResult> AddSubscription(Subscription foo) { //var contentType = Request.Content.Headers.ContentType.MediaType; //var pp = System.Web.HttpContext.Current.Request["RegisterBindingModel"]; // Bank foo = Newtonsoft.Json.JsonConvert.DeserializeObject<Bank>(pp) as Bank; // JsonSerializer serializer = JsonSerializer.Create(Configuration.Formatters.JsonFormatter.SerializerSettings); // var requestParams = Request.Content.ReadAsStringAsync().Result; var httpRequest = HttpContext.Current.Request; try { var _db = new ApplicationDbContext(); string currentUserId = User.Identity.GetUserId(); Subscription aaa = new Subscription(); aaa.Subscription_Code = foo.Subscription_Code; aaa.Subscription_Name = foo.Subscription_Name; aaa.Subscription_Type_Code = foo.Subscription_Type_Code; aaa.Amount = foo.Amount; _db.Subscription.Add(aaa); var kk = _db.SaveChanges(); // _db.SaveChanges(); return Ok(); } catch (Exception ee) { return BadRequest(); ; } }
public List<Subscription> GetSubscriptionCode([FromUri] String property1) { var _db = new ApplicationDbContext(); var vv = (from c in _db.Subscription join o in _db.Subscription_Type on new { a = c.Subscription_Type_Code } equals new { a = o.Subscription_Type_Code } where ((c.Subscription_Code == property1)) // where ((c.DateCreated.Date == start_date) && (c.DateCreated.Date <= end_date)) // where (c.DateCreated.Date >= start_date.Date && c.DateCreated.Date <= end_date.Date) select new { c.Subscription_Code, c.Subscription_Name, o.Subscription_Type_Name, c.Amount }).ToList(); List<Subscription> kk = new List<Subscription>(); foreach (var dd in vv) { Subscription xx = new Subscription(); xx.Amount = dd.Amount; xx.Subscription_Code = dd.Subscription_Code; xx.Subscription_Name = dd.Subscription_Name; xx.Subscription_Type_Code = dd.Subscription_Type_Name; kk.Add(xx); } // var ccd = (from c in _db.Subscription_Type select c).ToList(); return kk; }