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));
}
