public IHttpActionResult GetSOC124(string id) { List <SOC124> lstSOC124 = db.SOC124.Where(i => i.Cust_id == id).ToList(); List <SOC124Decorator> lstSOC124Decorators = new List <SOC124Decorator>(); foreach (SOC124 soc124 in lstSOC124) { Customer customer = db.Customers.Find(soc124.Cust_id); List <LookUp> via = db.LookUps.Where(i => i.LookUp_Table == "SOC124" && i.LookUp_Name == "Via").ToList(); SOC124Decorator soc124Decorator = new SOC124Decorator(soc124, via, customer); lstSOC124Decorators.Add(soc124Decorator); } return(Ok(lstSOC124Decorators)); }
public IHttpActionResult GetSOC124ByDate(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 <SOC124> lstSOC124 = db.SOC124.Where(i => i.Cust_id == id && (i.compiledDate >= dtFrom && i.compiledDate <= dtTo)).ToList(); List <SOC124Decorator> lstSOC124Decorators = new List <SOC124Decorator>(); foreach (SOC124 soc124 in lstSOC124) { Customer customer = db.Customers.Find(soc124.Cust_id); List <LookUp> via = db.LookUps.Where(i => i.LookUp_Table == "SOC124" && i.LookUp_Name == "Via").ToList(); SOC124Decorator soc124Decorator = new SOC124Decorator(soc124, via, customer); lstSOC124Decorators.Add(soc124Decorator); } return(Ok(lstSOC124Decorators)); }