public JsonResult SaveInspectionOperatorProductionDetail(TblStock22 operatorProductionDetail)
{
if (operatorProductionDetail != null)
{
var user = (User)Session["CurrentUser"];
operatorProductionDetail.UName = user.USERNAME;
operatorProductionDetail.EDate = DateTime.Now;
}
var res = _repository.SaveInspectionOperatorProductionDetail(operatorProductionDetail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public TblStock22 SaveInspectionOperatorProductionDetail(TblStock22 operatorProductionDetail)
{
var res = new TblStock22();
var dt = new DataTable();
try
{
dt = InsertOrUpdateInspectionOperatorProductionDetail("SP_INSERT_INSPECTION_PRODUCTION_OPERATOR_PRODUCTION_INFO", "SAVE_INSPECTION_OPERATOR_PRODUCTION", operatorProductionDetail);
res.SaveStatus = Operation.Success.ToString();
res.DID = Convert.ToInt32(dt.Rows[0]["DID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public TblStock22 SaveInspectionOperatorProductionDetail(TblStock22 operatorProductionDetail)
{
return(_service.SaveInspectionOperatorProductionDetail(operatorProductionDetail));
}
public DataTable InsertOrUpdateInspectionOperatorProductionDetail(string procedure, string callname, TblStock22 operatorProductionDetail)
{
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("@DID", operatorProductionDetail.DID));
cmd.Parameters.Add(new SqlParameter("@ID", operatorProductionDetail.ID));
cmd.Parameters.Add(new SqlParameter("@OCode", operatorProductionDetail.OCode));
cmd.Parameters.Add(new SqlParameter("@OName", operatorProductionDetail.OName));
cmd.Parameters.Add(new SqlParameter("@CapName", operatorProductionDetail.CapName));
cmd.Parameters.Add(new SqlParameter("@CapCode", operatorProductionDetail.CapCode));
cmd.Parameters.Add(new SqlParameter("@Desig", operatorProductionDetail.Desig));
cmd.Parameters.Add(new SqlParameter("@AcProd", operatorProductionDetail.AcProd));
cmd.Parameters.Add(new SqlParameter("@ReFinish", operatorProductionDetail.ReFinish));
cmd.Parameters.Add(new SqlParameter("@ReInspection", operatorProductionDetail.ReInspection));
cmd.Parameters.Add(new SqlParameter("@Sample", operatorProductionDetail.Sample));
cmd.Parameters.Add(new SqlParameter("@QCCheque", operatorProductionDetail.QCCheque));
cmd.Parameters.Add(new SqlParameter("@Hold", operatorProductionDetail.Hold));
cmd.Parameters.Add(new SqlParameter("@CP", operatorProductionDetail.CP));
cmd.Parameters.Add(new SqlParameter("@CutPeace", operatorProductionDetail.CutPeace));
cmd.Parameters.Add(new SqlParameter("@GreyMending", operatorProductionDetail.GreyMending));
cmd.Parameters.Add(new SqlParameter("@ShiftCode", operatorProductionDetail.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@Shift", operatorProductionDetail.Shift));
cmd.Parameters.Add(new SqlParameter("@STimeHr", operatorProductionDetail.STimeHr));
cmd.Parameters.Add(new SqlParameter("@Remarks", operatorProductionDetail.Remarks));
cmd.Parameters.Add(new SqlParameter("@EDate", operatorProductionDetail.EDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
