public ActionResult DashboardTechnicalOverview(FormCollection fc) { if (Session["userid"] == null) { return(RedirectToAction("Login", "Account")); } else { if (WebConfigure.GetLoginPortal() == "true" && Common.GetUserXupj().ToLower() != Session["username"].ToString().ToLower()) { return(RedirectToAction("Login", "Account")); } this.setViewBag(); var modelFormCollection = new GetFormCollectionOverview(); bool btnPOST = true; ViewBag.urlModel = WebConfigure.GetDomain() + "/Dashboard/DashboardTechnicalOverview?filterType=" + fc["filterType"] + "&Area=" + fc["Area"] + "&Model=" + fc["Model"] + "&Family=" + fc["Family"] + "&Industry=" + fc["Industry"] + "&SerialNumber=" + fc["SerialNumber"] + "&Customer=" + fc["Customer"] + "&SalesOffice=" + fc["SalesOffice"] + "&deliveryDate=" + fc["deliveryDate"] + "&purchaseDate=" + fc["purchaseDate"] + "&repairDate=" + fc["repairDate"] + "&SMURangeFrom=" + fc["SMURangeFrom"] + "&SMURangeTo=" + fc["SMURangeTo"] + "&ModelMEP=" + fc["ModelMEP"] + "&SerialNumberMEP=" + fc["SerialNumberMEP"] + "&CustomerMEP=" + fc["CustomerMEP"] + "&Plant=" + fc["PlantDescription"] + "&Product=" + fc["Product"] + "&hid=" + fc["hid"] + "&rental=" + fc["rental"] + "&other=" + fc["other"] + "&btnPOST=" + btnPOST ; if (Convert.ToInt32(fc["filterType"]) == 1) { var strSerialNumber = (fc["SerialNumber"] != null) ? fc["SerialNumber"] : String.Empty; var strCustomer = (fc["Customer"] != null) ? fc["Customer"] : String.Empty; var strModel = (fc["Model"] != null) ? fc["Model"] : String.Empty; var strplantDescription = (fc["PlantDescription"] != null) ? fc["PlantDescription"] : String.Empty; var strplantProduct = (fc["Product"] != null) ? fc["Product"] : String.Empty; modelFormCollection.Customer = strCustomer; modelFormCollection.Model = strModel; modelFormCollection.SerialNumber = strSerialNumber; modelFormCollection.Plant = strplantDescription; modelFormCollection.Product = strplantProduct; } else { var purchasedatefrom = ""; var purchasedateto = ""; var deliverydatefrom = ""; var deliverydateto = ""; var repairdatefrom = ""; var repairdateto = ""; if (fc["purchaseDate"] != null) { var strList = fc["purchaseDate"].Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { purchasedatefrom = strList[0]; purchasedateto = strList[4]; } else { purchasedatefrom = strList[0]; } } else { purchasedatefrom = ""; purchasedateto = ""; } if (fc["deliveryDate"] != null) { var strList = fc["deliveryDate"].Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { deliverydatefrom = strList[0]; deliverydateto = strList[4]; } else { deliverydatefrom = strList[0]; } } else { deliverydatefrom = ""; deliverydateto = ""; } if (fc["repairDate"] != null) { var strList = fc["repairDate"].Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { repairdatefrom = strList[0]; repairdateto = strList[4]; } else { repairdatefrom = strList[0]; } } else { repairdatefrom = ""; repairdateto = ""; } var strArea = (fc["Area"] != null) ? fc["Area"] : String.Empty; var strSalesOffice = (fc["SalesOffice"] != null) ? fc["SalesOffice"] : String.Empty; var strCustomer = (fc["CustomerMEP"] != null) ? fc["CustomerMEP"] : String.Empty; var strFamily = (fc["Family"] != null) ? fc["Family"] : String.Empty; var strIndustry = (fc["Industry"] != null) ? fc["Industry"] : String.Empty; var strModel = (fc["ModelMEP"] != null) ? fc["ModelMEP"] : String.Empty; var strSerialNumber = (fc["SerialNumberMEP"] != null) ? fc["SerialNumberMEP"] : String.Empty; var strSMURangeFrom = (!String.IsNullOrWhiteSpace(fc["SMURangeFrom"])) ? Convert.ToInt32(fc["SMURangeFrom"]) : 0; var strSMURangeTo = (!String.IsNullOrWhiteSpace(fc["SMURangeTo"])) ? Convert.ToInt32(fc["SMURangeTo"]) : 0; modelFormCollection.Area = strArea; modelFormCollection.SalesOffice = strSalesOffice; modelFormCollection.Customer = strCustomer; modelFormCollection.Family = strFamily; modelFormCollection.Industry = strIndustry; modelFormCollection.Model = strModel; modelFormCollection.SerialNumber = strSerialNumber; modelFormCollection.SMURangeFrom = strSMURangeFrom; modelFormCollection.SMURangeTo = strSMURangeTo; modelFormCollection.PurchaseDateFrom = purchasedatefrom; modelFormCollection.PurchaseDateEnd = purchasedateto; modelFormCollection.DeliveryDateEnd = deliverydateto; modelFormCollection.DeliveryDateFrom = deliverydatefrom; modelFormCollection.LastRepairDateEnd = repairdateto; modelFormCollection.LastRepairDateFrom = repairdatefrom; } var Hid = (fc["hid"] != null) ? fc["hid"] : ""; var Rental = (fc["rental"] != null) ? fc["rental"] : ""; var Others = (fc["other"] != null) ? fc["other"] : ""; modelFormCollection.HID = Hid; modelFormCollection.Rental = Rental; modelFormCollection.Others = Others; modelFormCollection.paramsModel = String.Empty; modelFormCollection.paramsSerialNumber = String.Empty; modelFormCollection.btnPOST = btnPOST; var DataRelatedTicketOverview = getListTableRelatedTROverview(fc, Hid, Rental, Others, fc["model"], null, btnPOST); var DataRelatedDPPMOverview = GetTableRelatedDPPMOverview(fc, Hid, Rental, Others, fc["model"], null, btnPOST); ViewBag.TicketDataOverview = DataRelatedTicketOverview.Item1; ViewBag.TicketDataCountOverview = DataRelatedTicketOverview.Item2; ViewBag.RelatedDPPMData = DataRelatedDPPMOverview.Item1; ViewBag.RelatedDPPMDataCount = DataRelatedDPPMOverview.Item2; ViewBag.ModelFormCollectionOverview = modelFormCollection; ViewBag.FilterType = Convert.ToInt32(fc["filterType"]); return(View()); } }
public Tuple <List <DPPMSummary>, int> GetTableRelatedDPPMOverviewGet(GetFormCollectionOverview collection, string Hid, string Rental, string Others, string paramsModel = null, string paramsSerialNumber = null, bool btnPOST = false) { string[] SplitArea = new string[] { }; string[] SplitCustomer = new string[] { }; string[] SplitFamily = new string[] { }; string[] SplitIndustry = new string[] { }; string[] SplitSalesOffice = new string[] { }; string[] SplitModel = new string[] { }; string[] SplitSerialNumber = new string[] { }; string[] SplitProduct = new string[] { }; string[] SplitPlant = new string[] { }; var purchasedatefrom = ""; var purchasedateto = ""; var deliverydatefrom = ""; var deliverydateto = ""; var repairdatefrom = ""; var repairdateto = ""; if (collection.FilterType == 1) { if (!string.IsNullOrWhiteSpace(collection.SerialNumber)) { SplitSerialNumber = collection.SerialNumber.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Customer_Name)) { SplitCustomer = collection.Customer_Name.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Model)) { SplitModel = collection.Model.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Product)) { SplitProduct = collection.Product.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Product)) { SplitPlant = collection.Product.Split(','); } } else { if (collection.PurchaseDateEnd != null && collection.PurchaseDateFrom != null) { var strList = collection.PurchaseDateFrom.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { purchasedatefrom = strList[0]; purchasedateto = strList[4]; } else { purchasedatefrom = strList[0]; } } else { purchasedatefrom = ""; purchasedateto = ""; } if (collection.DeliveryDateFrom != null) { var strList = collection.DeliveryDateFrom.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { deliverydatefrom = strList[0]; deliverydateto = strList[4]; } else { deliverydatefrom = strList[0]; } } else { deliverydatefrom = ""; deliverydateto = ""; } if (collection.LastRepairDateFrom != null) { var strList = collection.LastRepairDateFrom.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { repairdatefrom = strList[0]; repairdateto = strList[4]; } else { repairdatefrom = strList[0]; } } else { repairdatefrom = ""; repairdateto = ""; } if (!string.IsNullOrWhiteSpace(collection.SerialNumber)) { SplitSerialNumber = collection.SerialNumber.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Customer)) { SplitCustomer = collection.Customer.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Model)) { SplitModel = collection.Model.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Area)) { SplitArea = collection.Area.Split(','); } if (!string.IsNullOrWhiteSpace(collection.SalesOffice)) { SplitSalesOffice = collection.SalesOffice.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Family)) { SplitFamily = collection.Family.Split(','); } if (!string.IsNullOrWhiteSpace(collection.Industry)) { SplitIndustry = collection.Industry.Split(','); } } string[] dataFiltered = getListSerialNumberFiltered(collection.FilterType, SplitArea, SplitSalesOffice, SplitCustomer, SplitFamily, SplitIndustry, SplitModel, SplitSerialNumber, repairdatefrom, repairdateto, purchasedatefrom, purchasedateto, deliverydatefrom, deliverydateto, collection.SMURangeFrom.ToString(), collection.SMURangeTo.ToString(), SplitProduct, SplitPlant, Hid, Rental, Others, paramsModel, paramsSerialNumber, btnPOST); var getData = _DPPMSummaryBs.getDataDPPMSummaryOverview(dataFiltered); return(Tuple.Create(getData.Item1, getData.Item2)); }
// GET: DashboardTechnicalOverview public ActionResult DashboardTechnicalOverview(int filterType = 0, string Area = null, string Model = null, string Family = null, string Industry = null, string SerialNumber = null, string Customer = null, string SalesOffice = null, string deliveryDate = null, string purchaseDate = null, string repairDate = null, string SMURangeFrom = null, string SMURangeTo = null, string ModelMEP = null, string SerialNumberMEP = null, string CustomerMEP = null, string Plant = null, string Product = null, string hid = null, string rental = null, string other = null, string paramsModel = null, string paramsSerialNumber = null, bool btnPOST = false) { if (Session["userid"] == null) { return(RedirectToAction("Login", "Account")); } else { if (WebConfigure.GetLoginPortal() == "true" && Common.GetUserXupj().ToLower() != Session["username"].ToString().ToLower()) { return(RedirectToAction("Login", "Account")); } this.setViewBag(); var modelFormCollection = new GetFormCollectionOverview(); var strArea = Area; var strSalesOffice = SalesOffice; var strCustomer = CustomerMEP; var strFamily = Family; var strIndustry = Industry; var strModel = ModelMEP; var strSerialNumber = SerialNumberMEP; var strSMURangeFrom = SMURangeFrom; var strSMURangeTo = SMURangeTo; var strpurchaseDateFrom = String.Empty; var strdeliveryDateFrom = String.Empty; var strrepairDateFrom = String.Empty; var strpurchaseDateEnd = String.Empty; var strdeliveryDateEnd = String.Empty; var strrepairDateEnd = String.Empty; var Hid = hid; var Rental = rental; var Others = other; var strcustomer = ""; var strmodel = ""; var strserialnumber = ""; var strplant = ""; var strproduct = ""; if (filterType == 1) { strcustomer = Customer; strmodel = Model; strserialnumber = SerialNumber; strplant = Plant; strproduct = Product; } else { strcustomer = CustomerMEP; strmodel = ModelMEP; strserialnumber = SerialNumberMEP; if (purchaseDate != null) { var strList = purchaseDate.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { strpurchaseDateFrom = strList[0]; strpurchaseDateEnd = strList[4]; } else { strpurchaseDateFrom = strList[0]; } } else { strpurchaseDateFrom = String.Empty; strpurchaseDateEnd = String.Empty; } if (deliveryDate != null) { var strList = deliveryDate.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { strdeliveryDateFrom = strList[0]; strdeliveryDateEnd = strList[4]; } else { strdeliveryDateFrom = strList[0]; } } else { strdeliveryDateFrom = ""; strdeliveryDateEnd = ""; } if (repairDate != null) { var strList = repairDate.Split(' ', 't', 'o', ' '); if (strList.Count() == 5) { strrepairDateFrom = strList[0]; strrepairDateEnd = strList[4]; } else { strrepairDateFrom = strList[0]; } } else { strrepairDateFrom = String.Empty; strrepairDateEnd = String.Empty; } } modelFormCollection.HID = Hid; modelFormCollection.Rental = Rental; modelFormCollection.Others = Others; modelFormCollection.Area = strArea; modelFormCollection.SalesOffice = strSalesOffice; modelFormCollection.Customer = strCustomer; modelFormCollection.Family = strFamily; modelFormCollection.Industry = strIndustry; modelFormCollection.Model = strModel; modelFormCollection.SerialNumber = strSerialNumber; modelFormCollection.SMURangeFrom = String.IsNullOrWhiteSpace(strSMURangeFrom) ? 0 : Convert.ToInt32(strSMURangeFrom); modelFormCollection.SMURangeTo = String.IsNullOrWhiteSpace(strSMURangeTo) ? 0 : Convert.ToInt32(strSMURangeTo); modelFormCollection.PurchaseDateFrom = strpurchaseDateFrom; modelFormCollection.DeliveryDateFrom = strdeliveryDateFrom; modelFormCollection.LastRepairDateFrom = strrepairDateFrom; modelFormCollection.PurchaseDateEnd = strpurchaseDateEnd; modelFormCollection.DeliveryDateEnd = strdeliveryDateEnd; modelFormCollection.LastRepairDateEnd = strrepairDateEnd; modelFormCollection.Customer = strcustomer; modelFormCollection.Model = strmodel; modelFormCollection.SerialNumber = strserialnumber; modelFormCollection.Product = strproduct; modelFormCollection.Plant = strplant; ViewBag.FilterType = filterType; ViewBag.urlModel = WebConfigure.GetDomain() + "/Dashboard/DashboardTechnicalOverview?filterType=" + filterType + "&Area=" + Area + "&Model=" + Model + "&Family=" + Family + "&Industry=" + Industry + "&SerialNumber=" + SerialNumber + "&Customer=" + Customer + "&SalesOffice=" + SalesOffice + "&deliveryDate=" + deliveryDate + "&purchaseDate=" + purchaseDate + "&repairDate=" + repairDate + "&SMURangeFrom=" + SMURangeFrom + "&SMURangeTo=" + SMURangeTo + "&ModelMEP=" + ModelMEP + "&SerialNumberMEP=" + SerialNumberMEP + "&CustomerMEP=" + CustomerMEP + "&Plant=" + Plant + "&Product=" + Product + "&hid=" + hid + "&rental=" + rental + "&other=" + other + "&btnPOST=" + btnPOST ; var ModelParams = ""; var SerialNumberParams = ""; if (!String.IsNullOrWhiteSpace(paramsModel)) { ModelParams = paramsModel; modelFormCollection.paramsModel = ModelParams; ViewBag.Model = ModelParams; } if (!String.IsNullOrWhiteSpace(paramsSerialNumber)) { SerialNumberParams = paramsSerialNumber; modelFormCollection.paramsSerialNumber = SerialNumberParams; ViewBag.SerialNumber = SerialNumberParams; } var RelatedDPPM = GetTableRelatedDPPMOverviewGet(modelFormCollection, Hid, Rental, Others, modelFormCollection.paramsModel, modelFormCollection.paramsSerialNumber, btnPOST); var RelatedTR = getListTableRelatedTROverviewGet(modelFormCollection, Hid, Rental, Others, modelFormCollection.paramsModel, modelFormCollection.paramsSerialNumber, btnPOST); ViewBag.RelatedDPPMData = RelatedDPPM.Item1; ViewBag.RelatedDPPMDataCount = RelatedDPPM.Item2; ViewBag.TicketDataOverview = RelatedTR.Item1; ViewBag.TicketDataCountOverview = RelatedTR.Item2; ViewBag.FilterType = filterType; ViewBag.ModelFormCollectionOverview = modelFormCollection; return(View()); } }