示例#1
0
        //save
        public ActionResult SaveMasterInfo(InspRejectionMaster objMaster)
        {
            var user = (User)Session["CurrentUser"];

            //objMaster.UserId = user.EMPID;
            objMaster.UserName = user.EMPID;
            var res = _repository.SaveMasterInfo(objMaster);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
        public string SaveMasterInfo(InspRejectionMaster objMaster)
        {
            string rv = "";

            try
            {
                var result = Insert_Update_MasterInfo("sp_insert_insp_rejection_refinish_master_info", "SAVE_INS_REJ_REFIN_MASTER", objMaster);
                rv = Operation.Success.ToString();
                return(result.Rows[0]["ID"].ToString());
            }
            catch (Exception ex)
            {
                rv = ex.Message;
            }
            return(rv);
        }
 public DataTable Insert_Update_MasterInfo(string procedure, string callname, InspRejectionMaster objMaster)
 {
     dbConn = new SqlConnection(ConnectionString);
     dbConn.Open();
     cmd             = new SqlCommand(procedure, dbConn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add(new SqlParameter("@call_name", callname));
     cmd.Parameters.Add(new SqlParameter("@ID", objMaster.ID));
     cmd.Parameters.Add(new SqlParameter("@SDate", objMaster.SDate));
     cmd.Parameters.Add(new SqlParameter("@UCode", objMaster.UCode));
     cmd.Parameters.Add(new SqlParameter("@UName", objMaster.UName));
     cmd.Parameters.Add(new SqlParameter("@TotalProd", objMaster.TotalProd));
     cmd.Parameters.Add(new SqlParameter("@UserName", objMaster.UserName));
     cmd.Parameters.Add(new SqlParameter("@InsFloorCode", objMaster.InsFloorCode));
     cmd.Parameters.Add(new SqlParameter("@InsFloorName", objMaster.InsFloorName));
     da = new SqlDataAdapter(cmd);
     dt = new DataTable();
     da.Fill(dt);
     dbConn.Close();
     return(dt);
 }
 public string SaveMasterInfo(InspRejectionMaster objMaster)
 {
     return(_service.SaveMasterInfo(objMaster));
 }