public IHttpActionResult GetSMACompilation(string id, string fromDate, string toDate) { DateTime dtFrom = Convert.ToDateTime(DateTime.ParseExact(fromDate, "dd-MM-yyyy", CultureInfo.InvariantCulture)); DateTime dtTo = Convert.ToDateTime(DateTime.ParseExact(toDate, "dd-MM-yyyy", CultureInfo.InvariantCulture)); List <SMAHistory> sMAHistories = db.SMAHistories.Where(i => i.Cust_Id == id && (i.CompiledDate >= dtFrom && i.CompiledDate <= dtTo)).ToList(); if (sMAHistories == null || sMAHistories.Count() <= 0) { return(NotFound()); } Customer customer = db.Customers.Find(sMAHistories[0].Cust_Id); SMACompilation sMACompilation = new SMACompilation(); List <SMABucket> sMABuckets = new List <SMABucket>(); try { sMACompilation = db.SMACompilations.Where(i => i.Cust_id == id).FirstOrDefault(); sMABuckets = db.SMABuckets.Where(i => i.Cust_Id == id).ToList(); } catch { } SMACompilationDecorator sMACompilationDecorator = new SMACompilationDecorator(sMACompilation, sMAHistories, customer, sMABuckets); return(Ok(sMACompilationDecorator)); }
public IHttpActionResult PutSMACompilation(int id, SMACompilation sMACompilation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != sMACompilation.Id) { return(BadRequest()); } db.Entry(sMACompilation).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!SMACompilationExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public SMACompilationDecorator(SMACompilation _data, List <SMAHistory> _sMAHistories, Customer _customer, List <SMABucket> _sMABuckets) { entData = _data; customer = _customer; sMAHistories = _sMAHistories; sMABuckets = _sMABuckets; }