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