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));
}
