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 Models.FbPartialViewModel getFbVM()
{
Models.FbPartialViewModel m = new Models.FbPartialViewModel();
Helpers.CtxManagerService s = new Helpers.CtxManagerService();
if (CID != null && CID.Length == 6)
{
Helpers.CtxService ctxs = new Helpers.CtxService(null, CID);
m.fbdata = ctxs.GetFlagboards();
m.SelCID = CID;
}
else
{
m.fbdata = new Models.CtxEF.Maintenance_Flagboard[] { };
m.SelCID = "000000";
}
removeCacheHTML("flagboards");
m.corpdata = s.getLocations();
return(m);
}
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 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 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 Models.MobileEditorModel getEditorModelObject(string CID, int MS_Id, int MFB_Id, int MM_Id)
{
Models.MobileEditorModel model = new Models.MobileEditorModel();
model.CID = CID;
model.inputs = getEditorInputs(CID, MFB_Id, MS_Id);
model.hiddenInputs = new List <Helpers.InputObject>();
Helpers.InputObject hidden1 = new Helpers.InputObject();
hidden1.id = "CID";
hidden1.value = CID;
model.hiddenInputs.Add(hidden1);
Helpers.InputObject hidden2 = new Helpers.InputObject();
hidden2.id = "MS_Id";
hidden2.value = MS_Id.ToString();
model.hiddenInputs.Add(hidden2);
Helpers.InputObject hidden3 = new Helpers.InputObject();
hidden3.id = "MM_Id";
hidden3.value = MM_Id.ToString();
model.hiddenInputs.Add(hidden3);
service = new Helpers.CtxService(null, model.CID);
model.machines = service.getMachines(MFB_Id).ToArray();
return(model);
}
public FileStreamResult MachineFileClick(string CID, string MM_Idp, string number)
{
byte[] buffer = new byte[0];
string filename = "export.pdf";
string prefix = "pdf";
Dictionary <string, string> mimetypes = getMimeTypes();
try
{
int MM_Id = 0;
int fileNumber = Convert.ToInt32(number);
Int32.TryParse(MM_Idp, out MM_Id);
if (CID.Length < 6)
{
throw new Exception("location variable incorrectly formatted.");
}
if (MM_Id == 0)
{
throw new Exception("Machine primary key cannot be zero.");
}
Helpers.CtxService service = new Helpers.CtxService(null, CID);
List <ActiveMachineImgae> files = service.getmachineFiles(MM_Id);
for (var i = 1; i <= files.Count; i++)
{
if (i == fileNumber)
{
buffer = files[i - 1].filebytes1;
filename = files[i - 1].filename1;
var splitarr = filename.Split('.');
if (splitarr.Length > 1)
{
prefix = splitarr[splitarr.Length - 1];
}
break;
}
}
} catch (Exception ex)
{
}
if (buffer != null && mimetypes.ContainsKey(prefix.ToUpper()))
{
MemoryStream stream = new MemoryStream(buffer);
stream.Flush();
stream.Position = 0;
return(File(stream, mimetypes[prefix.ToUpper()], filename));
}
else
{
MemoryStream stream = new MemoryStream();
stream.Flush();
stream.Position = 0;
return(File(stream, "application/pdf", "export.pdf"));
}
}
public JsonResult SaveFB(string method, int MFBId, string Desc, string CID)
{
var rObject = new MethodResponse()
{
Result = true,
ErrorMessage = "",
Content = new Models.WorkroomsUserObject[] { }
};
Helpers.CtxService service = new Helpers.CtxService(null, CID);
try
{
if (CID.Length < 6)
{
throw new Exception("could not find location variable");
}
switch (method)
{
case "fb_add":
rObject.Result = service.AddFB(Desc);
if (!rObject.Result)
{
rObject.ErrorMessage = service.errorMessage;
}
break;
case "fb_edit":
rObject.Result = service.EditFB(MFBId, Desc);
if (!rObject.Result)
{
rObject.ErrorMessage = service.errorMessage;
}
//else
// service.EditCachedWorkroom(id, Name, Abbreviation);
break;
}
} catch (Exception ex)
{
rObject.Result = false;
rObject.ErrorMessage = ex.Message;
}
if (rObject.Result == true)
{
removeCacheHTML();
}
else
{
rObject.ErrorMessage = service.errorMessage;
}
return(Json(rObject));
}
public JsonResult getNewWorkorder(string CID)
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
int workorder = 0;
try
{
workorder = service.getNewWorkoder();
} finally
{
service.Dispose();
}
return(Json(workorder, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
model.CID = getCID();
if (model.CID.Trim().Length < 6)
{
return(RedirectToAction("Locations", "Manage"));
}
service = new Helpers.CtxService(null, model.CID);
Helpers.ManagerService manageservice = new Helpers.ManagerService();
try
{
model.MFB_Id = getSelectedFlagboard();
model.machines = service.getMachines(model.MFB_Id);
model.types = service.getMaintenanceTypes();
model.employees = service.getEmployees();
model.MS_Maint_Code = getMaintCode();
model.schedule = getSchedule();
model.Location = manageservice.getRecord(model.CID.Trim());
model.flagboards = service.getFlagBoards().ToArray();
model.MFB_label = getFBLabel(model.MFB_Id);
model.UserName = User.Identity.Name;
UpdateCachedTimers(model.CID);
model.ActiveTimers = GetActiveTimers(model.CID);
model.isMobile = isMobile();
model.canDelete = IsAdmin();
model.ticketname = ticketname;
} finally
{
service.Dispose();
model.schedule = filterSchedule(model.schedule);
}
if (service.error == true)
{
model.errorMessage = service.errorMessage;
}
if (model.CID.Length < 6)
{
return(RedirectToAction("Locations", "Manage"));
}
addLocationCookie(model.CID.Trim());
return(View(model));
}
public JsonResult Refresh(short MS_Maint_Code, string hidecompleted, int MFB_Id, string CID, bool Forced)
{
//int cpuUsage = cpuPercentage();
//if (cpuUsage > 80 && Forced == false)
// return Json("CPUERR", JsonRequestBehavior.AllowGet);
Helpers.CtxService service = new Helpers.CtxService(null, CID);
System.Web.Script.Serialization.JavaScriptSerializer jser = new System.Web.Script.Serialization.JavaScriptSerializer();
string objSerialized = "";
try
{
List <schedule> updated = new List <schedule>();
updated = service.getSchedule();
model.MS_Maint_Code = MS_Maint_Code;
model.MFB_Id = MFB_Id;
updated = filterSchedule(updated);
if (hidecompleted == "true")
{
List <schedule> uncompleted = new List <schedule>();
foreach (var item in updated)
{
if (item.MS_WOClosed_Timestamp.Trim().Length == 0)
{
uncompleted.Add(item);
}
}
objSerialized = jser.Serialize(uncompleted);
return(Json(objSerialized, JsonRequestBehavior.AllowGet));
}
objSerialized = jser.Serialize(updated);
}
catch (Exception ex)
{
objSerialized = "ERROR";
}
finally
{
service.Dispose();
}
return(Json(objSerialized, JsonRequestBehavior.AllowGet));
}
private void Save(string CID, schedule record)
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
switch (record.MS_Id)
{
case 0:
service.Add(record);
break;
default:
service.Update(record);
if (record.MS_Maint_Code == 1 && record.MS_Main_Comp_Date.ToUpper() == "TRUE")
{
if (record.MS_Frequency < 1)
{
throw new Exception("Interval must be greater than 0");
}
System.Threading.Tasks.Task.Run(() => AutoAddScheduledOrder(record, service));
}
break;
}
service.clearCache();
}
private List <schedule> getSchedule(int maint_code = 1)
{
//if (HttpContext.Cache["MaintenanceSchedule_" + model.CID] != null)
//{
// try
// {
// List<schedule> cachedrecs = (List<schedule>)HttpContext.Cache["MaintenanceSchedule_" + model.CID];
// if (cachedrecs.Count > 0)
// {
// if (maint_code == 1)
// {
// return (from x in cachedrecs orderby x.MS_Next_Main_Datetime ascending select x).ToList();
// }
// else
// {
// return (from x in cachedrecs select x).OrderBy(x => x.MS_WOCreate_Date).ToList();
// }
// }
// }
// catch (Exception ex)
// {
// Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
// }
//}
Helpers.CtxService service = new Helpers.CtxService(null, model.CID);
var recs = service.getSchedule();
//if (recs.Count > 0)
// service.cache(recs, model.CID);
return(recs);
}
public JsonResult RefreshFB(string CID)
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
return(Json(service.GetFlagboards()));
}
private IList <Helpers.PageInput> mapScheduleValues(IList <Helpers.PageInput> mobileInputs, int MS_Id, string CID)
{
if (MS_Id == 0)
{
return(mobileInputs);
}
Helpers.CtxService service = new Helpers.CtxService(null, CID);
Models.EF.Maintenance_Schedule schedule = service.getScheduleRecord(MS_Id);
if (schedule == null)
{
return(mobileInputs);
}
Helpers.objectMapper <Maintenance_Schedule> mapper = new Helpers.objectMapper <Maintenance_Schedule>();
Hashtable hash = mapper.createPropertyInfoHash();
ICollection keys = hash.Keys;
if (keys.Count > 0)
{
foreach (var item in mobileInputs)
{
try
{
if (hash[item.input.id.ToUpper()] != null)
{
PropertyInfo info = (PropertyInfo)hash[item.input.id.ToUpper()];
if (info != null && item.input != null)
{
var val = info.GetValue(schedule);
if (val == null)
{
val = "";
}
if (info.PropertyType.Name.ToUpper() == "DATETIME")
{
DateTime realdate = Convert.ToDateTime(val);
item.input.value = realdate.ToString("yyyy-MM-dd");
}
else
{
item.input.value = mapper.ConvertType(val.ToString(), "STRING").ToString();
}
}
}
} catch (Exception ex)
{
if (item.input != null)
{
item.errorFlag = true;
item.errorMessage = ex.Message;
}
}
}
}
return(mobileInputs);
}
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);
}
public JsonResult dispatch(string inputs, string type, string CID)
{
System.Web.Script.Serialization.JavaScriptSerializer jser = new System.Web.Script.Serialization.JavaScriptSerializer();
Helpers.CtxService service = new Helpers.CtxService(null, CID);
string userMessage = "";
int msid = 0;
if (inputs.Length == 0)
{
return(Json("Input Box Objects cannot be empty.", JsonRequestBehavior.AllowGet));
}
try
{
FlagBoard_mvc.Models.pageInputs[] inputObjects = jser.Deserialize <FlagBoard_mvc.Models.pageInputs[]>(inputs);
Helpers.jqGrid <FlagBoard_mvc.Models.schedule> jq = new Helpers.jqGrid <FlagBoard_mvc.Models.schedule>();
FlagBoard_mvc.Models.schedule record = jq.mapToObjectProperty(inputObjects);
switch (type)
{
case "edit":
if (record.MS_Unscheduled_Reason.Trim().Length > 50)
{
throw new Exception("Unscheduled Reason cannot be greater than 50 characters long.");
}
int rows = service.Update(record);
if (rows > 0 && record.MS_Maint_Code == 1 && record.MS_Main_Comp_Date == "True")
{
if (record.MS_Frequency < 1)
{
throw new Exception("Interval must be greater than 0");
}
AutoAddScheduledOrder(record, service);
}
userMessage = "true";
break;
case "add":
if (record.MS_Unscheduled_Reason.Length > 50)
{
throw new Exception("Unscheduled Reason cannot be greater than 50 characters long.");
}
int rowsaff = service.Add(record);
service.Dispose();
if (rowsaff == 0)
{
throw new Exception("unknown error adding rows. ");
}
userMessage = "true";
msid = service.rowKey;
break;
case "delete":
service.delete(record.MS_Id);
userMessage = "true";
break;
}
} catch (Exception ex)
{
userMessage = "ERROR: " + ex.Message;
} finally
{
service.Dispose();
service.clearCache();
}
return(Json(new { message = userMessage, id = msid }, JsonRequestBehavior.AllowGet));
}
private void delete(string CID, schedule record)
{
Helpers.CtxService service = new Helpers.CtxService(null, CID);
service.deleteAsync(record.MS_Id);
service.clearCache();
}