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