public DashboardVM GetQuotationCount()
{
try
{
DashboardVM objDashboardVM = new DashboardVM();
PERFECTIBSEntities db = new PERFECTIBSEntities();
objDashboardVM.PendingQuotationCount = unitOfWork.TblQuotationHeaderRepository.Get(o => o.QuotationStatusCode.Equals("QP")).Count();
objDashboardVM.ApprovedQuotationCount = unitOfWork.TblQuotationHeaderRepository.Get(o => o.QuotationStatusCode.Equals("CA")).Count();
objDashboardVM.NotCreatingQuotationCount = unitOfWork.TblQuotationHeaderRepository.Get(o => o.QuotationStatusCode.Equals("QNC")).Count();
objDashboardVM.TCNIQuotationCount = unitOfWork.TblQuotationHeaderRepository.Get(o => o.QuotationStatusCode.Equals("TCNI")).Count();
objDashboardVM.QuotationTotalCount = unitOfWork.TblQuotationHeaderRepository.Get().Count();
objDashboardVM.ClientRequestCount = unitOfWork.TblClientRequestHeaderRepository.Get().Count();
List <sp_GetClientVSQuotation_Count_Result> ListItems = db.sp_GetClientVSQuotation_Count().ToList <sp_GetClientVSQuotation_Count_Result>();
// objDashboardVM.ClientRequestWithQuotation = ListItems;
return(objDashboardVM);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ClientWithQuotationCount> GetClienVSQuotation()
{
try
{
PERFECTIBSEntities db = new PERFECTIBSEntities();
var QuotationData = db.sp_GetClientVSQuotation_Count().ToList();
// List<sp_GetClientVSQuotation_Count_Result> ListItems = db.sp_GetClientVSQuotation_Count().ToList<sp_GetClientVSQuotation_Count_Result>();
List <ClientWithQuotationCount> List = new List <ClientWithQuotationCount>();
foreach (var Quotation in QuotationData)
{
ClientWithQuotationCount ClientQuoVM = new ClientWithQuotationCount();
ClientQuoVM.count = Quotation.COUNTS;
ClientQuoVM.January = Quotation.January.ToString();
ClientQuoVM.Febrary = Quotation.Febrary.ToString();
ClientQuoVM.March = Quotation.March.ToString();
ClientQuoVM.April = Quotation.April.ToString();
ClientQuoVM.May = Quotation.May.ToString();
ClientQuoVM.June = Quotation.June.ToString();
ClientQuoVM.July = Quotation.July.ToString();
ClientQuoVM.August = Quotation.August.ToString();
ClientQuoVM.September = Quotation.September.ToString();
ClientQuoVM.October = Quotation.October.ToString();
ClientQuoVM.November = Quotation.November.ToString();
ClientQuoVM.December = Quotation.December.ToString();
List.Add(ClientQuoVM);
}
return(List);
}
catch (Exception ex)
{
throw ex;
}
}