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