public JsonResult SaveInspectionProductionMaster(TblStock11 master) { if (master != null) { var user = (User)Session["CurrentUser"]; master.DCode = 5; master.DName = "Inspection"; master.UserName = user.USERNAME; master.EDate = DateTime.Now; } var res = _repository.SaveInspectionProductionMaster(master); return(Json(res, JsonRequestBehavior.AllowGet)); }
public TblStock11 SaveInspectionProductionMaster(TblStock11 master) { var res = new TblStock11(); var dt = new DataTable(); try { dt = InsertOrUpdateInspectionProductionMaster("SP_INSERT_INSPECTION_PRODUCTION_MASTER_INFO", "SAVE_INSPECTION_PRODUCTION_MASTER", master); res.SaveStatus = Operation.Success.ToString(); res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString()); } catch (Exception ex) { res.SaveStatus = ex.Message; } return(res); }
public TblStock11 SaveInspectionProductionMaster(TblStock11 master) { return(_service.SaveInspectionProductionMaster(master)); }
public DataTable InsertOrUpdateInspectionProductionMaster(string procedure, string callname, TblStock11 master) { 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", master.ID)); cmd.Parameters.Add(new SqlParameter("@SDate", master.SDate)); cmd.Parameters.Add(new SqlParameter("@TracDate", master.TracDate)); cmd.Parameters.Add(new SqlParameter("@Ref", master.Ref)); cmd.Parameters.Add(new SqlParameter("@DID", master.DID)); cmd.Parameters.Add(new SqlParameter("@DCode", master.DCode)); cmd.Parameters.Add(new SqlParameter("@DName", master.DName)); cmd.Parameters.Add(new SqlParameter("@UCode", master.UCode)); cmd.Parameters.Add(new SqlParameter("@UName", master.UName)); cmd.Parameters.Add(new SqlParameter("@TotalProd", master.TotalProd)); cmd.Parameters.Add(new SqlParameter("@CProd", master.CProd)); cmd.Parameters.Add(new SqlParameter("@Gramending", master.Gramending)); cmd.Parameters.Add(new SqlParameter("@UserName", master.UserName)); cmd.Parameters.Add(new SqlParameter("@EDate", master.EDate)); cmd.Parameters.Add(new SqlParameter("@InsFloorCode", master.InsFloorCode)); cmd.Parameters.Add(new SqlParameter("@InsFloorName", master.InsFloorName)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }