public List <MTDReportObject> BuildMTDReport()
{
List <MTDReportObject> report = new List <MTDReportObject>();
this.mFIs = GetMasterFIs();
ProcessFilters();
//var masterQuery = context.MasterFIs.Where(m => m.Dealerid == Dealership.DealerID && m.salescategory != "6"
// && ((m.salesdate >= StartDate && m.salesdate <= EndDate)
// || (m.unwinddate >= StartDate && m.unwinddate <= EndDate))
// ).ToList();
var masterQuery = mFIs.ToList();
List <OtherIncome> oiQuery = new List <OtherIncome>();
if (Dealership == null || Dealership.DealerID == 0)
{
oiQuery = context.OtherIncomes.Where(o => DealerIDs.Contains((int)o.DealerId) &&
(o.AdjDate >= StartDate && o.AdjDate <= EndDate)).ToList();
}
else
{
oiQuery = context.OtherIncomes.Where(o => o.DealerId == Dealership.DealerID &&
(o.AdjDate >= StartDate && o.AdjDate <= EndDate)).ToList();
}
//if (MasterFilters != null)
//{
// //var masterQuery2 = context.MasterFIs.Where(m => (
// // (m.salesdate >= StartDate && m.salesdate <= EndDate) || (m.unwinddate >= StartDate && m.unwinddate <= EndDate)
// // )).Where("VehicleType=@0","N").ToList();
// masterQuery = masterQuery.Where()
// //.Where("VehicleType=@0", "N").ToList();
//}
//if (vehicleType != null && vehicleType != "All")
//{
// masterQuery = masterQuery.Where(m => m.vehicletype == this.vehicleType).ToList();
// //oiQuery.Where(o=>o.VehicleTypeId)
//}
//var oiQuery2 = context.OtherIncomes.Request(OIFilters).ToList();
MTDReportObject mtdObj = null;
int rowCount = 0;
foreach (var record in masterQuery)
{
mtdObj = new MTDReportObject();
var mRecord = record.Record;
rowCount += 1;
mtdObj.rownum = rowCount;
mtdObj.dealerID = mRecord.Dealerid;
//mtdObj.deal_id = mRecord.dealnum;
mtdObj.deal_status = context.DealStatus.Where(s => s.StatusId == mRecord.status).Select(s => s.StatusName).FirstOrDefault();
mtdObj.deal_delv_date = mRecord.salesdate.ToShortDateString();
mtdObj.deal_stck_num = mRecord.stocknum;
mtdObj.deal_mileage = mRecord.mileage;
mtdObj.deal_customer = mRecord.buyerlname;
mtdObj.deal_year = mRecord.year;
mtdObj.deal_new_used = mRecord.vehicletype;
mtdObj.deal_FIMgr = context.FinanceManagers.Where(f => f.FMId == mRecord.fimanager).Select(f => f.FMName).FirstOrDefault();
mtdObj.deal_sp_1 = context.SalesPersons.Where(sp1 => sp1.ID == mRecord.salesperson1).Select(sp1 => sp1.SPName).FirstOrDefault();
//mtdObj.deal_sp_2 = context.SalesPersons.Where(sp2 => sp2.SPtoMasterId.ToString() == mRecord.salesperson2).Select(sp2 => sp2.SPName).FirstOrDefault();
mtdObj.deal_fin_type = context.FinanceTypes.Where(f => f.FinanceTypeId.ToString() == mRecord.fitype).Select(f => f.FinanceType1).FirstOrDefault();
mtdObj.deal_trade_year = mRecord.trade1year;
mtdObj.deal_trade_model = mRecord.trade1model;
mtdObj.deal_title_status = 1;
mtdObj.deal_trade_value = mRecord.trade1acv;
mtdObj.deal_dent = mRecord.dent;
mtdObj.deal_windsh = mRecord.Maint;
mtdObj.deal_cl = mRecord.cl;
mtdObj.deal_ah = mRecord.ah;
mtdObj.deal_map = (mRecord.vscoption == "Map"? mRecord.vsc : 0);
mtdObj.deal_warr = mRecord.Maint;
mtdObj.deal_gap = mRecord.gap;
mtdObj.deal_etch = mRecord.etch;
mtdObj.deal_tw = mRecord.tirewheel;
mtdObj.deal_enviro = mRecord.enviro;
mtdObj.deal_fin = mRecord.finresv;
mtdObj.deal_frnt_end = Math.Round((decimal)mRecord.payablegross, 0);
mtdObj.deal_back_end = Math.Round((decimal)mRecord.backend, 0);
mtdObj.deal_tot_tot = Math.Round((decimal)mRecord.totalgross, 0);
report.Add(mtdObj);
}
int activeDealCount = rowCount;
foreach (var oRecord in oiQuery)
{
mtdObj = new MTDReportObject();
rowCount += 1;
mtdObj.rownum = rowCount;
mtdObj.dealerID = (int)oRecord.DealerId;
//mtdObj.deal_id = oRecord.DealNum.ToString();
mtdObj.deal_status = oRecord.OtherType == "OI" ? "Other Income" : "Adj.";
mtdObj.deal_delv_date = oRecord.SaleDate.HasValue ? oRecord.SaleDate.Value.ToShortDateString() : "";
mtdObj.deal_customer = oRecord.lname1;
mtdObj.deal_new_used = context.VehicleTypes.Where(oi => oi.VehicleTypeId == oRecord.VehicleTypeId).Select(oi => oi.VehicleType1).First().ToString().Substring(0, 1);
mtdObj.deal_FIMgr = context.FinanceManagers.Where(f => f.FMId == oRecord.FinanceManagerId).Select(f => f.FMName).FirstOrDefault();
mtdObj.deal_frnt_end = Math.Round((decimal)oRecord.PAmount, 0);
report.Add(mtdObj);
}
if (rowCount > 0)
{
var totals = report.Select(r => new
{
ACV = r.deal_trade_value,
Dent = r.deal_dent,
Windsh = r.deal_windsh,
CL = r.deal_cl,
AH = r.deal_ah,
Map = r.deal_map,
Warr = r.deal_warr,
Gap = r.deal_gap,
Etch = r.deal_etch,
TW = r.deal_tw,
//key
//SmartNote
Enviro = r.deal_enviro,
Fin = r.deal_fin,
FrontEnd = r.deal_frnt_end,
BackEnd = r.deal_back_end,
Total = r.deal_tot_tot
});
report.Add(new MTDReportObject
{
rownum = activeDealCount,
deal_trade_value = totals.Select(t => t.ACV).Sum(),
deal_dent = totals.Select(t => t.Dent).Sum(),
deal_windsh = totals.Select(t => t.Windsh).Sum(),
deal_cl = totals.Select(t => t.CL).Sum(),
deal_ah = totals.Select(t => t.AH).Sum(),
deal_map = totals.Select(t => t.Map).Sum(),
deal_warr = totals.Select(t => t.Warr).Sum(),
deal_gap = totals.Select(t => t.Gap).Sum(),
deal_etch = totals.Select(t => t.Etch).Sum(),
deal_tw = totals.Select(t => t.TW).Sum(),
deal_enviro = totals.Select(t => t.Enviro).Sum(),
deal_fin = totals.Select(t => t.Fin).Sum(),
deal_frnt_end = totals.Select(t => t.FrontEnd).Sum(),
deal_back_end = totals.Select(t => t.BackEnd).Sum(),
deal_tot_tot = totals.Select(t => t.Total).Sum()
});
}
return(report);
}
public void PreLoadLists()
{
context = new FowlerDORContext();
this.Dealerships = context.DealerShips.Where(d => (d.DisableDate == null || d.DisableDate > DateTime.Now) && DealerIDs.Contains(d.DealerID)).ToList();
this.BusinessSources = context.BUSINESSSOURCEs.Where(b => b.DisableDate == null).ToList();
this.FinanceTypes = context.FinanceTypes.ToList();
this.VehicleTypes = context.VehicleTypes.ToList();
this.DealStatuses = context.DealStatus.ToList();
this.VehicleKinds = context.Vehicles.Where(v => v.DisableDate == null).ToList();
this.SalesCategories = context.SalesCategories.ToList();
this.GradeCredits = context.GradeCredits.ToList();
}
public ListOfDealsViewModel(int userID) : base(userID)
{
this.Dealerships = context.DealerShips.Where(d => (d.DisableDate == null || d.DisableDate > DateTime.Now) && DealerIDs.Contains(d.DealerID)).ToList();
this.Dealership = Dealerships.First();
this.SearchByFilters = new List <SearchObject>
{
new SearchObject {
ID = 1, Value = "Deal Number"
},
new SearchObject {
ID = 2, Value = "Stock Number"
},
new SearchObject {
ID = 3, Value = "Last Name"
},
new SearchObject {
ID = 4, Value = "First Name"
},
new SearchObject {
ID = 5, Value = "Sales Date"
},
new SearchObject {
ID = 6, Value = "Delivery Date"
},
};
this.Deals = new DealBiz().GetListOfDealsSummary(this.Dealership.DealerID);
}
public AdminAddUserViewModel(int userID) : base(userID)
{
context = new FowlerDORContext();
Dealerships = context.DealerShips.Where(d => (d.DisableDate == null || d.DisableDate > DateTime.Now) && DealerIDs.Contains(d.DealerID)).ToList();
Roles = context.Roles.Where(r => r.Id != "1").Select(r => r).ToList();
Roles.Add(new Role {
Id = "0", Name = "No Access"
});
UserRoleObjects = new List <UserRoleObj>();
foreach (var dealer in Dealerships)
{
UserRoleObjects.Add(new UserRoleObj
{
IsActive = false,
DealerID = dealer.DealerID,
DealerName = dealer.DealerName,
RoleID = "0"
});
}
}
