public ResultResponse AddDefectToPosition(DefectPostionModel DefectPostionModel, int UserId) { try { accessManager.SqlConnectionOpen(DataBase.QMSDatabase); ResultResponse result = new ResultResponse(); var DefectList = new JavaScriptSerializer().Serialize(DefectPostionModel.DefectList); List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@PositionName", DefectPostionModel.DefectPositionName)); aParameters.Add(new SqlParameter("@DefectList", DefectList)); aParameters.Add(new SqlParameter("@UserId", UserId)); aParameters.Add(new SqlParameter("@PositionId", DefectPostionModel.DefectPoistionId)); aParameters.Add(new SqlParameter("@CategoryId", DefectPostionModel.CategoryId)); result.isSuccess = accessManager.SaveData("sp_AddDefectToPosition", aParameters); result.msg = "Defect Added To Position"; return(result); } catch (Exception e) { throw e; } finally { accessManager.SqlConnectionClose(); } }
public List <DefectPostionModel> ShowGridByDefectPosition(int DefectPositionId, int MasterSilhouteeId, int FrontOrBack) { try { accessManager.SqlConnectionOpen(DataBase.QMSDatabase); List <DefectPostionModel> DefectPositionList = new List <DefectPostionModel>(); List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@DefectPositionId", DefectPositionId)); aParameters.Add(new SqlParameter("@MasterSilhoutteId", MasterSilhouteeId)); aParameters.Add(new SqlParameter("@FrontOrBack", FrontOrBack)); SqlDataReader dr = accessManager.GetSqlDataReader("sp_ShowGridByPosition", aParameters); while (dr.Read()) { DefectPostionModel defect = new DefectPostionModel(); defect.DefectPoistionId = (int)dr["DefectPoistionId"]; defect.GridNo = (int)dr["GridNo"]; defect.DefectPositionName = dr["DefectPositionName"].ToString(); defect.DefectColor = dr["DefectColor"].ToString(); DefectPositionList.Add(defect); } return(DefectPositionList); } catch (Exception exception) { throw exception; } finally { accessManager.SqlConnectionClose(); } }
public List <DefectPostionModel> GetDefectByPosition(string PositionId) { try { accessManager.SqlConnectionOpen(DataBase.QMSDatabase); List <DefectPostionModel> DefectPositionList = new List <DefectPostionModel>(); List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@DefectPositionId", PositionId)); SqlDataReader dr = accessManager.GetSqlDataReader("sp_GetDefectByPositionId", aParameters); while (dr.Read()) { DefectPostionModel defect = new DefectPostionModel(); defect.DefectPoistionId = (int)dr["DefectPoistionId"]; defect.DefectPositionName = dr["DefectPositionName"].ToString(); DefectPositionList.Add(defect); } return(DefectPositionList); } catch (Exception exception) { throw exception; } finally { accessManager.SqlConnectionClose(); } }
public ActionResult AddDefectToPosition(DefectPostionModel DefectPostionModel) { if (Session["IncentiveUserId"] == null) { return(RedirectToAction("Index", "Account")); } int userid = Convert.ToInt32(Session["IncentiveUserId"]); return(Json(qmsDAL.AddDefectToPosition(DefectPostionModel, userid), JsonRequestBehavior.AllowGet)); }