public int GetRefundID(int orderNumber)
{
int refundID = 0;
using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetAllRefunds", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Refund RF = new Refund();
RF.RefundID = Convert.ToInt32(row["RefundID"].ToString());
refundID = RF.RefundID;
}
}
}
return(refundID);
}