public PartialViewResult Results(HomeViewModels vm) //Partial View
{
ResultsManager mgr = new ResultsManager();
vm.notesList = mgr.Get_Notes(vm.queryID);
vm.UB_Munis_List = mgr.Get_UB_Munis(vm.queryID);
vm.UB_ComPlus_List = mgr.Get_UB_ComPlus(vm.queryID);
vm.APVendors_FinPlus_List = mgr.Get_APVendors_FinPlus(vm.queryID);
vm.Alarm_Billing_ComPlus_List = mgr.Get_Alarm_Billing_ComPlus(vm.queryID);
vm.BL_ComPlus_List = mgr.Get_BL_ComPlus(vm.queryID);
vm.LEADS_PermPlus_List = mgr.Get_LEADS_PermPlus(vm.queryID);
vm.GB_Munis_List = mgr.Get_GB_Munis(vm.queryID);
vm.APVendors_Munis_List = mgr.Get_APVendors_Munis(vm.queryID);
vm.Turbo_Citations_List = mgr.Get_Turbo_Citations(vm.queryID);
return(PartialView("_Results", vm));
}
public PartialViewResult _Uncluster(string queryID)
{
ViewBag.success = false;
ResultsManager mgr = new ResultsManager();
HomeViewModels vm = new HomeViewModels();
vm.notesList = mgr.Get_Notes(queryID);
vm.UB_Munis_List = mgr.Get_UB_Munis(queryID);
vm.UB_ComPlus_List = mgr.Get_UB_ComPlus(queryID);
vm.APVendors_FinPlus_List = mgr.Get_APVendors_FinPlus(queryID);
vm.Alarm_Billing_ComPlus_List = mgr.Get_Alarm_Billing_ComPlus(queryID);
vm.BL_ComPlus_List = mgr.Get_BL_ComPlus(queryID);
vm.LEADS_PermPlus_List = mgr.Get_LEADS_PermPlus(queryID);
vm.GB_Munis_List = mgr.Get_GB_Munis(queryID);
vm.APVendors_Munis_List = mgr.Get_APVendors_Munis(queryID);
vm.Turbo_Citations_List = mgr.Get_Turbo_Citations(queryID);
vm.queryID = queryID;
return(PartialView(vm));
}
public PartialViewResult _Uncluster(HomeViewModels vm)
{
ViewBag.success = false;
ResultsManager rmgr = new ResultsManager();
HomeViewModels tempVM = new HomeViewModels();
tempVM.notesList = rmgr.Get_Notes(vm.queryID);
tempVM.UB_Munis_List = rmgr.Get_UB_Munis(vm.queryID);
tempVM.UB_ComPlus_List = rmgr.Get_UB_ComPlus(vm.queryID);
tempVM.APVendors_FinPlus_List = rmgr.Get_APVendors_FinPlus(vm.queryID);
tempVM.Alarm_Billing_ComPlus_List = rmgr.Get_Alarm_Billing_ComPlus(vm.queryID);
tempVM.BL_ComPlus_List = rmgr.Get_BL_ComPlus(vm.queryID);
tempVM.LEADS_PermPlus_List = rmgr.Get_LEADS_PermPlus(vm.queryID);
tempVM.GB_Munis_List = rmgr.Get_GB_Munis(vm.queryID);
tempVM.APVendors_Munis_List = rmgr.Get_APVendors_Munis(vm.queryID);
tempVM.Turbo_Citations_List = rmgr.Get_Turbo_Citations(vm.queryID);
tempVM.queryID = vm.queryID;
tempVM.newQueryID = vm.newQueryID;
UnclusterManager umgr = new UnclusterManager();
if (!string.IsNullOrEmpty(vm.newQueryID))
{
//UB MUNIS
for (int i = 0; i < vm.UB_Munis_List.Count; i++)
{
if (vm.UB_Munis_List[i].isChecked)
{
tempVM.UB_Munis_List[i].isChecked = true;
tempVM.CustomerNo = tempVM.UB_Munis_List[i].cust_ser;
umgr.Uncluster_UB_Munis(tempVM);
}
}
//GB MUNIS
for (int i = 0; i < vm.GB_Munis_List.Count; i++)
{
if (vm.GB_Munis_List[i].isChecked)
{
tempVM.GB_Munis_List[i].isChecked = true;
tempVM.CustomerNo = tempVM.GB_Munis_List[i].cust_ser;
umgr.Uncluster_GB_Munis(tempVM);
}
}
//APVendors MUNIS
for (int i = 0; i < vm.APVendors_Munis_List.Count; i++)
{
if (vm.APVendors_Munis_List[i].isChecked)
{
tempVM.APVendors_Munis_List[i].isChecked = true;
tempVM.VendorNo = tempVM.APVendors_Munis_List[i].AccountNo;
umgr.Uncluster_APVendors_Munis(tempVM);
}
}
//UB COMPLUS
for (int i = 0; i < vm.UB_ComPlus_List.Count; i++)
{
if (vm.UB_ComPlus_List[i].isChecked)
{
tempVM.UB_ComPlus_List[i].isChecked = true;
tempVM.AccountNo = tempVM.UB_ComPlus_List[i].AccountNo;
tempVM.CustomerNo = tempVM.UB_ComPlus_List[i].cust_ser;
umgr.Uncluster_UB_ComPlus(tempVM);
}
}
//ALARM BILLING COMPLUS
for (int i = 0; i < vm.Alarm_Billing_ComPlus_List.Count; i++)
{
if (vm.Alarm_Billing_ComPlus_List[i].isChecked)
{
tempVM.Alarm_Billing_ComPlus_List[i].isChecked = true;
tempVM.CustomerNo = tempVM.Alarm_Billing_ComPlus_List[i].cust_ser;
umgr.Uncluster_Alarm_Billing_ComPlus(tempVM);
}
}
//BUSINESS LICENSE COMPLUS
for (int i = 0; i < vm.BL_ComPlus_List.Count; i++)
{
if (vm.BL_ComPlus_List[i].isChecked)
{
tempVM.BL_ComPlus_List[i].isChecked = true;
tempVM.CustomerNo = tempVM.BL_ComPlus_List[i].cust_ser;
umgr.Uncluster_Business_License_ComPlus(tempVM);
}
}
//AP VENDORS FINPLUS
for (int i = 0; i < vm.APVendors_FinPlus_List.Count; i++)
{
if (vm.APVendors_FinPlus_List[i].isChecked)
{
tempVM.APVendors_FinPlus_List[i].isChecked = true;
tempVM.AccountNo = tempVM.APVendors_FinPlus_List[i].AccountNo;
umgr.Uncluster_APVendors_FinPlus(tempVM);
}
}
//LEADS PERMITS PLUS
for (int i = 0; i < vm.LEADS_PermPlus_List.Count; i++)
{
if (vm.LEADS_PermPlus_List[i].isChecked)
{
tempVM.LEADS_PermPlus_List[i].isChecked = true;
tempVM.AccountNo = tempVM.LEADS_PermPlus_List[i].AccountNo;
umgr.Uncluster_LEADS_PermPlus(tempVM);
}
}
//TURBO JASMINE
for (int i = 0; i < vm.Turbo_Citations_List.Count; i++)
{
if (vm.Turbo_Citations_List[i].isChecked)
{
tempVM.Turbo_Citations_List[i].isChecked = true;
tempVM.AccountNo = tempVM.Turbo_Citations_List[i].AccountNo;
umgr.Uncluster_Turbo_Citations(tempVM);
umgr.Uncluster_Turbo_Temp_Tables(tempVM);
}
}
ViewBag.success = true;
}
return(PartialView(tempVM));
}