public ActionResult EditElectronicsAsgn()
{
string strRet;
uls_dbDataContext db = new uls_dbDataContext();
string strElectronicsID = Request.Form["hdnAsgnEditID"];
string strOperation = Request.Form["hdnAsgnEditOper"];
string strAsgnDt = Request.Form["dtElectronicsAsgnDt"];
string strRetDt = Request.Form["dtElectronicsRetDt"];
string strAsgnCond = Request.Form["ddlAsgnCond"];
string strRetCond = Request.Form["ddlRetCond"];
string strAsgndTo = Request.Form["ddlAssignedTo"];
string strComments = Request.Form["txtElectronicsAsgnComments"];
string strAsgnID = Request.Form["hdnAsgnID"];
try
{
electronics_assgn electonics_assign;
electronic elctrnc = db.electronics.Single(a => a.electronics_id == strElectronicsID);
if (strOperation == "Edit")
{
int intAsgnID = Convert.ToInt32(strAsgnID);
electonics_assign = db.electronics_assgns.Single(a => a.assign_id == intAsgnID);
}
else // add
{
electonics_assign = new electronics_assgn();
electonics_assign.electronics_id = strElectronicsID;
}
if (strOperation == "Edit" || strOperation == "Add")
{
electonics_assign.assigned_to = strAsgndTo;
if (IsDate(strAsgnDt))
{
electonics_assign.assigned_dt = Convert.ToDateTime(strAsgnDt);
elctrnc.assigned = true;
}
if (IsDate(strRetDt))
{
electonics_assign.return_dt = Convert.ToDateTime(strRetDt);
elctrnc.assigned = false;
}
Int16 intAsignCond;
if (Int16.TryParse(strAsgnCond, out intAsignCond))
{
electonics_assign.asgn_condition_id = intAsignCond;
}
Int16 intRetCond;
if (Int16.TryParse(strRetCond, out intRetCond))
{
electonics_assign.ret_condition_id = intRetCond;
}
electonics_assign.comment_txt = strComments;
if (strOperation == "Add")
{
db.electronics_assgns.InsertOnSubmit(electonics_assign);
}
}
db.SubmitChanges();
return(Content("Success"));
}
catch (Exception ex)
{
string msg = ex.Message;
strRet = msg;
}
finally
{
db.Dispose();
}
return(Content(strRet));
}
public ActionResult EditElectronics()
{
string strRet;
uls_dbDataContext db = new uls_dbDataContext();
string strOperation = Request.Form["hdnEditOper"];
string strElectronicsID;
if (strOperation == "Edit")
{
strElectronicsID = Request.Form["hdnEditID"];
}
else
{
strElectronicsID = Request.Form["txtElectronicsID"];
}
string strYear = Request.Form["txtElectronicsYear"];
string strType = Request.Form["ddlElectronicsType"];
string strMake = Request.Form["ddlElectronicsMake"];
string strModel = Request.Form["ddlElectronicsModel"];
string strLoc = Request.Form["ddlElectronicsLoc"];
string strMngBy = Request.Form["ddlElectronicsMngBy"];
string strRegBy = Request.Form["ddlElectronicsRegBy"];
string strMngByDt = Request.Form["dtElectronicsMngByDt"];
string strSerialNum = Request.Form["txtElectronicsSerialNum"];
string strAirCardNum = Request.Form["txtElectronicsAirCardNum"];
string strCost = Request.Form["txtElectronicsCost"];
string strStolen = Request.Form["hdnElectronicsStolen"];
string strInRepair = Request.Form["hdnElectronicsInRepair"];
string strTotaled = Request.Form["hdnElectronicsTotaled"];
string strUnknown = Request.Form["hdnElectronicsUnknown"];
string strComment = Request.Form["txtElectronicsComment"];
string strLogEntry = "";
bool blnObsolete = false;
try
{
electronic eltrnc;
electronic eltrncCheck;
electronics_edit_log logentry = new electronics_edit_log();
logentry.user_id = User.Identity.Name;
logentry.edit_dt = DateTime.Today;
logentry.electronics_id = strElectronicsID;
if (strOperation == "Edit")
{
eltrnc = db.electronics.Single(e => e.electronics_id == strElectronicsID);
}
else // add
{
if (strElectronicsID.Length <= 0)
{
throw new Exception("Invalid ID specified.");
}
if (strRegBy.Length <= 0)
{
throw new Exception("No Division specified in Registered By field.");
}
eltrnc = new electronic();
eltrnc.electronics_id = strElectronicsID;
eltrnc.assigned = false;
eltrncCheck = db.electronics.SingleOrDefault(e => e.electronics_id == eltrnc.electronics_id);
if (eltrncCheck != null)
{
throw new Exception("This ID already exists.");
}
}
if (strOperation == "Edit" || strOperation == "Add")
{
if (strComment != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Comment", eltrnc.comment == null ? "" : eltrnc.comment.ToString(), strComment, strLogEntry);
}
eltrnc.comment = strComment;
}
Single sngCost;
if (strCost != null)
{
if (Single.TryParse(strCost.Replace("$", ""), out sngCost))
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Cost", eltrnc.cost == null ? "0" : eltrnc.cost.ToString(), strCost.Replace("$", ""), strLogEntry);
}
eltrnc.cost = sngCost;
}
}
if (strYear != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Purchase Year", eltrnc.year_pur == null ? "0" : eltrnc.year_pur.ToString(), strYear, strLogEntry);
}
eltrnc.year_pur = strYear;
}
if (strUnknown != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Unknown", eltrnc.unknown == true ? "on" : "off", strUnknown, strLogEntry);
}
eltrnc.unknown = strUnknown == "on" ? true : false;
}
if (strInRepair != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("In Repair", eltrnc.in_repair == true ? "on" : "off", strInRepair, strLogEntry);
}
eltrnc.in_repair = strInRepair == "on" ? true : false;
}
Int16 intMake;
if (Int16.TryParse(strMake, out intMake))
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Make ID", eltrnc.make_id == null ? "0" : eltrnc.make_id.ToString(), strMake, strLogEntry);
}
eltrnc.make_id = intMake;
}
if (strMngBy != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Managed By", eltrnc.managed_by == null ? "" : eltrnc.managed_by.ToString(), strMngBy, strLogEntry);
}
eltrnc.managed_by = strMngBy;
}
if (IsDate(strMngByDt))
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Managed By Date", eltrnc.managed_by_dt != null ? String.Format("{0:MM/dd/yyyy}", eltrnc.managed_by_dt) : "X", strMngByDt, strLogEntry);
}
eltrnc.managed_by_dt = Convert.ToDateTime(strMngByDt);
}
Int16 intModel;
if (Int16.TryParse(strModel, out intModel))
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Model ID", eltrnc.model_id == null ? "0" : eltrnc.model_id.ToString(), strModel, strLogEntry);
}
eltrnc.model_id = intModel;
}
if (strRegBy != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Registered By", eltrnc.registered_by == null ? "" : eltrnc.registered_by.ToString(), strRegBy, strLogEntry);
}
eltrnc.registered_by = strRegBy;
}
if (eltrnc.registered_by == null || eltrnc.registered_by.Length <= 0)
{
throw new Exception("Registered By must be specified.");
}
if (strStolen != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Stolen", eltrnc.stolen == true ? "on" : "off", strStolen, strLogEntry);
if (eltrnc.stolen == false && strStolen == "on")
{
blnObsolete = true;
}
}
eltrnc.stolen = strStolen == "on" ? true : false;
}
if (strTotaled != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Totaled", eltrnc.totaled == true ? "on" : "off", strTotaled, strLogEntry);
if (eltrnc.totaled == false && strTotaled == "on")
{
blnObsolete = true;
}
}
eltrnc.totaled = strTotaled == "on" ? true : false;
}
Int16 intType;
if (Int16.TryParse(strType, out intType))
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Type ID", eltrnc.type_id == null ? "" : eltrnc.type_id.ToString(), strType, strLogEntry);
}
eltrnc.type_id = intType;
}
if (strSerialNum != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Serial Num", eltrnc.serial_num == null ? "" : eltrnc.serial_num.ToString(), strSerialNum, strLogEntry);
}
eltrnc.serial_num = strSerialNum;
}
if (strAirCardNum != null)
{
if (strOperation == "Edit")
{
string strNumStripped = System.Text.RegularExpressions.Regex.Replace(strAirCardNum, "\\D", "");
strLogEntry = CheckEditField("Air Card Num", eltrnc.air_card_num == null ? "" : eltrnc.air_card_num.ToString(), strAirCardNum, strLogEntry);
}
eltrnc.air_card_num = strAirCardNum;
}
if (eltrnc.serial_num != null && eltrnc.serial_num.Length > 0)
{
eltrncCheck = db.electronics.SingleOrDefault(e => e.serial_num == eltrnc.serial_num);
if (eltrncCheck != null)
{
if (eltrnc.electronics_id != eltrncCheck.electronics_id)
{
throw new Exception("Serial Number already exists for: " + eltrncCheck.electronics_id);
}
}
}
if (strLoc != null)
{
if (strOperation == "Edit")
{
strLogEntry = CheckEditField("Location", eltrnc.location == null ? "" : eltrnc.location.ToString(), strLoc, strLogEntry);
}
eltrnc.location = strLoc;
}
if (strOperation == "Add")
{
strLogEntry = "Record Added.";
db.electronics.InsertOnSubmit(eltrnc);
}
}
if (strLogEntry != "")
{
if (strOperation == "Edit")
{
logentry.edit_change = "Modified: " + strLogEntry;
}
else
{
logentry.edit_change = strLogEntry;
}
db.electronics_edit_logs.InsertOnSubmit(logentry);
}
db.SubmitChanges();
if (blnObsolete == true && Convert.ToString(Session["division"]) == "ULS-PA")
{
db.UpdateObsoleteId(strElectronicsID);
}
return(Content("Success" + "," + Session["division"]));
}
catch (Exception ex)
{
string msg = ex.Message;
strRet = msg;
return(Content(strRet + "," + ""));
}
finally
{
db.Dispose();
}
}
