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