public ActionResult EditAssign(Nullable <int> id, FormCollection formValues) { // this method used just for delete now uls_dbDataContext db = new uls_dbDataContext(); electronics_assgn elecA = new electronics_assgn(); try { string strOper = formValues.GetValues("oper")[0]; string strElectID = formValues.GetValues("id")[0]; // string strQualID = formValues.GetValues("strQualID")[0]; if (strOper == "del") { elecA = db.electronics_assgns.Single(e => e.assign_id == Convert.ToInt32(strElectID)); db.electronics_assgns.DeleteOnSubmit(elecA); db.SubmitChanges(); } return(Content("Success")); } catch (Exception ex) { string strErr = ex.Message; return(Content(strErr)); } }
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)); }