public static List <MonthWiseReport> GetMonthWiseReport(MonthWiseInput obj) { List <MonthWiseReport> Result = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SP_ConsolidatedReport(obj.DealerID, obj.AccountID, obj.Days).ToList(); Result = ReqData.Select(x => new MonthWiseReport { ContractorName = x.ContractorName, DateAndTime = x.DateAndTime.Value.ToString("dd/MM/yyyy"), JobCardNo = x.JobCardNo, Model = x.Model, CustomerName = x.CustomerName, ModifiedDate = x.ModifiedDate, No_of_Panel = x.No_of_Panel, Panel_Replaced = x.Panel_Replaced, PhoneNo = x.PhoneNo, PromisedDate = x.PromisedDate, RegistrationNo = x.RegistrationNo, Service = x.Service, StatusName = x.StatusName, CompanyName = x.CompanyName, NoOfGlass = x.NoOfGlass, PaymentMode = x.PaymentMode, PhotoUrl = x.PhotoUrl }).ToList(); } return(Result); }
public List <MonthWiseReport> GetMonthWiseReport(MonthWiseInput obj) { return(ReportsDAL.GetMonthWiseReport(obj)); }