public void AddAEDrawPaymentRecord(AEDrawPayment aeDrawPayment)
{
try
{
aeDrawPayment.Save();
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the Draw/Payment record.");
}
}
/// <summary>TBD</summary>
/// <param name="aeId">TBD</param>
/// <param name="companyId">TBD</param>
/// <returns>TBD</returns>
public static List<AEDrawPayment> GetAEDrawPayments(string aeId, int companyId)
{
List<AEDrawPayment> aeDrawPayments = new List<AEDrawPayment>();
DataSet historyData;
using (IO io = new IO(WebCommon.ConnectionString))
{
historyData = io.ExecuteDataSetQuery(IO.CreateCommandFromSql("SELECT * FROM AE_DRAW_PAYMENT WHERE LTRIM(RTRIM(ACCOUNT_EXECUTIVE_ID)) = LTRIM(RTRIM('{0}')) AND COMPANY_ID={1} ORDER BY DRAW_PAYMENT_YEAR DESC, DRAW_PAYMENT_TYPE, PAYMENT_MONTH", aeId, companyId));
}
if (historyData.Tables[0].Rows.Count == 0)
{
return aeDrawPayments;
}
AEDrawPayment drawPayment;
foreach (DataRow drawPaymentRecord in historyData.Tables[0].Rows)
{
drawPayment = new AEDrawPayment();
drawPayment.AEDrawPaymentId = (int)drawPaymentRecord["AE_DRAW_PAYMENT_ID"];
drawPayment.AEId = Convert.ToString(IO.GetDataRowValue(drawPaymentRecord, "ACCOUNT_EXECUTIVE_ID", ""));
drawPayment.DrawPaymentType = (string)drawPaymentRecord["DRAW_PAYMENT_TYPE"];
drawPayment.DrawPaymentAmount = Convert.ToDouble(drawPaymentRecord["DRAW_PAYMENT_AMOUNT"]);
drawPayment.DrawPaymentYear = (int)drawPaymentRecord["DRAW_PAYMENT_YEAR"];
drawPayment.PaymentMonth = Convert.ToInt32(IO.GetDataRowValue(drawPaymentRecord, "PAYMENT_MONTH", -1));
drawPayment.PaymentDate = Convert.ToDateTime(IO.GetDataRowValue(drawPaymentRecord, "PAYMENT_DATE", DateTime.MinValue));
drawPayment.PaymentMonth = Convert.ToInt32(IO.GetDataRowValue(drawPaymentRecord, "PAYMENT_MONTH", -1));
drawPayment.EnteredBy = Convert.ToString(IO.GetDataRowValue(drawPaymentRecord, "ENTERED_BY", ""));
drawPayment.CompanyId = (int)drawPaymentRecord["COMPANY_ID"];
drawPayment.PaymentDate = Convert.ToDateTime(IO.GetDataRowValue(drawPaymentRecord, "DATE_LAST_MODIFIED", DateTime.MinValue));
aeDrawPayments.Add(drawPayment);
}
return aeDrawPayments;
}
