Example #1
0
 public static List <ModelAndFuelTypeStatus> MonthAndFuelTypeStatus(FilterData Obj)
 {
     using (var Context = new BSSDBEntities())
     {
         List <ModelAndFuelTypeStatus> ModelAndFuelTypeStatus = null;
         var ReqData = Context.sp_ModelAndFuelTypeStatus(Obj.DealerID, Obj.AccountId, Obj.Month, Obj.Year).ToList();
         if (ReqData.Count != 0)
         {
             ModelAndFuelTypeStatus = ReqData.Select(x => new ModelAndFuelTypeStatus
             {
                 GrandTotal = x.GrandTotal == null ? 0 : x.GrandTotal,
                 Model      = x.Model
             }).ToList();
             ModelAndFuelTypeStatus.Add(new BODYSHPBLL.ImplBLL.ModelAndFuelTypeStatus {
                 Model      = "Total",
                 GrandTotal = ReqData.Sum(x => x.GrandTotal)
             });
             return(ModelAndFuelTypeStatus);
         }
         else
         {
             return(ModelAndFuelTypeStatus);
         }
     }
 }