public TblBeamStockDetails SaveBeamStockDetail(TblBeamStockDetails detail) { var res = new TblBeamStockDetails(); var dt = new DataTable(); try { dt = InsertOrUpdateBeamStockDetail("SP_INSERT_BEAM_STOCK_DETAIL_INFO", "SAVE_DETAIL", detail); res.SaveStatus = Operation.Success.ToString(); res.BIID = Convert.ToInt32(dt.Rows[0]["BIID"].ToString()); } catch (Exception ex) { res.SaveStatus = ex.Message; } return(res); }
public JsonResult SaveBeamStockDetail(TblBeamStockDetails detail) { var result = _repository.SaveBeamStockDetail(detail); return(Json(result, JsonRequestBehavior.AllowGet)); }
public TblBeamStockDetails SaveBeamStockDetail(TblBeamStockDetails detail) { return(_service.SaveBeamStockDetail(detail)); }
public DataTable InsertOrUpdateBeamStockDetail(string procedure, string callname, TblBeamStockDetails detail) { 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("@BIID", detail.BIID)); cmd.Parameters.Add(new SqlParameter("@BID", detail.BID)); cmd.Parameters.Add(new SqlParameter("@SetNo", detail.SetNo)); cmd.Parameters.Add(new SqlParameter("@StyleNo", detail.StyleNo)); cmd.Parameters.Add(new SqlParameter("@SS", detail.SS)); cmd.Parameters.Add(new SqlParameter("@BeamNo1", detail.BeamNo1)); cmd.Parameters.Add(new SqlParameter("@Length", detail.Length)); cmd.Parameters.Add(new SqlParameter("@Value", detail.Value)); cmd.Parameters.Add(new SqlParameter("@BeamNo", detail.BeamNo)); cmd.Parameters.Add(new SqlParameter("@WarpCount", detail.WarpCount)); cmd.Parameters.Add(new SqlParameter("@PDate", detail.PDate.Value.ToString("yyyy/MM/dd"))); cmd.Parameters.Add(new SqlParameter("@StockDays", detail.StockDays)); cmd.Parameters.Add(new SqlParameter("@PType", detail.PType)); cmd.Parameters.Add(new SqlParameter("@PCode", detail.PCode)); cmd.Parameters.Add(new SqlParameter("@Construction", detail.Construction)); cmd.Parameters.Add(new SqlParameter("@Remarks", detail.Remarks)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }