private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
for (int i = 0; i < chkLSpType.Items.Count; i++)
{
chkLSpType.Items[i].Selected = true;
}
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("All Issue Details", "AI"));
rdlStatus.Items.Add(new ListItem("Live Issue Details", "LI"));
rdlStatus.Items.Add(new ListItem("Live Customer Details", "LC"));
rdlStatus.Items.Add(new ListItem("Live Nominee Details", "LN"));
rdlStatus.Items.Add(new ListItem("Branch wise Commission", "CO"));
//rdlStatus.Items.Add(new ListItem("Interest Details", "ID"));
//rdlStatus.Items.Add(new ListItem("Encashment Details", "ED"));
rdlStatus.Items.Add(new ListItem("Reinvestment Commission", "RC"));
rdlStatus.Items.Add(new ListItem("Forward Day Interest", "FI"));
rdlStatus.Items.Add(new ListItem("Forward Day Encashment", "FE"));
//rdlStatus.Items.Add(new ListItem("Cert Magic Dump", "CM"));
rdlStatus.Items.Add(new ListItem("Issue Certificate Dump", "ID"));
rdlStatus.Items.Add(new ListItem("Statement Dump", "SD"));
//rdlStatus.Items.Add(new ListItem("ACE CCMS Dump", "AC"));
rdlStatus.Items.Add(new ListItem("Interest Reconciliation", "IR"));
rdlStatus.Items.Add(new ListItem("Principle Reconciliation", "PR"));
rdlStatus.Items.Add(new ListItem("Interest Outstanding", "IO"));
rdlStatus.Items.Add(new ListItem("Principle Outstanding", "PO"));
rdlStatus.Items.Add(new ListItem("Certificate Print Log", "CP"));
rdlStatus.Items.Add(new ListItem("User List", "UL"));
rdlStatus.Items.Add(new ListItem("Security Matrix", "SM"));
rdlStatus.Items.Add(new ListItem("Sale Document Upload MI", "SU"));
rdlStatus.Items.Add(new ListItem("Document Upload MI", "DU"));
rdlStatus.Items.Add(new ListItem("Sales Statement Reference", "SSR"));
rdlStatus.Items.Add(new ListItem("Interest Claim Reference", "ICR"));
rdlStatus.Items.Add(new ListItem("Commission Claim Reference", "CCR"));
rdlStatus.Items.Add(new ListItem("Encashment Claim Reference", "ECR"));
rdlStatus.Items.Add(new ListItem("Reinvestment Statement Reference", "RSR"));
//rdlStatus.Items.Add(new ListItem("Sales Statement Reconciliation Advice", "DU"));
//rdlStatus.Items.Add(new ListItem("Interest Claim Reconciliation Advice", "DU"));
//rdlStatus.Items.Add(new ListItem("Encashment Claim Reconciliation Advice", "DU"));
//rdlStatus.Items.Add(new ListItem("Commission Claim Reconciliation Advice", "DU"));
//rdlStatus.Items.Add(new ListItem("Duplicate Issue Claim Settlement", "DU"));
//rdlStatus.Items.Add(new ListItem("General Letter", "DU"));
//rdlStatus.Items.Add(new ListItem("BB Policy Circular", "DU"));
//rdlStatus.Items.Add(new ListItem("Explanation Letter", "DU"));
//rdlStatus.Items.Add(new ListItem("Stop Payment Letter", "DU"));
//rdlStatus.Items.Add(new ListItem("Lien Letter", "DU"));
//rdlStatus.Items.Add(new ListItem("Other Letter", "DU"));
rdlStatus.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
//exclusive currency list
int i = ddlCurrency.Items.Count;
for (int j = 0; j < i; j++)
{
for (int k = 0; k < i; k++)
{
if (ddlCurrency.Items[k].Value != "" && ddlCurrency.Items[k].Value != "00" && ddlCurrency.Items[k].Value != "01")
{
ddlCurrency.Items.RemoveAt(k);
i--;
j--;
break;
}
}
}
ListItem li = new ListItem();
li.Value = "99"; li.Text = "All";
ddlCurrency.Items.Add(li);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Requisition on Specific Date", Convert.ToString((int)Constants.ACTIVITY_TYPE.REQUISITION_SPECIFIC_DATE)));
rdlStatus.Items.Add(new ListItem("Requisition As on Date", Convert.ToString((int)Constants.ACTIVITY_TYPE.REQUISITION_AS_ON_DATE)));
rdlStatus.Items[0].Selected = true;
txtDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
DDListUtil.LoadDDLFromDB(ddlPayment, "PaymentMode", "Description", "SPMS_PaymentMode", true);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.ISSUE)));
rdlStatus.Items.Add(new ListItem("Interest", Convert.ToString((int)Constants.ACTIVITY_TYPE.INTEREST)));
rdlStatus.Items.Add(new ListItem("Encashed", Convert.ToString((int)Constants.ACTIVITY_TYPE.ENCASHED)));
rdlStatus.Items[2].Selected = true;
ddlStatus.Items.Add(new ListItem("Created", Convert.ToString(Constants.TRANSACTION_STATUS.CREATED)));
ddlStatus.Items.Add(new ListItem("Ready For Approve", Convert.ToString(Constants.TRANSACTION_STATUS.READY_FOR_APPROVE)));
ddlStatus.Items.Add(new ListItem("Approved", Convert.ToString(Constants.TRANSACTION_STATUS.APPROVED)));
ddlStatus.Items.Add(new ListItem("Rejected", Convert.ToString(Constants.TRANSACTION_STATUS.REJECTED)));
ddlStatus.Items.Add(new ListItem("Canceled", Convert.ToString(Constants.TRANSACTION_STATUS.CANCELED)));
ddlStatus.Items[2].Selected = true;//By default "Approved" will be set
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
Util.ChkChangeSetColor(chkForAllUser);
}
protected void ddlCurrency_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddlCurrency.SelectedValue))
{
if (ddlCurrency.SelectedValue == "99")
{
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
}
else
{
DDListUtil.LoadCheckBoxListByCurrencyID(chkLSpType, ddlCurrency.SelectedValue);
}
}
else
{
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
}
//if (!string.IsNullOrEmpty(ddlCurrency.SelectedValue))
//{
// DDListUtil.LoadCheckBoxListByCurrencyID(chkLSpType, ddlCurrency.SelectedValue);
//}
//else
//{
// DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
//}
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
//exclusive currency list
int i = ddlCurrency.Items.Count;
for (int j = 0; j < i; j++)
{
for (int k = 0; k < i; k++)
{
if (ddlCurrency.Items[k].Value != "" && ddlCurrency.Items[k].Value != "00" && ddlCurrency.Items[k].Value != "01")
{
ddlCurrency.Items.RemoveAt(k);
i--;
j--;
break;
}
}
}
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtBBDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtOurDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Audit Trail (SP Received)", Constants.ACTIVITY_TYPE.RECEIVE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Stop Payment Remove)", Constants.ACTIVITY_TYPE.STOP_PAYMENT_REMOVE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Issue)", Constants.ACTIVITY_TYPE.ISSUE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Duplicate Issue)", Constants.ACTIVITY_TYPE.DUPLICATE_ISSUE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Reinvestment)", Constants.ACTIVITY_TYPE.REINVESTMENT.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Commission Reimbursement)", Constants.ACTIVITY_TYPE.COMMISSION_REIMBURSE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Interest Payment)", Constants.ACTIVITY_TYPE.INTEREST_PAYMENT.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Interest Reimbursement)", Constants.ACTIVITY_TYPE.INTEREST_REIMBURSE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Principle Payment)", Constants.ACTIVITY_TYPE.PRINCIPAL_PAYMENT.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Principle Reimbursement)", Constants.ACTIVITY_TYPE.PRINCIPAL_REIMBURSE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Lien)", Constants.ACTIVITY_TYPE.LIEN_MARK.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Reconciliation)", Constants.ACTIVITY_TYPE.RECONCILIATION.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Lien Withdrawal)", Constants.ACTIVITY_TYPE.LIEN_WITHDRAWAL.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Add Journals)", Constants.ACTIVITY_TYPE.ADD_JOURNALS.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Stop Payment)", Constants.ACTIVITY_TYPE.STOP_PAYMENT.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Issue Update)", Constants.ACTIVITY_TYPE.ISSUE_UPDATE.ToString()));
rdlStatus.Items.Add(new ListItem("Audit Trail (Issue Update Details)", Constants.ACTIVITY_TYPE.ISSUE_UPDATE_DETAILS.ToString()));
rdlStatus.Items[0].Selected = true;
// end of Report Type List
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLJournalType, "JournalType", "Description", "SPMS_JournalType");
if (ddlUploadStatus.Items.Count > 0)
{
ddlUploadStatus.Text = "1";
}
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlReportType.Items.Add(new ListItem("Paid", Constants.ACTIVITY_TYPE.PAID.ToString()));
rdlReportType.Items.Add(new ListItem("Claimed", Constants.ACTIVITY_TYPE.CLAIMED.ToString()));
rdlReportType.Items.Add(new ListItem("Cleared", Constants.ACTIVITY_TYPE.CLEARED.ToString()));
rdlReportType.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlReportType);
Util.RBLChangeColor(rdlReportType);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
DDListUtil.LoadDDLFromDB(ddlUserName, "UserName", "UserName", "SA_User", false);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Lien Mark", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_MARK)));
rdlStatus.Items.Add(new ListItem("Lien Mark Remove", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_MARK_REMOVE)));
rdlStatus.Items.Add(new ListItem("Active Lien", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_ACTIVE)));
rdlStatus.Items.Add(new ListItem("Lien Status", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_STATUS)));
rdlStatus.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("ACE Activate Register Report", "AA"));
rdlStatus.Items.Add(new ListItem("ACE Deactivate Register Report", "AD"));
rdlStatus.Items.Add(new ListItem("ACE Payment Report", "AP"));
rdlStatus.Items.Add(new ListItem("ACE Audit Trail", "AT"));
rdlStatus.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
txtDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
//exclusive currency list
int i = ddlCurrency.Items.Count;
for (int j = 0; j < i; j++)
{
for (int k = 0; k < i; k++)
{
if (ddlCurrency.Items[k].Value != "" && ddlCurrency.Items[k].Value != "00" && ddlCurrency.Items[k].Value != "01")
{
ddlCurrency.Items.RemoveAt(k);
i--;
j--;
break;
}
}
}
ListItem li = new ListItem();
li.Value = "99"; li.Text = "All";
ddlCurrency.Items.Add(li);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.ISSUE)));
rdlStatus.Items.Add(new ListItem("Old Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.ISSUE_OLD)));
rdlStatus.Items.Add(new ListItem("Reinvest", Convert.ToString((int)Constants.ACTIVITY_TYPE.REINVESTMENT)));
rdlStatus.Items.Add(new ListItem("Stop Payment", Convert.ToString((int)Constants.ACTIVITY_TYPE.STOP_PAYMENT)));
rdlStatus.Items.Add(new ListItem("Stop Payment Remove", Convert.ToString((int)Constants.ACTIVITY_TYPE.STOP_PAYMENT_REMOVE)));
rdlStatus.Items.Add(new ListItem("Duplicate Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.DUPLICATE_ISSUE)));
rdlStatus.Items.Add(new ListItem("Lien Mark", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_MARK)));
rdlStatus.Items.Add(new ListItem("Lien Mark Remove", Convert.ToString((int)Constants.ACTIVITY_TYPE.LIEN_MARK_REMOVE)));
rdlStatus.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
Util.ChkChangeSetColor(chkBelow);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadCheckBoxListFromDB(chkLSpType, "SPTypeID", "TypeDesc", "SPMS_SPType");
DDListUtil.LoadDDLFromDB(ddlUserName, "UserName", "UserName", "SA_User", false);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// load Report Type List
rdlStatus.Items.Add(new ListItem("Stop Payment", Convert.ToString((int)Constants.ACTIVITY_TYPE.STOP_PAYMENT)));
rdlStatus.Items.Add(new ListItem("Duplicate Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.DUPLICATE_ISSUE)));
rdlStatus.Items.Add(new ListItem("Active Stop Payment", Convert.ToString((int)Constants.ACTIVITY_TYPE.STOP_PAYMENT_ACTIVE)));
rdlStatus.Items.Add(new ListItem("Active Duplicate Issue", Convert.ToString((int)Constants.ACTIVITY_TYPE.DUPLICATE_ISSUE_ACTIVE)));
rdlStatus.Items.Add(new ListItem("Stop Payment Remove", Convert.ToString((int)Constants.ACTIVITY_TYPE.STOP_PAYMENT_REMOVE)));
rdlStatus.Items[0].Selected = true;
Util.RBLChangeSetColor(rdlStatus);
Util.RBLChangeColor(rdlStatus);
}