public void AddAECommissionAmountRecord(AECommissionAmount aeCommissionAmount)
{
try
{
aeCommissionAmount.Save();
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to add the Commission Amount record.");
}
}
/// <summary>TBD</summary>
/// <param name="aeId">TBD</param>
/// <param name="companyId">TBD</param>
/// <returns>TBD</returns>
public static List<AECommissionAmount> GetAECommissionAmounts(string aeId, int companyId)
{
List<AECommissionAmount> aeCommissionAmounts = new List<AECommissionAmount>();
DataSet historyData;
using (IO io = new IO(WebCommon.ConnectionString))
{
historyData = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("MASTERDATA_GETCOMMISSIONAMOUNTHISTORY",
Param.CreateParam("AEID", SqlDbType.VarChar, aeId),
Param.CreateParam("COMPANYID", SqlDbType.Int, companyId)));
}
if (historyData.Tables[0].Rows.Count == 0)
{
return aeCommissionAmounts;
}
AECommissionAmount commissionAmount;
foreach (DataRow commissionAmountRecord in historyData.Tables[0].Rows)
{
commissionAmount = new AECommissionAmount();
commissionAmount.AECommissionAmountId = (int)commissionAmountRecord["AE_COMMISSION_AMOUNT_ID"];
commissionAmount.AEId = Convert.ToString(IO.GetDataRowValue(commissionAmountRecord, "ACCOUNT_EXECUTIVE_ID", ""));
commissionAmount.CommissionYear = (int)commissionAmountRecord["COMMISSION_YEAR"];
commissionAmount.CommissionAmount = Convert.ToDouble(commissionAmountRecord["COMMISSION_AMOUNT"]);
commissionAmount.EntryDate = Convert.ToDateTime(IO.GetDataRowValue(commissionAmountRecord, "ENTRY_DATE", DateTime.MinValue));
commissionAmount.DateLastModified = Convert.ToDateTime(IO.GetDataRowValue(commissionAmountRecord, "DATE_LAST_MODIFIED", DateTime.MinValue));
commissionAmount.EnteredBy = Convert.ToString(IO.GetDataRowValue(commissionAmountRecord, "ENTERED_BY", ""));
commissionAmount.CompanyId = (int)commissionAmountRecord["COMPANY_ID"];
aeCommissionAmounts.Add(commissionAmount);
}
return aeCommissionAmounts;
}