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