// GET: AutoSuggestPrefixSN
public ActionResult AutoSuggestPrefixSN()
{
var data = new List <string>();
var listData = PartResponBS.GetListPrefixSN();
var distinctData = listData.Distinct();
foreach (var item in distinctData)
{
data.Add(item);
}
;
var Status = new AutoSuggestPrefixSNModel.Status();
Status.Code = 200;
Status.Message = "Sukses";
var responseJson = new AutoSuggestPrefixSNModel.ResponseJson();
responseJson.Status = Status;
responseJson.Data = data;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
// GET: DashboardPPMFinancial
public ActionResult DashboardPPMFinancial()
{
this.setViewBag();
var strDateRangeFrom = string.Empty;
var strDateRangeEnd = string.Empty;
var strHID = string.Empty;
var strInventory = string.Empty;
var strRental = string.Empty;
var partNumber = string.Empty;
var partDescription = string.Empty;
var model = string.Empty;
var prefixSN = string.Empty;
var dateFrom = "";
var dateEnd = "";
ViewBag.DateFrom = dateFrom;
ViewBag.DateEnd = dateEnd;
var strPartNo = new string[] { };
var strPartDesc = new string[] { };
var strModel = new string[] { };
var strPrefixSN = new string[] { };
var others = string.Empty;
var modelFormCollection = new GetFormCollectionPPMFinancial();
modelFormCollection.DateRangeFrom = strDateRangeFrom;
modelFormCollection.DateRangeEnd = strDateRangeEnd;
modelFormCollection.HID = strHID;
modelFormCollection.Inventory = strInventory;
modelFormCollection.Rental = strRental;
modelFormCollection.PartNumber = partNumber;
modelFormCollection.PartDescription = partDescription;
modelFormCollection.Model = model;
modelFormCollection.PrefixSN = prefixSN;
modelFormCollection.Others = others;
ViewBag.ModelFormCollectionPPM = modelFormCollection;
ViewBag.ListPartNumber = PartResponBS.GetListPartNo();
ViewBag.ListModel = PartResponBS.GetListModel();
ViewBag.ListPartDescription = PartResponBS.GetListPartDesc();
ViewBag.ListPrefixSN = PartResponBS.GetListPrefixSN();
if (strPartNo.Count() > 0 || strPartDesc.Count() > 0 || strModel.Count() > 0 || strPrefixSN.Count() > 0 || dateFrom != "" || strHID != "" || strInventory != "" || strRental != "" || others != "")
{
var sumdataFinance = PartResponBS.CountTotalSODPPMFinance(strPartNo, strPartDesc, strModel, strPrefixSN, dateFrom, dateEnd, strHID, strInventory, strRental, others);
ViewBag.TotalSOCost = sumdataFinance.TotalServiceOrderCost.ToString("N2");
ViewBag.TotalUnitImpacted = sumdataFinance.TotalUnitImpacted;
ViewBag.FinancialSummary = sumdataFinance.FinancialSummary.ToString("N2");
ViewBag.QuantitySummary = sumdataFinance.QuantitySummary;
}
else
{
ViewBag.TotalSOCost = 0;
ViewBag.TotalUnitImpacted = 0;
ViewBag.FinancialSummary = 0;
ViewBag.QuantitySummary = 0;
}
return(View());
}
// GET: TableAffectedUnitDPPMFinancial
public ActionResult TableAffectedUnitDPPMFinancial(string cost, string freq, string dateRangeFrom, string dateRangeEnd, string hid, string inventory, string rental, string others, string PartNumber, string PartDescription, string Model, string PrefixSN)
{
var splitPartNumber = new string[] { };
var splitPartDescription = new string[] { };
var splitModel = new string[] { };
var splitPrefixSN = new string[] { };
if (!string.IsNullOrWhiteSpace(PartNumber))
{
splitPartNumber = PartNumber.Split(',');
}
if (!string.IsNullOrWhiteSpace(PartDescription))
{
splitPartDescription = PartDescription.Split(',');
}
if (!string.IsNullOrWhiteSpace(Model))
{
splitModel = Model.Split(',');
}
if (!string.IsNullOrWhiteSpace(PrefixSN))
{
splitPrefixSN = PrefixSN.Split(',');
}
var getData = PartResponBS.TableAffectedUnit(cost, freq, dateRangeFrom, dateRangeEnd, hid, inventory, rental, others, splitPartNumber, splitPartDescription, splitModel, splitPrefixSN);
var listModel = new List <string>();
var listData = new List <TableAffectedUnitDPPMFinancialModel.Data>();
foreach (var item in getData)
{
var data = new TableAffectedUnitDPPMFinancialModel.Data();
data.Title = item.Model;
data.List = item.SerialNumber;
listData.Add(data);
}
var status = new TableAffectedUnitDPPMFinancialModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TableAffectedUnitDPPMFinancialModel.ResponseJson();
responseJson.Data = listData;
responseJson.Status = status;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
public ActionResult TableRelateDPPMDPPMFinancial(FormCollection fc, string test, string cost, string freq, string dateRangeFrom, string dateRangeEnd, string hid, string inventory, string rental, string others, string PartNumber, string PartDescription, string Model, string PrefixSN, string download = "0")
{
var getData = PartResponBS.GetDataForTableRelateDPPMFinancial(cost, freq, fc["search[value]"]);
var draw = (fc["draw"] != null) ? Convert.ToInt32(fc["draw"]) : 1;
var listData = new List <TableRelateDPPMDPPMFinancialModel.Data>();
if (download == "0")
{
Session["valueSearchRelateDPPM"] = fc["search[value]"];
foreach (var item in getData.Skip(Convert.ToInt32(fc["start"])).Take(Convert.ToInt32(fc["length"])))
{
var id = new TableRelateDPPMDPPMFinancialModel.Id();
id.Row = item.Row;
var dppmNo = new TableRelateDPPMDPPMFinancialModel.ValueData();
dppmNo.Value = item.DPPMNo;
dppmNo.Style = "";
var title = new TableRelateDPPMDPPMFinancialModel.ValueData();
title.Value = item.Title;
title.Style = "";
var desc = new TableRelateDPPMDPPMFinancialModel.ValueData();
desc.Value = item.Desc;
desc.Style = "";
var statusData = new TableRelateDPPMDPPMFinancialModel.ValueData();
statusData.Value = item.Status;
statusData.Style = "";
var submiter = new TableRelateDPPMDPPMFinancialModel.ValueData();
submiter.Value = item.DealerContact;
submiter.Style = "";
var catReps = new TableRelateDPPMDPPMFinancialModel.ValueData();
catReps.Value = item.CatReps;
catReps.Style = "";
var ica = new TableRelateDPPMDPPMFinancialModel.ValueData();
ica.Value = item.ICA;
ica.Style = "";
var pca = new TableRelateDPPMDPPMFinancialModel.ValueData();
pca.Value = item.PCA;
pca.Style = "";
var dateCreated = new TableRelateDPPMDPPMFinancialModel.ValueData();
dateCreated.Value = item.DateCreated.ToString();
dateCreated.Style = "";
var dateLastUpdate = new TableRelateDPPMDPPMFinancialModel.ValueData();
dateLastUpdate.Value = item.DateLastUpdate.ToString();
dateLastUpdate.Style = "";
var itemData = new TableRelateDPPMDPPMFinancialModel.Data();
itemData.Id = id;
itemData.DPPMNo = dppmNo;
itemData.Title = title;
itemData.Desc = desc;
itemData.Status = statusData;
itemData.Submiter = submiter;
itemData.CatReps = catReps;
itemData.ICA = ica;
itemData.PCA = pca;
itemData.DateCreated = dateCreated;
itemData.DateLastUpdate = dateLastUpdate;
listData.Add(itemData);
}
}
if (download == "1")
{
var getSearchValue = Session["valueSearchRelateDPPM"].ToString();
getData = PartResponBS.GetDataForTableRelateDPPMFinancial(cost, freq, getSearchValue);
foreach (var item in getData)
{
var id = new TableRelateDPPMDPPMFinancialModel.Id();
id.Row = item.Row;
var dppmNo = new TableRelateDPPMDPPMFinancialModel.ValueData();
dppmNo.Value = item.DPPMNo;
dppmNo.Style = "";
var title = new TableRelateDPPMDPPMFinancialModel.ValueData();
title.Value = item.Title;
title.Style = "";
var desc = new TableRelateDPPMDPPMFinancialModel.ValueData();
desc.Value = item.Desc;
desc.Style = "";
var statusData = new TableRelateDPPMDPPMFinancialModel.ValueData();
statusData.Value = item.Status;
statusData.Style = "";
var submiter = new TableRelateDPPMDPPMFinancialModel.ValueData();
submiter.Value = item.DealerContact;
submiter.Style = "";
var catReps = new TableRelateDPPMDPPMFinancialModel.ValueData();
catReps.Value = item.CatReps;
catReps.Style = "";
var ica = new TableRelateDPPMDPPMFinancialModel.ValueData();
ica.Value = item.ICA;
ica.Style = "";
var pca = new TableRelateDPPMDPPMFinancialModel.ValueData();
pca.Value = item.PCA;
pca.Style = "";
var dateCreated = new TableRelateDPPMDPPMFinancialModel.ValueData();
dateCreated.Value = item.DateCreated.ToString();
dateCreated.Style = "";
var dateLastUpdate = new TableRelateDPPMDPPMFinancialModel.ValueData();
dateLastUpdate.Value = item.DateLastUpdate.ToString();
dateLastUpdate.Style = "";
var itemData = new TableRelateDPPMDPPMFinancialModel.Data();
itemData.Id = id;
itemData.DPPMNo = dppmNo;
itemData.Title = title;
itemData.Desc = desc;
itemData.Status = statusData;
itemData.Submiter = submiter;
itemData.CatReps = catReps;
itemData.ICA = ica;
itemData.PCA = pca;
itemData.DateCreated = dateCreated;
itemData.DateLastUpdate = dateLastUpdate;
listData.Add(itemData);
}
}
var status = new TableRelateDPPMDPPMFinancialModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TableRelateDPPMDPPMFinancialModel.ResponseJson();
responseJson.Status = status;
responseJson.Draw = draw;
responseJson.RecordsFiltered = getData.Count();
responseJson.RecordsTotal = getData.Count();
responseJson.TotalNeedToRespond = getData.Count();
responseJson.Data = listData;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
public ActionResult TableRelatePSLDPPMFinancial(FormCollection fc, string test, string cost, string freq, string dateRangeFrom, string dateRangeEnd, string hid, string inventory, string rental, string others, string PartNumber, string PartDescription, string Model, string PrefixSN, string download = "0")
{
//var getData = PartResponBS.
var draw = (fc["draw"] != null) ? Convert.ToInt32(fc["draw"]) : 1;
var getTablePSL = PartResponBS.GetDataForTableRelatePSLDPPMFinancial(cost, freq, fc["search[value]"]);
var listData = new List <TableRelatePSLDPPMFinancialModel.Data>();
if (download == "0")
{
Session["searcValueRelatePSL"] = fc["search[value]"];
foreach (var item in getTablePSL.Skip(Convert.ToInt32(fc["start"])).Take(Convert.ToInt32(fc["length"])))
{
var id = new TableRelatePSLDPPMFinancialModel.Id();
id.Row = item.Row;
var subsPSLId = item.PSLNo.Substring(0, 2);
var convDayToExpired = (item.DaysToExpired != "Expired") ? Convert.ToInt32(item.DaysToExpired) : 0;
var subsDate = item.TerminationDate - item.IssueDate;
var pslNo = new TableRelatePSLDPPMFinancialModel.ValueData();
if (item.Validation.Contains("Outstanding"))
{
if (subsPSLId == "PS")
{
if (convDayToExpired > 0 && convDayToExpired <= 182)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (convDayToExpired > 182 && convDayToExpired <= 365)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
else if (subsPSLId == "PI")
{
if (item.PslAge > 0 && item.PslAge <= 182)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (item.PslAge > 182 && item.PslAge <= 365)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (item.PslAge > 365)
{
pslNo.Value = "<span class=\"badge badge-danger\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
else if (subsPSLId != "PI" && subsPSLId == "PS")
{
if (subsDate.Value.Days == 0 && subsDate.Value.Hours > 0 && subsDate.Value.Hours <= 30)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (subsDate.Value.Days == 0 && subsDate.Value.Hours > 30 && subsDate.Value.Hours <= 59)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
}
else
{
pslNo.Value = item.PSLNo;
pslNo.Style = "";
}
var description = new TableRelatePSLDPPMFinancialModel.ValueData();
description.Value = item.Desc;
description.Style = "";
var pslType = new TableRelatePSLDPPMFinancialModel.ValueData();
pslType.Value = item.PSLType;
pslType.Style = "";
var issueDate = new TableRelatePSLDPPMFinancialModel.ValueData();
issueDate.Value = item.IssueDateString;
issueDate.Style = "";
var terminationDate = new TableRelatePSLDPPMFinancialModel.ValueData();
terminationDate.Value = item.TerminationDateString;
terminationDate.Style = "";
var completion = new TableRelatePSLDPPMFinancialModel.ValueData();
completion.Value = item.Completion.ToString();
completion.Style = "";
var itemData = new TableRelatePSLDPPMFinancialModel.Data();
itemData.Id = id;
itemData.PSLNo = pslNo;
itemData.Description = description;
itemData.PSLType = pslType;
itemData.IssueDate = issueDate;
itemData.TerminationDate = terminationDate;
itemData.Completion = completion;
listData.Add(itemData);
}
}
if (download == "1")
{
var getSearchValue = Session["searcValueRelatePSL"].ToString();
getTablePSL = PartResponBS.GetDataForTableRelatePSLDPPMFinancial(cost, freq, getSearchValue);
foreach (var item in getTablePSL)
{
var id = new TableRelatePSLDPPMFinancialModel.Id();
id.Row = item.Row;
var subsPSLId = item.PSLNo.Substring(0, 2);
var convDayToExpired = (item.DaysToExpired != "Expired") ? Convert.ToInt32(item.DaysToExpired) : 0;
var subsDate = item.TerminationDate - item.IssueDate;
var pslNo = new TableRelatePSLDPPMFinancialModel.ValueData();
if (item.Validation.Contains("Outstanding"))
{
if (subsPSLId == "PS")
{
if (convDayToExpired > 0 && convDayToExpired <= 182)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (convDayToExpired > 182 && convDayToExpired <= 365)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
else if (subsPSLId == "PI")
{
if (item.PslAge > 0 && item.PslAge <= 182)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (item.PslAge > 182 && item.PslAge <= 365)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (item.PslAge > 365)
{
pslNo.Value = "<span class=\"badge badge-danger\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
else if (subsPSLId != "PI" && subsPSLId == "PS")
{
if (subsDate.Value.Days == 0 && subsDate.Value.Hours > 0 && subsDate.Value.Hours <= 30)
{
pslNo.Value = "<span class=\"badge badge-success\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
else if (subsDate.Value.Days == 0 && subsDate.Value.Hours > 30 && subsDate.Value.Hours <= 59)
{
pslNo.Value = "<span class=\"badge badge-warning\">" + item.PSLNo + "</span>";
pslNo.Style = "";
}
}
}
else
{
pslNo.Value = item.PSLNo;
pslNo.Style = "";
}
var description = new TableRelatePSLDPPMFinancialModel.ValueData();
description.Value = item.Desc;
description.Style = "";
var pslType = new TableRelatePSLDPPMFinancialModel.ValueData();
pslType.Value = item.PSLType;
pslType.Style = "";
var issueDate = new TableRelatePSLDPPMFinancialModel.ValueData();
issueDate.Value = item.IssueDate.ToString();
issueDate.Style = "";
var terminationDate = new TableRelatePSLDPPMFinancialModel.ValueData();
terminationDate.Value = item.TerminationDate.ToString();
terminationDate.Style = "";
var completion = new TableRelatePSLDPPMFinancialModel.ValueData();
completion.Value = item.Completion.ToString();
completion.Style = "";
var itemData = new TableRelatePSLDPPMFinancialModel.Data();
itemData.Id = id;
itemData.PSLNo = pslNo;
itemData.Description = description;
itemData.PSLType = pslType;
itemData.IssueDate = issueDate;
itemData.TerminationDate = terminationDate;
itemData.Completion = completion;
listData.Add(itemData);
}
}
var status = new TableRelatePSLDPPMFinancialModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TableRelatePSLDPPMFinancialModel.ResponseJson();
responseJson.Status = status;
responseJson.Draw = draw;
responseJson.TotalNeedToRespond = getTablePSL.Count();
responseJson.RecordsFiltered = getTablePSL.Count();
responseJson.RecordsTotal = getTablePSL.Count();
responseJson.Data = listData;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
public ActionResult TableDashboardPPMFinance(FormCollection fc, string hid, string rental, string inventory, string others, string dateRangeFrom, string dateRangeEnd, string PartNumber, string PartDescription, string ModelDashboard, string PrefixSN, string sn, string model, string download = "0")
{
var draw = (fc["draw"] != null) ? Convert.ToInt32(fc["draw"]) : 1;
var searchSerialNo = Convert.ToBoolean(fc["columns[0][searchable]"]);
var searchModel = Convert.ToBoolean(fc["columns[1][searchable]"]);
var searchProdProbDesc = Convert.ToBoolean(fc["columns[2][searchable]"]);
var searchComment = Convert.ToBoolean(fc["columns[3][searchable]"]);
var searchServiceOrder = Convert.ToBoolean(fc["columns[4][searchable]"]);
var searchServiceMtrMeasr = Convert.ToBoolean(fc["columns[5][searchable]"]);
var searchUnitMes = Convert.ToBoolean(fc["columns[6][prod_prob_desc]"]);
var searchSalesOffice = Convert.ToBoolean(fc["columns[7][searchable]"]);
var searchPartNo = Convert.ToBoolean(fc["columns[8][searchable]"]);
var searchPartDesc = Convert.ToBoolean(fc["columns[9][searchable]"]);
var searchRepairDate = Convert.ToBoolean(fc["columns[10][prod_prob_desc]"]);
var searchCurrency = Convert.ToBoolean(fc["columns[11][searchable]"]);
var searchTotalCostSO = Convert.ToBoolean(fc["columns[12][searchable]"]);
var selectColumn = Convert.ToInt32(fc["order[0][column]"]);
var orderByColumn = fc["order[0][dir]"];
var valueSearch = fc["search[value]"];
var splitPartNumber = new string[] { };
var splitPartDescription = new string[] { };
var splitModel = new string[] { };
var splitPrefixSN = new string[] { };
if (!string.IsNullOrWhiteSpace(PartNumber))
{
splitPartNumber = PartNumber.Split(',');
}
if (!string.IsNullOrWhiteSpace(PartDescription))
{
splitPartDescription = PartDescription.Split(',');
}
if (!string.IsNullOrWhiteSpace(ModelDashboard))
{
splitModel = ModelDashboard.Split(',');
}
if (!string.IsNullOrWhiteSpace(PrefixSN))
{
splitPrefixSN = PrefixSN.Split(',');
}
var getData = PartResponBS.GetDataTableDPPMFinance(dateRangeFrom, dateRangeEnd, valueSearch, splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, sn, model, hid, rental, inventory, others);
var listData = new List <TableDashboardPPMFinanceModel.Data>();
if (download == "0")
{
Session["searchValuePPMFinance"] = valueSearch;
Session["SNChart"] = sn;
Session["ModelChart"] = model;
foreach (var item in getData.Skip(Convert.ToInt32(fc["start"])).Take(Convert.ToInt32(fc["length"])))
{
var id = new TableDashboardPPMFinanceModel.Id();
id.Row = item.Row;
var serialNo = new TableDashboardPPMFinanceModel.ValueData();
serialNo.Value = item.SerialNumber;
serialNo.Style = "";
var modelDashboard = new TableDashboardPPMFinanceModel.ValueData();
modelDashboard.Value = item.Model;
modelDashboard.Style = "";
var productProblem = new TableDashboardPPMFinanceModel.ValueData();
productProblem.Value = item.ProductProblemDescription;
productProblem.Style = "";
var comment = new TableDashboardPPMFinanceModel.ValueData();
comment.Value = item.Comment;
comment.Style = "";
var serviceOrder = new TableDashboardPPMFinanceModel.ValueData();
serviceOrder.Value = item.ServiceOrder;
serviceOrder.Style = "";
var smu = new TableDashboardPPMFinanceModel.ValueData();
smu.Value = item.ServiceMeterMeasurement.ToString();
smu.Style = "";
var unitMes = new TableDashboardPPMFinanceModel.ValueData();
unitMes.Value = item.UnitMes;
unitMes.Style = "";
var salesOffice = new TableDashboardPPMFinanceModel.ValueData();
salesOffice.Value = item.SalesOffice;
salesOffice.Style = "";
var partNo = new TableDashboardPPMFinanceModel.ValueData();
partNo.Value = item.PartNo;
partNo.Style = "";
var partDesc = new TableDashboardPPMFinanceModel.ValueData();
partDesc.Value = item.PartDescription;
partDesc.Style = "";
var repairDate = new TableDashboardPPMFinanceModel.ValueData();
repairDate.Value = item.RepairDate;
repairDate.Style = "";
var currency = new TableDashboardPPMFinanceModel.ValueData();
currency.Value = item.Currency;
currency.Style = "";
var totalSoCost = new TableDashboardPPMFinanceModel.ValueData();
totalSoCost.Value = item.TotalSoCost.ToString("C");
totalSoCost.Style = "";
var itemData = new TableDashboardPPMFinanceModel.Data();
itemData.Id = id;
itemData.SerialNo = serialNo;
itemData.Model = modelDashboard;
itemData.ProdProbDesc = productProblem;
itemData.Comment = comment;
itemData.ServiceOrder = serviceOrder;
itemData.ServiceMtrMeasr = smu;
itemData.UnitMes = unitMes;
itemData.SalesOffice = salesOffice;
itemData.PartNo = partNo;
itemData.PartDescription = partDesc;
itemData.RepairDate = repairDate;
itemData.Currency = currency;
itemData.TotalCostSO = totalSoCost;
listData.Add(itemData);
}
}
if (download == "1")
{
var getSearchValue = Session["searchValuePPMFinance"].ToString();
var getModelChart = Session["ModelChart"].ToString();
var getSNChart = Session["SNChart"].ToString();
getData = PartResponBS.GetDataTableDPPMFinance(dateRangeFrom, dateRangeEnd, getSearchValue, splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, getSNChart, getModelChart, hid, rental, inventory, others);
foreach (var item in getData)
{
var id = new TableDashboardPPMFinanceModel.Id();
id.Row = item.Row;
var serialNo = new TableDashboardPPMFinanceModel.ValueData();
serialNo.Value = item.SerialNumber;
serialNo.Style = "";
var modelDashboard = new TableDashboardPPMFinanceModel.ValueData();
modelDashboard.Value = item.Model;
modelDashboard.Style = "";
var productProblem = new TableDashboardPPMFinanceModel.ValueData();
productProblem.Value = item.ProductProblemDescription;
productProblem.Style = "";
var comment = new TableDashboardPPMFinanceModel.ValueData();
comment.Value = item.Comment;
comment.Style = "";
var serviceOrder = new TableDashboardPPMFinanceModel.ValueData();
serviceOrder.Value = item.ServiceOrder;
serviceOrder.Style = "";
var smu = new TableDashboardPPMFinanceModel.ValueData();
smu.Value = item.ServiceMeterMeasurement.ToString();
smu.Style = "";
var unitMes = new TableDashboardPPMFinanceModel.ValueData();
unitMes.Value = item.UnitMes;
unitMes.Style = "";
var salesOffice = new TableDashboardPPMFinanceModel.ValueData();
salesOffice.Value = item.SalesOffice;
salesOffice.Style = "";
var partNo = new TableDashboardPPMFinanceModel.ValueData();
partNo.Value = item.PartNo;
partNo.Style = "";
var partDesc = new TableDashboardPPMFinanceModel.ValueData();
partDesc.Value = item.PartDescription;
partDesc.Style = "";
var repairDate = new TableDashboardPPMFinanceModel.ValueData();
repairDate.Value = item.RepairDate;
repairDate.Style = "";
var currency = new TableDashboardPPMFinanceModel.ValueData();
currency.Value = item.Currency;
currency.Style = "";
var totalSoCost = new TableDashboardPPMFinanceModel.ValueData();
totalSoCost.Value = item.TotalSoCost.ToString("C");
totalSoCost.Style = "";
var itemData = new TableDashboardPPMFinanceModel.Data();
itemData.Id = id;
itemData.SerialNo = serialNo;
itemData.Model = modelDashboard;
itemData.ProdProbDesc = productProblem;
itemData.Comment = comment;
itemData.ServiceOrder = serviceOrder;
itemData.ServiceMtrMeasr = smu;
itemData.UnitMes = unitMes;
itemData.SalesOffice = salesOffice;
itemData.PartNo = partNo;
itemData.PartDescription = partDesc;
itemData.RepairDate = repairDate;
itemData.Currency = currency;
itemData.TotalCostSO = totalSoCost;
listData.Add(itemData);
}
}
var status = new TableDashboardPPMFinanceModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TableDashboardPPMFinanceModel.ResponseJson();
responseJson.Status = status;
responseJson.RecordsFiltered = getData.Count();
responseJson.RecordsTotal = getData.Count();
responseJson.Data = listData;
responseJson.Draw = draw;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
// GET: ChartComboPPMFinancial
public ActionResult ChartComboPPMFinancial(string hid, string rental, string inventory, string others, string dateRangeFrom, string dateRangeEnd, string PartNumber, string PartDescription, string ModelDashboard, string PrefixSN)
{
var splitPartNumber = new string[] { };
var splitPartDescription = new string[] { };
var splitModel = new string[] { };
var splitPrefixSN = new string[] { };
if (!string.IsNullOrWhiteSpace(PartNumber))
{
splitPartNumber = PartNumber.Split(',');
}
if (!string.IsNullOrWhiteSpace(PartDescription))
{
splitPartDescription = PartDescription.Split(',');
}
if (!string.IsNullOrWhiteSpace(ModelDashboard))
{
splitModel = ModelDashboard.Split(',');
}
if (!string.IsNullOrWhiteSpace(PrefixSN))
{
splitPrefixSN = PrefixSN.Split(',');
}
if (!string.IsNullOrWhiteSpace(PrefixSN))
{
splitPrefixSN = PrefixSN.Split(',');
}
var getListData = PartResponBS.GetData(splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, dateRangeFrom, dateRangeEnd, hid, rental, inventory, others);
var listDataLabel = new List <List <string> >();
var dataLine = new List <decimal>();
var dataBar = new List <decimal>();
foreach (var item in getListData)
{
listDataLabel.Add(item.Model);
dataLine.Add(item.DataTotalCost);
dataBar.Add(item.DataTotalSO);
}
var dataSets1 = new ChartComboFinancialModel.DataSets();
dataSets1.Type = "line";
dataSets1.Label = "Total Cost";
dataSets1.BorderColor = "red";
dataSets1.BackgroundColor = "";
dataSets1.Data = dataLine;
var dataSets2 = new ChartComboFinancialModel.DataSets();
dataSets2.Type = "bar";
dataSets2.Label = "Total SO";
dataSets2.BackgroundColor = "#cfd20f";
dataSets2.BorderColor = "";
dataSets2.Data = dataBar;
var listDataSet = new List <ChartComboFinancialModel.DataSets>();
listDataSet.Add(dataSets1);
listDataSet.Add(dataSets2);
var comboBar = new ChartComboFinancialModel.ComboBar();
comboBar.Labels = listDataLabel;
comboBar.DataSets = listDataSet;
var data = new ChartComboFinancialModel.Data();
data.ComboBar = comboBar;
var status = new ChartComboFinancialModel.Status();
status.Code = 200;
status.Message = "Success";
var responseJson = new ChartComboFinancialModel.ResponseJson();
responseJson.Status = status;
responseJson.Data = data;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
public ActionResult TableRelateTRDPPMFinancial(FormCollection fc, string test, string cost, string freq, string dateRangeFrom, string dateRangeEnd, string hid, string inventory, string rental, string others, string PartNumber, string PartDescription, string Model, string PrefixSN)
{
var draw = (fc["draw"] != null) ? Convert.ToInt32(fc["draw"]) : 1;
var listData = new List <TableRelateTRDPPMFinancialModel.Data>();
var getData = PartResponBS.GetDataForTableRelateTRDPPMFinancial(cost, freq);
foreach (var item in getData)
{
var id = new TableRelateTRDPPMFinancialModel.Id();
id.Row = item.Row;
var ticketNo = new TableRelateTRDPPMFinancialModel.ValueData();
ticketNo.Value = item.TicketNo;
ticketNo.Style = "";
var industry = new TableRelateTRDPPMFinancialModel.ValueData();
industry.Value = item.Industry;
industry.Style = "";
var family = new TableRelateTRDPPMFinancialModel.ValueData();
family.Value = item.Familiy;
family.Style = "";
var model = new TableRelateTRDPPMFinancialModel.ValueData();
model.Value = item.Model;
model.Style = "";
var category = new TableRelateTRDPPMFinancialModel.ValueData();
category.Value = item.Category;
category.Style = "";
var title = new TableRelateTRDPPMFinancialModel.ValueData();
title.Value = item.Title;
title.Style = "";
var desc = new TableRelateTRDPPMFinancialModel.ValueData();
desc.Value = item.Desc;
desc.Style = "";
var resolution = new TableRelateTRDPPMFinancialModel.ValueData();
resolution.Value = item.Resolution;
resolution.Style = "";
var dateCreated = new TableRelateTRDPPMFinancialModel.ValueData();
dateCreated.Value = item.DateCreated;
dateCreated.Style = "";
var dateClosed = new TableRelateTRDPPMFinancialModel.ValueData();
dateClosed.Value = item.DateClosed;
dateClosed.Style = "";
var statusTR = new TableRelateTRDPPMFinancialModel.ValueData();
var statustr = "";
if (item.StatusTR == 1)
{
statustr = "Draft";
}
else if (item.StatusTR == 2)
{
statustr = "Submit";
}
else if (item.StatusTR == 3)
{
statustr = "Closed";
}
else if (item.StatusTR == 4)
{
statustr = "Re-Open";
}
else if (item.StatusTR == 5)
{
statustr = "Remove";
}
else if (item.StatusTR == 6)
{
statustr = "Solved";
}
statusTR.Value = statustr;
statusTR.Style = "";
var data = new TableRelateTRDPPMFinancialModel.Data();
data.Id = id;
data.TicketNo = ticketNo;
data.Industry = industry;
data.Family = family;
data.Model = model;
data.Category = category;
data.Title = title;
data.Desc = desc;
data.Resolution = resolution;
data.DateCreated = dateCreated;
data.DateClosed = dateClosed;
data.StatusTicket = statusTR;
listData.Add(data);
}
var status = new TableRelateTRDPPMFinancialModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TableRelateTRDPPMFinancialModel.ResponseJson();
responseJson.Data = listData;
responseJson.Draw = draw;
responseJson.RecordsFiltered = getData.Count();
responseJson.RecordsTotal = getData.Count();
responseJson.Status = status;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
public ActionResult DashboardPPMFinancial(FormCollection formCollection)
{
this.setViewBag();
var dateRangeForm = "";
var dateRangeEnd = "";
if (formCollection["dateRange"] != null)
{
var splitDate = formCollection["dateRange"].Split(' ', 't', 'o', ' ');
if (splitDate.Count() == 5)
{
dateRangeForm = splitDate[0];
dateRangeEnd = splitDate[4];
}
else
{
dateRangeForm = splitDate[0];
}
}
var strDateRangeFrom = (!string.IsNullOrWhiteSpace(dateRangeForm)) ? dateRangeForm : "";
var strDateRangeEnd = (!string.IsNullOrWhiteSpace(dateRangeEnd)) ? dateRangeEnd : "";
var strHID = (!string.IsNullOrWhiteSpace(formCollection["hid"])) ? formCollection["hid"] : "";
var strInventory = (!string.IsNullOrWhiteSpace(formCollection["inventory"])) ? formCollection["inventory"] : "";
var strRental = (!string.IsNullOrWhiteSpace(formCollection["rental"])) ? formCollection["rental"] : "";
var strOthers = (!string.IsNullOrWhiteSpace(formCollection["others"])) ? formCollection["others"] : "";
var partNumber = (!string.IsNullOrWhiteSpace(formCollection["part-number"])) ? formCollection["part-number"] : "";
var partDescription = (!string.IsNullOrWhiteSpace(formCollection["part-description"])) ? formCollection["part-description"] : "";
var model = (!string.IsNullOrWhiteSpace(formCollection["model"])) ? formCollection["model"] : "";
var prefixSN = (!string.IsNullOrWhiteSpace(formCollection["prefix-sn"])) ? formCollection["prefix-sn"] : "";
var splitPartNumber = new string[] { };
var splitPartDescription = new string[] { };
var splitModel = new string[] { };
var splitPrefixSN = new string[] { };
if (!string.IsNullOrWhiteSpace(partNumber))
{
splitPartNumber = partNumber.Split(',');
}
if (!string.IsNullOrWhiteSpace(partDescription))
{
splitPartDescription = partDescription.Split(',');
}
if (!string.IsNullOrWhiteSpace(model))
{
splitModel = model.Split(',');
}
if (!string.IsNullOrWhiteSpace(prefixSN))
{
splitPrefixSN = prefixSN.Split(',');
}
ViewBag.DateFrom = strDateRangeFrom;
ViewBag.DateEnd = strDateRangeEnd;
var modelFormCollection = new GetFormCollectionPPMFinancial();
modelFormCollection.DateRangeFrom = strDateRangeFrom;
modelFormCollection.DateRangeEnd = strDateRangeEnd;
modelFormCollection.HID = strHID;
modelFormCollection.Inventory = strInventory;
modelFormCollection.Rental = strRental;
modelFormCollection.PartNumber = partNumber;
modelFormCollection.PartDescription = partDescription;
modelFormCollection.Model = model;
modelFormCollection.PrefixSN = prefixSN;
modelFormCollection.Others = strOthers;
ViewBag.ModelFormCollectionPPM = modelFormCollection;
ViewBag.ListPartNumber = PartResponBS.GetListPartNo();
ViewBag.ListModel = PartResponBS.GetListModel();
ViewBag.ListPartDescription = PartResponBS.GetListPartDesc();
ViewBag.ListPrefixSN = PartResponBS.GetListPrefixSN();
if (splitPartNumber.Count() > 0 || splitPartDescription.Count() > 0 || splitModel.Count() > 0 || splitPrefixSN.Count() > 0 || dateRangeForm != "" || strHID != "" || strInventory != "" || strRental != "" || strOthers != "")
{
var sumdataFinance = PartResponBS.CountTotalSODPPMFinance(splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, dateRangeForm, dateRangeEnd, strHID, strInventory, strRental, strOthers);
ViewBag.TotalSOCost = sumdataFinance.TotalServiceOrderCost.ToString("N2");
ViewBag.TotalUnitImpacted = sumdataFinance.TotalUnitImpacted;
ViewBag.FinancialSummary = sumdataFinance.FinancialSummary.ToString("N2");
ViewBag.QuantitySummary = sumdataFinance.QuantitySummary;
}
else
{
ViewBag.TotalSOCost = 0;
ViewBag.TotalUnitImpacted = 0;
ViewBag.FinancialSummary = 0;
ViewBag.QuantitySummary = 0;
}
return(View());
}
public ActionResult TablePPMPotentialByFrequency(FormCollection fc, string dateRangeFrom, string dateRangeEnd, string hid, string inventory, string rental, string others, string PartNumber, string PartDescription, string Model, string PrefixSN, string download = "0")
{
var searchSerialNo = Convert.ToBoolean(fc["columns[0][searchable]"]);
var searchModel = Convert.ToBoolean(fc["columns[1][searchable]"]);
var searchProductProblemDescription = Convert.ToBoolean(fc["columns[2][searchable]"]);
var searchComment = Convert.ToBoolean(fc["columns[3][searchable]"]);
var searchServiceOrder = Convert.ToBoolean(fc["columns[4][searchable]"]);
var searchServiceMeter = Convert.ToBoolean(fc["columns[5][searchable]"]);
var searchUnitMes = Convert.ToBoolean(fc["columns[6][searchable]"]);
var searchSalesOffice = Convert.ToBoolean(fc["columns[7][searchable]"]);
var searchPartNo = Convert.ToBoolean(fc["columns[8][searchable]"]);
var searchPartDesc = Convert.ToBoolean(fc["columns[9][searchable]"]);
var searchRepairDate = Convert.ToBoolean(fc["columns[10][searchable]"]);
var searchCurrency = Convert.ToBoolean(fc["columns[11][searchable]"]);
var searchTotalCostSO = Convert.ToBoolean(fc["columns[12][searchable]"]);
var Draw = (fc["draw"] != null) ? Convert.ToInt32(fc["draw"]) : 1;
var splitPartNumber = new string[] { };
var splitPartDescription = new string[] { };
var splitModel = new string[] { };
var splitPrefixSN = new string[] { };
if (!string.IsNullOrWhiteSpace(PartNumber))
{
splitPartNumber = PartNumber.Split(',');
}
if (!string.IsNullOrWhiteSpace(PartDescription))
{
splitPartDescription = PartDescription.Split(',');
}
if (!string.IsNullOrWhiteSpace(Model))
{
splitModel = Model.Split(',');
}
if (!string.IsNullOrWhiteSpace(PrefixSN))
{
splitPrefixSN = PrefixSN.Split(',');
}
var getListData = PartResponBS.GetDataForTablePPMByFrequency(dateRangeFrom, dateRangeEnd, splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, searchSerialNo, searchModel, searchProductProblemDescription, searchComment, searchServiceOrder, searchServiceMeter, searchUnitMes, searchSalesOffice, searchPartNo, searchPartDesc, searchRepairDate, searchCurrency, searchTotalCostSO, fc["search[value]"], Convert.ToInt32(fc["order[0][column]"]), fc["order[0][dir]"], hid, rental, inventory, others);
var listData = new List <TablePPMPotentialByFrequencyModel.Data>();
if (download == "0")
{
Session["searchValuePPMPotentialByFrecuency"] = fc["search[value]"];
foreach (var item in getListData.Skip(Convert.ToInt32(fc["start"])).Take(Convert.ToInt32(fc["length"])))
{
var id = new TablePPMPotentialByFrequencyModel.Id();
id.Row = item.Row;
var partNo = new TablePPMPotentialByFrequencyModel.ValueData();
partNo.Value = item.PartNo;
partNo.Style = "";
var partDesc = new TablePPMPotentialByFrequencyModel.ValueData();
partDesc.Value = item.PartDescription;
partDesc.Style = "";
var groupNo = new TablePPMPotentialByFrequencyModel.ValueDataGroupNo();
groupNo.Value = item.GroupNo;
groupNo.Style = "";
var groupDesc = new TablePPMPotentialByFrequencyModel.ValueData();
groupDesc.Value = item.GroupDesc;
groupDesc.Style = "";
var prodProbDesc = new TablePPMPotentialByFrequencyModel.ValueData();
prodProbDesc.Value = item.ProductProblemDescription;
prodProbDesc.Style = "";
var countOFRepair = new TablePPMPotentialByFrequencyModel.ValueData();
countOFRepair.Value = item.CountOfRepair.ToString();
countOFRepair.Style = "";
var itemData = new TablePPMPotentialByFrequencyModel.Data();
itemData.Id = id;
itemData.PartNo = partNo;
itemData.PartDesc = partDesc;
itemData.ProdProbDesc = prodProbDesc;
itemData.GroupNo = groupNo;
itemData.GroupDesc = groupDesc;
itemData.CountOfRepair = countOFRepair;
listData.Add(itemData);
}
}
if (download == "1")
{
var getSearchValue = Session["searchValuePPMPotentialByFrecuency"].ToString();
getListData = PartResponBS.GetDataForTablePPMByFrequency(dateRangeFrom, dateRangeEnd, splitPartNumber, splitPartDescription, splitModel, splitPrefixSN, searchSerialNo, searchModel, searchProductProblemDescription, searchComment, searchServiceOrder, searchServiceMeter, searchUnitMes, searchSalesOffice, searchPartNo, searchPartDesc, searchRepairDate, searchCurrency, searchTotalCostSO, getSearchValue, Convert.ToInt32(fc["order[0][column]"]), fc["order[0][dir]"], hid, rental, inventory, others);
foreach (var item in getListData)
{
var id = new TablePPMPotentialByFrequencyModel.Id();
id.Row = item.Row;
var partNo = new TablePPMPotentialByFrequencyModel.ValueData();
partNo.Value = item.PartNo;
partNo.Style = "";
var partDesc = new TablePPMPotentialByFrequencyModel.ValueData();
partDesc.Value = item.PartDescription;
partDesc.Style = "";
var groupNo = new TablePPMPotentialByFrequencyModel.ValueDataGroupNo();
groupNo.Value = item.GroupNo;
groupNo.Style = "";
var groupDesc = new TablePPMPotentialByFrequencyModel.ValueData();
groupDesc.Value = item.GroupDesc;
groupDesc.Style = "";
var prodProbDesc = new TablePPMPotentialByFrequencyModel.ValueData();
prodProbDesc.Value = item.ProductProblemDescription;
prodProbDesc.Style = "";
var countOFRepair = new TablePPMPotentialByFrequencyModel.ValueData();
countOFRepair.Value = item.CountOfRepair.ToString();
countOFRepair.Style = "";
var itemData = new TablePPMPotentialByFrequencyModel.Data();
itemData.Id = id;
itemData.PartNo = partNo;
itemData.PartDesc = partDesc;
itemData.ProdProbDesc = prodProbDesc;
itemData.GroupNo = groupNo;
itemData.GroupDesc = groupDesc;
itemData.CountOfRepair = countOFRepair;
listData.Add(itemData);
}
}
var status = new TablePPMPotentialByFrequencyModel.Status();
status.Code = 200;
status.Message = "Sukses";
var responseJson = new TablePPMPotentialByFrequencyModel.ResponseJson();
responseJson.Draw = Draw;
responseJson.Data = listData;
responseJson.RecordsFilter = getListData.Count();
responseJson.RecordTotal = getListData.Count();
responseJson.Status = status;
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(responseJson));
return(new EmptyResult());
}
