public List <TRANS_DEBT> TRANS_DEBT_Search(TRANS_DEBT obj)
{
DataTable dt = new DataTable();
try
{
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "TRANS_DEBT_Search",
obj.RefDate,
obj.RefDetailNo,
obj.RefNo,
obj.RefOrgNo,
obj.RefType,
obj.RefStatus,
obj.ExchangeRate,
obj.IsDebt,
obj.Amount,
obj.Discount,
obj.Payment,
obj.Balance,
obj.FAmount,
obj.FDiscount,
obj.FPayment,
obj.FBalance,
obj.Debit,
obj.Description
);
return(MapTRANS_DEBT(dt));
}
catch (Exception ex)
{
throw ex;
}
}
public int TRANS_DEBT_Update(TRANS_DEBT obj, string ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "TRANS_DEBT_Update",
ID,
obj.BookID,
obj.RefID,
obj.RefDate,
obj.RefDetailNo,
obj.RefNo,
obj.RefOrgNo,
obj.RefType,
obj.RefStatus,
obj.CustomerID,
obj.CurrencyID,
obj.ExchangeRate,
obj.IsDebt,
obj.Amount,
obj.Discount,
obj.Payment,
obj.Balance,
obj.FAmount,
obj.FDiscount,
obj.FPayment,
obj.FBalance,
obj.Debit,
obj.Description,
obj.Sorted
));
}
catch
{
//throw ex;
return(-1);
}
}
private List <TRANS_DEBT> MapTRANS_DEBT(DataTable dt)
{
List <TRANS_DEBT> rs = new List <TRANS_DEBT>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TRANS_DEBT obj = new TRANS_DEBT();
if (dt.Columns.Contains("ID"))
{
obj.ID = (dt.Rows[i]["ID"].ToString());
}
if (dt.Columns.Contains("BookID"))
{
obj.BookID = (dt.Rows[i]["BookID"].ToString());
}
if (dt.Columns.Contains("RefID"))
{
obj.RefID = (dt.Rows[i]["RefID"].ToString());
}
if (dt.Columns.Contains("RefDate"))
{
obj.RefDate = DateTime.Parse(dt.Rows[i]["RefDate"].ToString());
}
if (dt.Columns.Contains("RefDetailNo"))
{
obj.RefDetailNo = (dt.Rows[i]["RefDetailNo"].ToString());
}
if (dt.Columns.Contains("RefNo"))
{
obj.RefNo = (dt.Rows[i]["RefNo"].ToString());
}
if (dt.Columns.Contains("RefOrgNo"))
{
obj.RefOrgNo = (dt.Rows[i]["RefOrgNo"].ToString());
}
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("RefStatus"))
{
obj.RefStatus = int.Parse(dt.Rows[i]["RefStatus"].ToString());
}
if (dt.Columns.Contains("CustomerID"))
{
obj.CustomerID = (dt.Rows[i]["CustomerID"].ToString());
}
if (dt.Columns.Contains("CurrencyID"))
{
obj.CurrencyID = (dt.Rows[i]["CurrencyID"].ToString());
}
if (dt.Columns.Contains("ExchangeRate"))
{
obj.ExchangeRate = double.Parse(dt.Rows[i]["ExchangeRate"].ToString());
}
if (dt.Columns.Contains("IsDebt"))
{
obj.IsDebt = bool.Parse(dt.Rows[i]["IsDebt"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("Discount"))
{
obj.Discount = double.Parse(dt.Rows[i]["Discount"].ToString());
}
if (dt.Columns.Contains("Payment"))
{
obj.Payment = double.Parse(dt.Rows[i]["Payment"].ToString());
}
if (dt.Columns.Contains("Balance"))
{
obj.Balance = double.Parse(dt.Rows[i]["Balance"].ToString());
}
if (dt.Columns.Contains("FAmount"))
{
obj.FAmount = double.Parse(dt.Rows[i]["FAmount"].ToString());
}
if (dt.Columns.Contains("FDiscount"))
{
obj.FDiscount = double.Parse(dt.Rows[i]["FDiscount"].ToString());
}
if (dt.Columns.Contains("FPayment"))
{
obj.FPayment = double.Parse(dt.Rows[i]["FPayment"].ToString());
}
if (dt.Columns.Contains("FBalance"))
{
obj.FBalance = double.Parse(dt.Rows[i]["FBalance"].ToString());
}
if (dt.Columns.Contains("Debit"))
{
obj.Debit = double.Parse(dt.Rows[i]["Debit"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = (dt.Rows[i]["Description"].ToString());
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
rs.Add(obj);
}
return(rs);
}