private Helpers.PageInput getFlagboardDropdown(string CID, int MFB_Id = 0)
{
string selVal = (MFB_Id == 0) ? "" : MFB_Id.ToString();
Helpers.PageInput fbInput = new Helpers.PageInput("select", "Flagboards", "MFB_Id", "MFB_Id", selVal);
try
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
List <Models.pageInputs> fbs = service.getFlagBoardsInput();
if (fbs == null || fbs.Count == 0)
{
fbInput.errorFlag = true;
fbInput.errorMessage = "ERROR: No FlagBoards found in database.";
return(fbInput);
}
foreach (var item in fbs)
{
fbInput.input.options.Add(new Helpers.InputObject.option {
text = "FB " + item.value, value = item.key
});
}
}
catch (Exception ex)
{
fbInput.errorFlag = true;
fbInput.errorMessage = "ERROR CREATING FB SELECT LIST: " + ex.Message;
}
return(fbInput);
}
private Helpers.PageInput getEmployeesDropdown(string CID)
{
Helpers.PageInput machineInput = new Helpers.PageInput("select", "Employees", "EMP_ID", "EMP_ID", "");
try
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
List <Employee> employees = service.getEmployees();
if (employees == null || employees.Count == 0)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR: No empoyes found in database.";
return(machineInput);
}
foreach (var item in employees)
{
machineInput.input.options.Add(new Helpers.InputObject.option {
text = item.EMP_First_Name + " " + item.EMP_Last_Name, value = item.EMP_ID.ToString()
});
}
}
catch (Exception ex)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR CREATING EMPLOYEE SELECT LIST: " + ex.Message;
}
return(machineInput);
}
private Helpers.PageInput getMTypesDropdown(string CID)
{
Helpers.PageInput machineInput = new Helpers.PageInput("select", "Maintenance Types", "MT_Id", "MT_Id", "");
try
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
List <Maintenance_Types> mtypes = service.getMaintenanceTypes();
if (mtypes == null || mtypes.Count == 0)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR: No maintenance types found in database.";
return(machineInput);
}
foreach (var item in mtypes)
{
machineInput.input.options.Add(new Helpers.InputObject.option {
text = item.MT_Name, value = item.MT_Id.ToString()
});
}
}
catch (Exception ex)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR CREATING MAINTENANCE SELECT LIST: " + ex.Message;
}
return(machineInput);
}
private Helpers.PageInput getMachineDropdown(string CID, int flgId = 0)
{
Helpers.PageInput machineInput = new Helpers.PageInput("select", "Machine Name", "MM_Id", "MM_Id", "");
try
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
List <Machine> machines = service.getMachines(flgId);
if (machines == null || machines.Count == 0)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR: No machines found in database.";
return(machineInput);
}
foreach (var item in machines)
{
machineInput.input.options.Add(new Helpers.InputObject.option {
text = item.MM_Name, value = item.MM_Id.ToString()
});
}
} catch (Exception ex)
{
machineInput.errorFlag = true;
machineInput.errorMessage = "ERROR CREATING MACHINE SELECT LIST: " + ex.Message;
}
return(machineInput);
}
private Helpers.PageInput getMaintCodeDropdown()
{
Helpers.PageInput fbInput = new Helpers.PageInput("select", "Maintenance Code", "MS_Maint_Code", "MS_Maint_Code", "2");
try
{
fbInput.input.options.Add(new Helpers.InputObject.option {
text = "SCHEDULED", value = "1"
});
fbInput.input.options.Add(new Helpers.InputObject.option {
text = "UNSCHEDULED", value = "2"
});
}
catch (Exception ex)
{
fbInput.errorFlag = true;
fbInput.errorMessage = "ERROR CREATING MTCODE SELECT LIST: " + ex.Message;
}
return(fbInput);
}
private List <Helpers.PageInput> getEditorInputs(string CID, int MFB_Id, int MS_Id = 0)
{
List <Helpers.PageInput> inputs = new List <Helpers.PageInput>();
inputs.Add(getFlagboardDropdown(CID, MFB_Id));
inputs.Add(getMachineDropdown(CID, MFB_Id));
inputs.Add(getMTypesDropdown(CID));
inputs.Add(getEmployeesDropdown(CID));
if (MS_Id == 0)
{
foreach (var item in inputs[inputs.Count - 1].input.options)
{
if (item.text == ". .")
{
inputs[inputs.Count - 1].input.value = item.value;
break;
}
}
}
inputs.Add(new Helpers.PageInput("default", "Unscheduled Reason", "MS_Unscheduled_Reason", "MS_Unscheduled_Reason", ""));
if (MS_Id == 0)
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
try
{
inputs.Add(new Helpers.PageInput("default", "WorkOrder Number", "MS_Workorder", "MS_Workorder", service.getNewWorkoder().ToString()));
}
finally
{
service.Dispose();
}
}
else
{
inputs.Add(new Helpers.PageInput("default", "WorkOrder Number", "MS_Workorder", "MS_Workorder", ""));
}
Helpers.PageInput lastDate = new Helpers.PageInput("default", "Last Maintenance Date", "MS_Last_Main_Date", "MS_Last_Main_Date", "");
lastDate.function = "date";
inputs.Add(lastDate);
Helpers.PageInput nextDate = new Helpers.PageInput("default", "Next Maintenance Date", "MS_Next_Main_Date", "MS_Next_Main_Date", "");
nextDate.function = "date";
inputs.Add(nextDate);
Helpers.PageInput completed = new Helpers.PageInput("default", "Completed by", "MS_Main_Comp_Date", "MS_Main_Comp_Date", "false");
completed.function = "checkbox";
inputs.Add(completed);
inputs.Add(getMaintCodeDropdown());
Helpers.PageInput timeAlotted = new Helpers.PageInput("default", "Time Alloted", "MS_Maint_Time_Alotted", "MS_Maint_Time_Alotted", "0");
timeAlotted.function = "number";
inputs.Add(timeAlotted);
Helpers.PageInput timeRequired = new Helpers.PageInput("default", "Time Required", "MS_Maint_Time_Required", "MS_Maint_Time_Required", "0");
timeRequired.function = "number";
inputs.Add(timeRequired);
Helpers.PageInput timeInterval = new Helpers.PageInput("default", "Time Interval", "MS_Frequency", "MS_Frequency", "0");
timeInterval.function = "number";
inputs.Add(timeInterval);
Helpers.PageInput downtime = new Helpers.PageInput("timer", "Total Machine Downtime", "MS_Total_Machine_Downtime", "MS_Total_Machine_Downtime", "0");
downtime.function = "timer";
inputs.Add(downtime);
Helpers.PageInput machineHours = new Helpers.PageInput("default", "Machine Hours", "MS_Machine_Hours", "MS_Machine_Hours", "0");
machineHours.function = "number";
inputs.Add(machineHours);
inputs.Add(new Helpers.PageInput("default", "Notes", "MS_Notes", "MS_Notes", ""));
return(inputs);
}
