private void InitializeData()
{
lblTitle.Text = Title;
gvSearchList.PageSize = (int)Constants.PAGING_SEARCH;
DDListUtil.LoadDDLFromDB(ddlSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
Clear();
}
private void InitializeData()
{
hdRegNo.Value = "";
hdIssueTransNo.Value = "";
hdChargeAmount.Value = "";
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromDB(ddlBranch, "BranchID", "BranchName", "SPMS_Branch", true);
// end of Intial Data
// Issue Details
txtIssueDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
Util.ControlEnabled(ddlSpType, false);
Util.ControlEnabled(ddlBranch, false);
Util.ControlEnabled(txtIssueDate, false);
Util.ControlEnabled(ddlCustomerType, false);
Util.ControlEnabled(txtAppliedAmount, false);
// Bond Holder Details
Util.ControlEnabled(txtBHDHolderName, false);
//Util.ControlEnabled(txtIssueName, false);
Util.ControlEnabled(txtBHDAddress, false);
Util.ControlEnabled(txtBHDRelation, false);
Util.ControlEnabled(ucUserDet.FindControl("txtMakerId"), false);
Util.ControlEnabled(ucUserDet.FindControl("txtMakeDate"), false);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerId"), false);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckDate"), false);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), false);
gvCustomerDetail.DataSource = null;
gvCustomerDetail.DataBind();
gvNomDetail.DataSource = null;
gvNomDetail.DataBind();
//gvNomDemon.DataSource = null;
//gvNomDemon.DataBind();
gvDenomDetail.DataSource = null;
gvDenomDetail.DataBind();
ddlCertificateType.SelectedIndex = 0;
ddlCertCustomerType.SelectedValue = "REGULAR";
txtLastCertDate.Text = "";
txtNoofCertPrint.Text = "0";
txtLastMaker.Text = "";
txtDuplicate.Text = "";
ddlWaiveCharges.SelectedIndex = 0;
txtChargeAmount.Text = "0.00";
txtVATAmount.Text = "0.00";
txtTotalAmount.Text = "0.00";
ddlTaxYear.SelectedValue = DateTime.Today.Year.ToString();
}
public void SetObject(Group oGp)
{
txtGroupID.Text = oGp.GroupID.ToString();
txtGroupName.Text = oGp.GroupName.ToString();
txtDescription.Text = oGp.Description.ToString();
DDListUtil.Assign(ddlDepartmentID, oGp.Department.DepartmentID);
DataTable dtOpr = (DataTable)Session[Constants.SES_GROUP_OPERATION_DATA];
int iCount = dtOpr.Rows.Count;
DataView dv = new DataView();
dv.Table = oGp.DTScreenList;
if (oGp.DTScreenList.Rows.Count > 0)
{
foreach (GridViewRow row in gvScreenList.Rows)
{
dv.RowFilter = "ScreenID = '" + row.Cells[0].Text + "'";
if (dv.Count > 0)
{
if (dv[0]["ScreenID"].ToString() == row.Cells[0].Text)
{
string sOperationCode = dv[0]["OperationCode"].ToString();
for (int i = dtOpr.Rows.Count; i > 0; i--)
{
CheckBox chk = (CheckBox)row.FindControl(dtOpr.Rows[i - 1]["Description"].ToString());
string sRowVal = dtOpr.Rows[i - 1]["OperationTypeID"].ToString();
if (sOperationCode.Contains(sRowVal))
{
if (chk != null)
{
if (sRowVal.Equals("1"))
{
if (!sOperationCode[0].ToString().Equals(sRowVal))
{
continue;
}
}
chk.Checked = true;
}
}
else
{
if (chk != null)
{
chk.Checked = false;
}
}
}
}
}
}
}
//UserDetails userDetail = oGp.UserDetails;
//userDetail.MakeDate = DateTime.Now;
//ucUserDet.UserDetail = userDetail;
hdGpID.Value = oGp.GroupID.ToString();
}
private void LoadSPType()
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue);
if (oResult.Status)
{
ddlDenomination.Items.Clear();
DataTable dtGetDenomID = (DataTable)oResult.Return;
if (dtGetDenomID.Rows.Count > 0)
{
DDListUtil.Assign(ddlDenomination, dtGetDenomID, true);
txtSeries.Text = string.Empty;
txtFrom.Text = string.Empty;
txtTo.Text = string.Empty;
txtQuantity.Text = string.Empty;
txtDnmAmount.Text = string.Empty;
txtDrawerNumber.Text = string.Empty;
txtCabinetNumber.Text = string.Empty;
gvReceiveDetail.DataSource = null;
gvReceiveDetail.DataBind();
}
}
}
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 LoadDataByID(string sUserID)
{
User oUser = new User(sUserID);
UserDAL oUserDAL = new UserDAL();
Result oResult = new Result();
oResult = oUserDAL.LoadByID(oUser);
if (oResult.Status)
{
oUser = (User)oResult.Return;
if (oUser != null)
{
txtLoginUserID.Text = oUser.UserName.ToString();
txtUserFirstName.Text = oUser.FirstName.ToString();
txtUserLastName.Text = oUser.LastName.ToString();
txtNewPassword.Attributes.Add("value", oUser.Password.ToString());
txtConfirmPassword.Attributes.Add("value", oUser.Password.ToString());
chkStatus.Checked = oUser.Status;
Util.ChkChangeSetColor(chkStatus);
DDListUtil.Assign(ddlDesignation, oUser.Designation.DesignationID.ToString());
DDListUtil.Assign(ddlUserClass, oUser.Group.GroupID.ToString());
DDListUtil.Assign(ddlDivision, oUser.DivisionID.Trim());
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oUser.UserDetails.MakerID;
userDetails.MakeDate = oUser.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckerID = oUser.UserDetails.CheckerID;
userDetails.CheckDate = oUser.UserDetails.CheckDate;
userDetails.CheckerComment = oUser.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdUserID.Value = oUser.UserID.ToString();
txtLoginUserID.ReadOnly = false;
}
else
{
ClearTextValue();
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
else
{
ClearTextValue();
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true);
}
}
protected void InitializeData()
{
//gvData.PageSize = (int)Constants.PAGING_UNAPPROVED;
if (Session[Constants.SES_CONFIG_UNAPPROVE_DATA] == null)
{
Session.Add(Constants.SES_CONFIG_UNAPPROVE_DATA, new DataTable());
}
else
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
}
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
string sType = Request.QueryString["pType"];
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK).PadLeft(5, '0')) ||
sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK_REMOVE).PadLeft(5, '0')))
{
DDListUtil.LoadActiveUser(ddlUserName, "UserName", "UserName", "SA_User", (int)Constants.USER_GROUP.LIEN_MAKER, false, oConfig.DivisionID);
}
else
{
DDListUtil.LoadActiveUser(ddlUserName, "UserName", "UserName", "SA_User", (int)Constants.USER_GROUP.MAKER, false, oConfig.DivisionID);
}
SearchAction();
}
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);
// 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(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);
}
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 LoadBySPType()
{
SPPolicy oSPPolicy = null;
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = (Result)oSPPolicyDAL.LatestPolicy(ddlSpType.SelectedValue, Constants.ACTIVITY_TYPE.ISSUE, DateTime.Now);
if (oResult.Status)
{
ddlDDDenom.Items.Clear();
oSPPolicy = (SPPolicy)oResult.Return;
DataTable dtDenom = new DataTable();
if (oSPPolicy.SPType.ListOfDenomination.Denomination.Count > 0)
{
dtDenom.Columns.Add(new DataColumn("Text", typeof(string)));
dtDenom.Columns.Add(new DataColumn("Value", typeof(string)));
DataRow rowDenom = null;
for (int i = 0; i < oSPPolicy.SPType.ListOfDenomination.Denomination.Count; i++)
{
rowDenom = dtDenom.NewRow();
rowDenom["Text"] = oSPPolicy.SPType.ListOfDenomination.Denomination[i].DenominationID.ToString();
rowDenom["Value"] = oSPPolicy.SPType.ListOfDenomination.Denomination[i].Series.ToString();
dtDenom.Rows.Add(rowDenom);
}
}
DDListUtil.Assign(ddlDDDenom, dtDenom, true);
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
EnableDisableControls(true);
foreach (ListItem item in chkListForBB.Items)
{
item.Enabled = true;
item.Selected = false;
}
txtTotalFaceValue.Text = "0.00";
if (ddlDuration.Items.Count > 0)
{
ddlDuration.SelectedIndex = 0;
}
if (ddlSpType.Items.Count > 0)
{
ddlSpType.SelectedIndex = 0;
}
txtReferenceNo.Text = "";
DDListUtil.Assign(ddlYear, DateTime.Now.Year);
txtStatementDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtDateFrom.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
ddlDateTo.Items.Clear();
gvData.DataSource = null;
gvData.DataBind();
}
private void MoveAction(string sType)
{
txtLoginUserID.ReadOnly = true;
UserDAL oUserDAL = new UserDAL();
Result oResult = oUserDAL.LoadMoveData(txtLoginUserID.Text, sType);
if (oResult.Status)
{
User oUser = (User)oResult.Return;
if (oUser != null)
{
ClearTextValue();
hdDataType.Value = "M";
txtLoginUserID.Text = oUser.UserName.ToString();
txtUserFirstName.Text = oUser.FirstName.ToString();
txtUserLastName.Text = oUser.LastName.ToString();
txtNewPassword.Attributes.Add("value", oUser.Password.ToString());
txtConfirmPassword.Attributes.Add("value", oUser.Password.ToString());
chkStatus.Checked = oUser.Status;
Util.ChkChangeSetColor(chkStatus);
DDListUtil.Assign(ddlDesignation, oUser.Designation.DesignationID.ToString());
DDListUtil.Assign(ddlUserClass, oUser.Group.GroupID.ToString());
}
ucUserDet.UserDetail = oUser.UserDetails;
hdUserID.Value = oUser.UserID.ToString();
}
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Clear();
gvSearchList.PageSize = (int)Constants.PAGING_SEARCH;
lblPageCaption.Text = PageCaption;
lblCap.Text = Caption;
// Dropdown load SPType
if (Type.Equals("ReportMappingSearch") ||
Type.Equals("BBAddressSearch") ||
Type.Equals("SPWiseAccountMappingSearch") ||
Type.Equals("SPCertificateFormatMappingSearch")) // rest of all
{
// SP type
DDListUtil.LoadDDLFromDB(ddlID, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
}
else if (Type.Equals("CommonAccountMappingSearch") || Type.Equals("CurrencywiseAccountMappingSearch"))
{
// currency 10
DDListUtil.LoadDDLFromDB(ddlID, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
}
}
}
private void ClearData()
{
txtMasterNo.Text = string.Empty;
txtCustomerID.Text = string.Empty;
txtCustomerName.Text = string.Empty;
txtAddress.Text = string.Empty;
txtPermanentAddress.Text = string.Empty;
txtForignAddress.Text = string.Empty;
txtTINNo.Text = string.Empty;
txtPhone.Text = string.Empty;
txtEmail.Text = string.Empty;
ddlSex.SelectedIndex = 0;
txtNationality.Text = "Bangladeshi";
ddlNationalityCountry.SelectedIndex = 0;
ddlResidentCountry.SelectedIndex = 0;
txtDateofBirth.Text = string.Empty;
ddlDateofBirthCountry.SelectedIndex = 0;
txtBirthPlace.Text = string.Empty;
txtPassportNo.Text = string.Empty;
ddlPassportCountry.SelectedIndex = 0;
txtPassportIssueAt.Text = string.Empty;
txtNationalID.Text = string.Empty;
ddlNationalIDCountry.SelectedIndex = 0;
txtNationalIDIssueAt.Text = string.Empty;
txtBirthCertNo.Text = string.Empty;
ddlBirthCertNoCountry.SelectedIndex = 0;
txtBirthCertNoIssueAt.Text = string.Empty;
ddlResidenceStatus.SelectedIndex = 0;
//txtCustomerName2.Text = string.Empty;
//txtAddress2.Text = string.Empty;
//txtForignAddress2.Text = string.Empty;
//txtPhone2.Text = string.Empty;
//txtDateofBirth2.Text = string.Empty;
//ddlSex2.SelectedIndex = 0;
//txtNationality2.Text = "Bangladeshi";
//txtPassportNo2.Text = string.Empty;
//txtIssueAt2.Text = string.Empty;
//txtNationalID2.Text = string.Empty;
//txtBirthCertNo2.Text = string.Empty;
//txtEmail2.Text = string.Empty;
//ddlResidenceStatus2.SelectedIndex = 0;
DDListUtil.Assign(ddlDateofBirthCountry, "BANGLADESH");
DDListUtil.Assign(ddlNationalityCountry, "BANGLADESH");
DDListUtil.Assign(ddlResidentCountry, "BANGLADESH");
DDListUtil.Assign(ddlPassportCountry, "BANGLADESH");
DDListUtil.Assign(ddlNationalIDCountry, "BANGLADESH");
DDListUtil.Assign(ddlBirthCertNoCountry, "BANGLADESH");
hdTmpCustomerID.Value = "";
hdnIsReinvested.Value = "0";
}
private void InitializeData()
{
gvData.PageSize = (int)Constants.PAGING_UNAPPROVED;
TotalClear();
gvData.DataSource = null;
gvData.DataBind();
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromDB(ddlBranch, "BranchID", "BranchName", "SPMS_Branch", true);
txtCDUpTo.Text = "1";//Default value
string sRegNo = Request.QueryString[OBJ_REG_NO];
string sPageID = Request.QueryString[OBJ_PAGE_ID];
if (!string.IsNullOrEmpty(sRegNo))
{
sRegNo = oCrypManager.GetDecryptedString(sRegNo, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sPageID))
{
sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sRegNo) && !string.IsNullOrEmpty(sPageID))
{
string sOperationType = sPageID.Substring(4, 1);
if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType))
{
SEARCH_FROM = 3;
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
LoadDataByRegNo("", sRegNo, "1");//Loaded from Temp Table
#region User-Detail.
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.CheckerID = oConfig.UserName;
oUserDetails.CheckDate = DateTime.Now;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = false;
}
}
else
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
UserDetails oUserDetails = new UserDetails();
oUserDetails.MakerID = oConfig.UserName;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
fsList.Visible = true;
LoadPreviousList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DDListUtil.LoadDDLFromDB(ddlSearchSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
gvSearchList.PageSize = (int)Constants.PAGING_SEARCH;
Clear();
}
}
protected void InitializeData()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
DDListUtil.LoadActiveUser(ddlUserName, "UserName", "UserName", "SA_User", (int)Constants.USER_GROUP.MAKER, false, oConfig.DivisionID);
DDListUtil.LoadDDLFromDB(ddlJournalType, "JournalType", "Description", "SPMS_JournalType", false);
RBLChangeColor(rblCurrencyActivity);
lblActivity.Text = rblCurrencyActivity.Items[0].Value;
}
private void InitializeData()
{
gvData.DataSource = null;
gvData.DataBind();
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
private void InitializeData()
{
DDListUtil.LoadDDLFromDB(ddlSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
gvSearchList.PageSize = (int)Constants.PAGE_SIZE_CLAIM;
Clear();
lblPageCaption.Text = this.PageCaption;
chkLastStatement.Attributes.Add("onclick", "CheckLastStatement(this)");
chkStatemenDt.Attributes.Add("onclick", "StatementDate(this)");
}
private void Initialization()
{
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
//txtDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
DDListUtil.LoadDDLFromXML(ddlAccountNo, "JournalAccount", "Type", "JournalAccount", false);
//DDListUtil.LoadDDLFromXML(ddlJournalStatus, "JournalStatus", "Type", "JournalStatus", false);
lblAccName.Text = "Softcell Solution Ltd ";
this.RBLChangeColor(rdlType);
this.ChkChangeColor(chkAscending);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromDB(ddlCustType, "CustomerTypeID", "TypeDesc", "SPMS_CustomerType", true);
gvSearchList.PageSize = (int)Constants.PAGING_SEARCH;
gvSearchList.DataSource = null;
gvSearchList.DataBind();
}
private void LoadToDateData()
{
/*
* If Me.ActiveControl.Name = "cboDuration" Then Exit Function
* If Me.ActiveControl.Name = "btnSearchRefNo" Then Exit Function
* If Me.cboToDate.SelectedIndex > 0 Then
* Me.FillReferenceDetailGrid()
* Me.cboCurrencyID.Enabled = True
* Me.cboCurrencyID.SelectedValue = Me.cStrSPCurrency
* Me.LoadCurrencyData()
* Else
* Me.cDtSalesStatementData = Nothing
* dgrSalesReferenceDetails.DataSource = Nothing
* dgrSalesReferenceDetails.Refresh()
* dgrRegistrationDetails.DataSource = Nothing
* dgrRegistrationDetails.Refresh()
* Me.txtTotalOrgCommission.Text = "0.00"
* Me.txtTotalNonOrgCommission.Text = "0.00"
* Me.txtConvTotalOrgCommission.Text = "0.00"
* Me.txtConvTotalNonOrgCommission.Text = "0.00"
* If Not IsNothing(Me.cboCurrencyID.DataSource) Then
* Me.cboCurrencyID.SelectedIndex = 0
* End If
* Me.cboCurrencyID.Enabled = False
* Me.txtConversionRate.Text = "0.0000"
* End If
*/
if (ddlDateTo.SelectedIndex > 0)
{
FillReferenceDetailGrid("");
ddlConversionCurrency.Enabled = true;
string sSPCurrency = ViewState[_SPTYPE_CUREENCY] as string;
if (!string.IsNullOrEmpty(sSPCurrency))
{
DDListUtil.Assign(ddlConversionCurrency, sSPCurrency);
}
LoadCurrencyData();
}
else
{
gvData.DataSource = null;
gvData.DataBind();
txtTotalFaceValue.Text = "0.00";
txtTotalNonOrgCommission1.Text = "0.00";
txtTotalNonOrgCommission2.Text = "0.00";
txtTotalOrgCommission1.Text = "0.00";
txtTotalOrgCommission2.Text = "0.00";
if (ddlConversionCurrency.Items.Count > 0)
{
ddlConversionCurrency.SelectedIndex = 0;
}
ddlConversionCurrency.Enabled = false;
txtConversionRate.Text = "0.0000";
}
}
private void LoadCurrencyBySPType(string sSPTypeID)
{
ddlReconCurrency.Items.Clear();
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = oSPPolicyDAL.GetCurrencyList(sSPTypeID, Constants.ACTIVITY_TYPE.INTEREST_REIMBURSE, DateTime.Now);
if (oResult.Status)
{
DDListUtil.Assign(ddlReconCurrency, (DataTable)oResult.Return, true);
}
}
private void InitializeData()
{
hdRegNo.Value = "";
// Dropdown load SPType
string sRegNo = Request.QueryString[OBJ_REG_NO];
string sPageID = Request.QueryString[OBJ_PAGE_ID];
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromDB(ddlBranch, "BranchID", "BranchName", "SPMS_Branch", true);
// end of Intial Data
// Issue Details
txtIssueDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
gvDenomDetail.DataSource = null;
gvDenomDetail.DataBind();
if (!string.IsNullOrEmpty(sRegNo) && !string.IsNullOrEmpty(sPageID))
{
sRegNo = oCrypManager.GetDecryptedString(sRegNo, Constants.CRYPT_PASSWORD_STRING);
sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING);
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
LoadDataByID(sRegNo, "Approve");//query from Temp Table
#region User-Detail.
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.CheckerID = oConfig.UserName;
oUserDetails.CheckDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = false;
#region Enable-disable controls
EnableDisableControl(false);
#endregion Enable-disable controls
}
else
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
UserDetails oUserDetails = new UserDetails();
oUserDetails.MakerID = oConfig.UserName;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
EnableDisableControl(true);
fsList.Visible = true;
LoadPreviousList();
}
}
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 LoadCustomerTypeBySpType(string sSPType)
{
CustomerTypeWiseSPLimitDAL oCustTypeWiseSPLimit = new CustomerTypeWiseSPLimitDAL();
Result oResult = (Result)oCustTypeWiseSPLimit.GetCustomerTypeBySpType(sSPType);
if (oResult.Status)
{
ddlCustomerType.Items.Clear();
DataTable dtGetCustomerTypeID = (DataTable)oResult.Return;
DDListUtil.Assign(ddlCustomerType, dtGetCustomerTypeID);
}
}
