Exemplo n.º 1
0
        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));
            }
        }
Exemplo n.º 2
0
        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));
        }