public string SaveRecInfo(FinishingStockRec objRec)
{
string rv = "";
try
{
var result = Insert_Update_RecInfo("sp_insert_finishing_stock_rec_info", "SAVE_FINISHING_STOCK_REC", objRec);
rv = Operation.Success.ToString();
return(result.Rows[0]["FIID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_RecInfo(string procedure, string callname, FinishingStockRec objRec)
{
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("@FIID", objRec.FIID));
cmd.Parameters.Add(new SqlParameter("@FID", objRec.FID));
cmd.Parameters.Add(new SqlParameter("@SetNo", objRec.SetNo));
cmd.Parameters.Add(new SqlParameter("@SSNo", objRec.SSNo));
cmd.Parameters.Add(new SqlParameter("@Loom", objRec.Loom));
cmd.Parameters.Add(new SqlParameter("@StyleNo", objRec.StyleNo));
cmd.Parameters.Add(new SqlParameter("@StyleCode", objRec.StyleCode));
cmd.Parameters.Add(new SqlParameter("@RecQnty", objRec.RecQnty));
cmd.Parameters.Add(new SqlParameter("@Remarks", objRec.Remarks));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveRecInfo(FinishingStockRec objRec)
{
return(_service.SaveRecInfo(objRec));
}
