protected void btnIssue_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("ckbSelBook");
if (cb.Checked)
{
IssueDAL issueDAL = new IssueDAL();
BookDAL bookDAL = new BookDAL();
//Calculate issued copy and retrieve number of copies
int bookID = Convert.ToInt16(row.Cells[1].Text);
int issuedCopies = issueDAL.CountCopies(bookID);
int NumberOfCopies = bookDAL.GetNumberOfCopies(bookID);
if (issuedCopies < NumberOfCopies)
{
issueDAL.IssueBook(Convert.ToInt16(Session["UserID"]), Convert.ToInt16(row.Cells[1].Text)); //@TODO add userID
lblStatus.Text = "Book has been Issued Successfully";
}
else
{
lblStatus.Text = "The Book is not available at the moment";
}
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = null;
if (rdolApproval.Items[0].Selected)
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(txtIssueDate.Text), txtScripNo.Text, "", rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(txtIssueDate.Text), txtScripNo.Text, Util.GetCheckListIDList(chklIssueStatus), rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_SIssue_lblProgress') ", true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList.Rows.Count > 0)
{
gvSearchList.DataSource = dtTmpList;
gvSearchList.DataBind();
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpList;
}
else
{
gvSearchList.DataSource = null;
gvSearchList.DataBind();
}
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
ACERegister oACERegister = new ACERegister();
oACERegister.RegNo = txtRegistrationNo.Text.Trim();
IssueDAL oIssueDAL = new IssueDAL();
oACERegister.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oIssueDAL.ApproveACERegister(oACERegister);
if (oResult.Status)
{
if (oResult.Message.Equals("E"))
{
ucMessage.OpenMessage("Required Script is not available now", Constants.MSG_TYPE_ERROR);
}
else
{
//TotalClear();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE + " with Reg. No.: <b>" + (string)oResult.Return + "</b>", Constants.MSG_TYPE_SUCCESS);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
private void LoadUnapprovedList()
{
IssueDAL oIssueDAL = new IssueDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = oIssueDAL.LoadTmpIssueUpdateDataTableList(oConfig.UserName, false, oConfig.DivisionID, oConfig.BankCodeID);
gvData.DataSource = null;
gvData.DataBind();
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("Maker ID");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
}
}
protected void btnRightShift_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdRegNo.Value))
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Issue oIssue = new Issue();
oIssue.RegNo = hdRegNo.Value;
oIssue.DivisionID = oConfig.DivisionID;
oIssue.BankID = oConfig.BankCodeID;
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadViewDataID(oIssue, "R");
if (oResult.Status)
{
oIssue = (Issue)oResult.Return;
SetObject(oIssue);
}
else
{
hdRegNo.Value = "";
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage("You must load Issue first before viewing Issue Detail!", Constants.MSG_TYPE_INFO);
}
}
public void LoadDataByID(string sRegNo, string flag)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Issue oIssue = new Issue();
oIssue.RegNo = sRegNo.Trim();
oIssue.DivisionID = oConfig.DivisionID;
oIssue.BankID = oConfig.BankCodeID;
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadViewDataID(oIssue, null);
if (oResult.Status)
{
oIssue = (Issue)oResult.Return;
if (string.IsNullOrEmpty(oIssue.IssueTransNo))
{
TotalClear();
ucMessage.OpenMessage("Invalid Registration No, No record found. Please Check.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
else
{
SetObject(oIssue, flag);
}
}
else
{
hdRegNo.Value = "";
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdRegNo.Value))
{
if (hdDataType.Value.Equals("1"))
{
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = (Result)oIssueDAL.DeteteACERegister(hdRegNo.Value);
if (oResult.Status)
{
TotalClear();
LoadPreviousList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage("No unapproved data found to delete!!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
else
{
ucMessage.OpenMessage("Data has not been loaded!!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
//protected void btnEncashCertificate_Click(object sender, EventArgs e)
//{
// ReportDAL rdal = new ReportDAL();
// Result oResult = new Result();
// Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
// if (!string.IsNullOrEmpty(txtRegistrationNo.Text))
// {
// if (oConfig != null)
// {
// oResult = rdal.EncashmentCertificate(txtRegistrationNo.Text, txtIssueName.Text, oConfig.BranchID);
// //Page.RegisterStartupScript(Constants.REPORT_WINDOW, "<script> alert('opended')</script>");
// if (oResult.Status)
// {
// Session[Constants.SES_RPT_DATA] = oResult.Return;
// Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
// }
// }
// }
// else
// {
// ucMessage.OpenMessage("Enter a valid reg no. Please check!", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// }
//}
//protected void btnPaymentCertificate_Click(object sender, EventArgs e)
//{
// ReportDAL rdal = new ReportDAL();
// Result oResult = new Result();
// Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
// if (!string.IsNullOrEmpty(txtRegistrationNo.Text))
// {
// if (oConfig != null)
// {
// oResult = rdal.PaymentCertificate(txtRegistrationNo.Text, txtIssueName.Text, oConfig.BranchID,ddlTaxYear.SelectedValue.ToString());
// //Page.RegisterStartupScript(Constants.REPORT_WINDOW, "<script> alert('opended')</script>");
// if (oResult.Status)
// {
// Session[Constants.SES_RPT_DATA] = oResult.Return;
// Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
// }
// }
// }
// else
// {
// ucMessage.OpenMessage("Enter a valid reg no. Please check!", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// }
//}
protected void btnIssueDocument_Click(object sender, EventArgs e)
{
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadIssueDocument_PDF(txtRegistrationNo.Text.Trim());
if (oResult.Status)
{
if (((DataTable)oResult.Return).Rows.Count > 0)
{
Session[Constants.SES_PDF_DATA] = (byte[])(((DataTable)oResult.Return).Rows[0]["IssuePDFFile"]);
Page.RegisterStartupScript(Constants.PDF_WINDOW, Util.OpenPDFView());
//byte[] oRepDoc = null;
//oRepDoc = (byte[])(((DataTable)oResult.Return).Rows[0]["IssuePDFFile"]);
//Response.Buffer = true;
//Response.Charset = "";
////if (Request.QueryString["download"] == "1")
////{
//Response.AppendHeader("Content-Disposition", "attachment; filename=IssueDocument_" + DateTime.Today.ToString("yyyyMMdd"));
////}
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
//Response.ContentType = "application/pdf";
//Response.BinaryWrite(oRepDoc);
//Response.Flush();
//Response.End();
}
}
}
protected void SearchAction()
{
gvData.DataSource = null;
gvData.DataBind();
Session[Constants.SES_DOCUMENT_INQUERY_DATA] = new DataTable();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
lgText.InnerHtml = "SP Issue Tracker Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
string dtFromDate = Util.GetDateTimeByString(txtFromDate.Text).ToString("dd-MMM-yyyy");
string dtToDate = Util.GetDateTimeByString(txtToDate.Text).ToString("dd-MMM-yyyy");
Result oResult = oIssueDAL.LoadBBDocumentList(txtLetterRefNo.Text, ddlLetterType.SelectedValue, dtFromDate, dtToDate);
DataTable dtTmpGetData = (DataTable)oResult.Return;
if (dtTmpGetData != null)
{
gvData.DataSource = dtTmpGetData;
gvData.DataBind();
Session[Constants.SES_DOCUMENT_INQUERY_DATA] = dtTmpGetData;
}
else
{
dtTmpGetData = new DataTable();
gvData.DataSource = dtTmpGetData;
gvData.DataBind();
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdRegNo.Value))
{
ACERegister oACERegister = new ACERegister();
oACERegister.RegNo = hdRegNo.Value;
oACERegister.UserDetails = ucUserDet.UserDetail;
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = (Result)oIssueDAL.RejectACERegister(oACERegister);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_REJECT, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_INFO);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtRegNo.Text))
{
if (ddlTransType.SelectedIndex > 0)
{
DataTable dt = null;
Result oResult = null;
AuthorizedDeleteDAL ad = new AuthorizedDeleteDAL();
if (ddlTransType.SelectedValue == "I")
{
oResult = ad.LoadTransactionDetails(SBM_BLV1.baseCommon.enmTransType.Issue, txtRegNo.Text);
}
else if (ddlTransType.SelectedValue == "C")
{
oResult = ad.LoadTransactionDetails(SBM_BLV1.baseCommon.enmTransType.Interest_Payment, txtRegNo.Text);
}
else if (ddlTransType.SelectedValue == "E")
{
oResult = ad.LoadTransactionDetails(SBM_BLV1.baseCommon.enmTransType.Encashment, txtRegNo.Text);
}
else
{
IssueDAL oIssueDAL = new IssueDAL();
oResult = oIssueDAL.LoadBBDocumentList_AD(txtRegNo.Text, ddlTransType.Text);
}
if (oResult.Status)
{
gvTransactionList.DataSource = oResult.Return;
gvTransactionList.DataBind();
}
else
{
DataTable dt1 = new DataTable();
gvTransactionList.DataSource = dt1;
gvTransactionList.DataBind();
}
}
else
{
DataTable dt2 = new DataTable();
gvTransactionList.DataSource = dt2;
gvTransactionList.DataBind();
}
}
else
{
DataTable dt3 = new DataTable();
gvTransactionList.DataSource = dt3;
gvTransactionList.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Issue oIssue = (Issue)Session[Constants.SES_CURRENT_ISSUE];
if (oIssue != null)
{
if (!string.IsNullOrEmpty(txtNewIssueName.Text))
{
oIssue.IssueName = txtNewIssueName.Text.ToUpper();
}
else
{
oIssue.IssueName = txtOldIssueName.Text.ToUpper();
}
if (!string.IsNullOrEmpty(txtNewIssueDate.Text))
{
oIssue.VersionIssueDate = Util.GetDateTimeByString(txtNewIssueDate.Text);
}
oIssue.IssueUpdateRemarks = txtRemarks.Text.ToUpper();
string sDtForPolicy = txtNewIssueDate.Text;
if (string.IsNullOrEmpty(sDtForPolicy))
{
sDtForPolicy = txtOldIssueDate.Text;
}
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult1 = (Result)oSPPolicyDAL.LatestPolicy(oIssue.SPType.SPTypeID, Constants.ACTIVITY_TYPE.ISSUE, Util.GetDateTimeByString(sDtForPolicy));
if (oResult1.Status)
{
oIssue.VersionSPPolicy = oResult1.Return as SPPolicy;
}
oIssue.UserDetails = ucUserDet.UserDetail;
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = (Result)oIssueDAL.SaveIssueUpdate(oIssue);
if (oResult.Status)
{
TotalClear();
LoadUnapprovedList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage("Problem in Data. Please check", Constants.MSG_TYPE_ERROR);
}
}
protected void btnReturn_Click1(object sender, EventArgs e)
{
lblStatus.Text = "";
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("ckbSelBook");
if (cb.Checked)
{
IssueDAL issueDAL = new IssueDAL();
//update database when issued book is returned.
issueDAL.UpdateBook(Convert.ToInt16(row.Cells[1].Text));
lblStatus.Text = "Returned Successfully";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdRegNo.Value))
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
ACERegister oACERegister = new ACERegister();
IssueDAL oIssueDAL = new IssueDAL();
oACERegister.RegNo = hdRegNo.Value;
oACERegister.AccountNo = txtPDAccDraftNo.Text.Trim();
oACERegister.Status = ddlStatus.SelectedValue;
oACERegister.StatusDate = DateTime.Today;
oACERegister.InventoryLocation = txtInvLocation.Text;
oACERegister.Remarks = txtRemarks.Text.ToUpper();
oACERegister.BankID = oConfig.BankCodeID;
oACERegister.DivisionID = oConfig.DivisionID;
//User Details
oACERegister.UserDetails = ucUserDet.UserDetail;
oACERegister.UserDetails.MakeDate = DateTime.Now;
//Response.Redirect(Consants.PAGE_TRAN_ISSUE_UPDATE + "?sIsUpdate=" + oCrypManager.GetEncryptedString("1") + "&sRegID=" + oCrypManager.GetEncryptedString(txtRegistrationNo.Text) + "&sPageID=" + oCrypManager.GetEncryptedString(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_UPDATE).PadLeft(5, '0')), false);
Result oResult = (Result)oIssueDAL.SaveACERegister(oACERegister);
if (oResult.Status)
{
TotalClear();
LoadPreviousList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage("You must load Issue first before updating Issue Detail!", Constants.MSG_TYPE_INFO);
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
Issue oIssue = (Issue)Session[Constants.SES_CURRENT_ISSUE];
IssueDAL oIssueDAL = new IssueDAL();
oIssue.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oIssueDAL.ApproveIssueUpdate(oIssue);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!e.CommandName.Equals("Page"))
{
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
//#region Issue
//else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE).PadLeft(5, '0')))
//{
//Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
//if (oConfig.GroupID != "1" && oConfig.GroupID != "12")
//{
// if (gvRow.Cells[8].Text.Contains("MANAGER"))
// {
// ucMessage.OpenMessage("This registration required Manager Approval. Please check.", Constants.MSG_TYPE_ERROR);
// ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// return;
// }
//}
// Response.Redirect(Constants.PAGE_TRAN_ISSUE + "?sTransID=" + oCrypManager.GetEncryptedString(gvRow.Cells[1].Text) + "&sPageID=" + oCrypManager.GetEncryptedString(sType), false);
//}
//else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_UPDATE).PadLeft(5, '0')))
//{
// Response.Redirect(Constants.PAGE_TRAN_ISSUE_UPDATE + "?sIsUpdate=" + oCrypManager.GetEncryptedString("0") + "&sRegID=" + oCrypManager.GetEncryptedString(gvRow.Cells[2].Text) + "&sPageID=" + oCrypManager.GetEncryptedString(sType), false);
//}
//else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_OLD).PadLeft(5, '0')))
//{
// Response.Redirect(Constants.PAGE_TRAN_ISSUE_OLD_CUSTOMER + "?sRegID=" + oCrypManager.GetEncryptedString(gvRow.Cells[1].Text) + "&sPageID=" + oCrypManager.GetEncryptedString(sType), false);
//}
//#endregion Issue
if (gvRow.Cells[1].Text != "")
{
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadBBDocument_PDF(gvRow.Cells[1].Text);
if (oResult.Status)
{
if (((DataTable)oResult.Return).Rows.Count > 0)
{
Session[Constants.SES_PDF_DATA] = (byte[])(((DataTable)oResult.Return).Rows[0]["LetterImage"]);
Page.RegisterStartupScript(Constants.PDF_WINDOW, Util.OpenPDFView());
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblStatus.Text = "";
MemberDAL memberDAL = new MemberDAL();
IssueDAL issueDAL = new IssueDAL();
if (Session["Name"] != null)
{
//Retrieve User ID from DB by User name from session
int userID = memberDAL.GetUserIDByName(Session["Name"].ToString());
List <Issue> issuedBooks = issueDAL.ReadByUserID(userID);
GridView1.DataSource = issuedBooks;
GridView1.DataBind();
}
}
}
public void LoadDataByID(string sRegNo)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Issue oIssue = new Issue();
oIssue.RegNo = sRegNo.Trim();
oIssue.DivisionID = oConfig.DivisionID;
oIssue.BankID = oConfig.BankCodeID;
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadViewDataID(oIssue, null);
if (oResult.Status)
{
oIssue = (Issue)oResult.Return;
SetObject(oIssue);
}
else
{
hdRegNo.Value = "";
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdUpdateIssueTransNo.Value))
{
Issue oIssue = new Issue(hdIssueTransNo.Value);
IssueDAL oIssueDAL = new IssueDAL();
oIssue.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oIssueDAL.RejectIssueUpdate(oIssue);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_REJECT, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_INFO);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Result oResult = null;
string sTransNo = TransactionNo();
AuthorizedDeleteDAL ad = new AuthorizedDeleteDAL();
if (ddlTransType.SelectedValue == "I")
{
oResult = ad.DeleteTransaction(SBM_BLV1.baseCommon.enmTransType.Issue, sTransNo);
}
else if (ddlTransType.SelectedValue == "C")
{
oResult = ad.DeleteTransaction(SBM_BLV1.baseCommon.enmTransType.Interest_Payment, sTransNo);
}
else if (ddlTransType.SelectedValue == "E")
{
oResult = ad.DeleteTransaction(SBM_BLV1.baseCommon.enmTransType.Encashment, sTransNo);
}
else
{
IssueDAL oIssueDAL = new IssueDAL();
string sDeleteKey = gvTransactionList.Rows[0].Cells[0].Text;
oResult = oIssueDAL.DeleteBBDocumentList_AD(sDeleteKey, ddlTransType.Text);
}
if (oResult.Status)
{
//UpdatePanel3
btnSearch_Click(sender, e);
ucMessage.OpenMessage("Authorized Deleted Successfully Executed.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
else
{
ucMessage.OpenMessage("Error: " + oResult.Message, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (txtNewIssueDate.Enabled)
{
if (!string.IsNullOrEmpty(hdUpdateIssueTransNo.Value))
{
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = (Result)oIssueDAL.DeteteIssueUpdate(hdIssueTransNo.Value, hdUpdateIssueTransNo.Value);
if (oResult.Status)
{
TotalClear();
LoadUnapprovedList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
}
else
{
if (oResult.Message.Equals(Constants.TABLE_MAIN))
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_INFO);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Issue oIssue = new Issue();
IssueDAL oIssueDAL = new IssueDAL();
gvSearchList.DataSource = null;
gvSearchList.DataBind();
Result oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(txtFromDate.Text), txtTransNo.Text, null, rblStatus.SelectedItem.Value, Type, Util.GetDateTimeByString(txtToDate.Text).ToString(), null, null, oConfig.DivisionID, oConfig.BankCodeID);
ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_SearchIPE_lblProgress') ", true);
if (oResult.Status)
{
DataTable dtSPDataList = (DataTable)oResult.Return;
if (dtSPDataList.Rows.Count > 0)
{
gvSearchList.DataSource = dtSPDataList;
gvSearchList.DataBind();
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtSPDataList;
}
}
}
protected void btnPrintCertificate_Click(object sender, EventArgs e)
{
ReportDAL rdal = new ReportDAL();
Result oResult = new Result();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (!string.IsNullOrEmpty(txtRegistrationNo.Text))
{
string sCertType = "";
if (ddlCertificateType.SelectedIndex < 1)
{
ddlCertificateType.SelectedIndex = 0;
ucMessage.OpenMessage("Enter a valid certicate type. Please check!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return;
}
if (oConfig != null)
{
if (ddlCertificateType.SelectedValue == "1")
{
sCertType = "Issuance";
oResult = rdal.InvestmentCertificate(txtRegistrationNo.Text, txtIssueName.Text, txtDuplicate.Text, oConfig.BranchID);
//Page.RegisterStartupScript(Constants.REPORT_WINDOW, "<script> alert('opended')</script>");
}
else if (ddlCertificateType.SelectedValue == "2")
{
sCertType = "Encashment";
//Encashment
oResult = rdal.EncashmentCertificate(txtRegistrationNo.Text, txtIssueName.Text, oConfig.BranchID, txtDuplicate.Text);
}
else if (ddlCertificateType.SelectedValue == "3")
{
sCertType = "Interest";
//Payment & TAX Certificate
oResult = rdal.PaymentCertificate(txtRegistrationNo.Text, txtIssueName.Text, oConfig.BranchID, ddlTaxYear.SelectedValue.ToString(), txtDuplicate.Text);
}
if (oResult.Status)
{
IssueDAL oIssueDAL = new IssueDAL();
oIssueDAL.Save_CertificatePrintLog(hdIssueTransNo.Value, sCertType,
(Int32.Parse(txtNoofCertPrint.Text) + 1).ToString("N0"), ddlCertCustomerType.SelectedValue.ToString(), txtChargeAmount.Text,
Convert.ToInt32(ddlWaiveCharges.SelectedValue), txtChargeAmount.Text,
txtVATAmount.Text, oConfig.UserName);
ddlCertificateType_SelectedIndexChanged(sender, e);
Session[Constants.SES_RPT_DATA] = oResult.Return;
Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
}
else
{
ucMessage.OpenMessage("No " + sCertType + " data found for certificate generation. Please check!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
}
else
{
ucMessage.OpenMessage("Enter a valid reg no. Please check!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
IssueDAL oIssueDAL = new IssueDAL();
gvSearchList.DataSource = null;
gvSearchList.DataBind();
Result oResult = new Result();
if (hdPageType.Value == "1.1")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "2.1")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "2.2")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, "14", null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, "14", null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "3.1")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "3.2")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, "14", "D", null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, "14", null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "4.2")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
else if (hdPageType.Value == "5.2")
{
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(""), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
else
{
oResult = oIssueDAL.SearchList(txtRegNo.Text, ddlSPType.SelectedValue, Util.GetDateTimeByString(Request[txtIssueDate.UniqueID]), null, null, rdolApproval.SelectedItem.Value, Type, null, null, null, oConfig.DivisionID, oConfig.BankCodeID);
}
}
if (hdCheckDate.Value.Equals("false") || hdCheckDate.Value.Equals(""))
{
txtIssueDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_StopPay_lblProgress') ", true);
if (oResult.Status)
{
DataTable dtIssueList = (DataTable)oResult.Return;
if (dtIssueList.Rows.Count > 0)
{
gvSearchList.DataSource = dtIssueList;
gvSearchList.DataBind();
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtIssueList;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtSearchValue.Text))
{
if (ddlTransType.SelectedIndex > 0)
{
Result oResult = null;
IssueDAL ad = new IssueDAL();
if (ddlTransType.SelectedValue != "S")
{
//if (ddlTransType.SelectedValue.ToString().Contains("OI") && txtSearchValue.Text.Length<12)
//{
// ucMessage.OpenMessage("Invalid OWS_ISS_REFID, Serach Test is small to execute. Please Check.", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel8, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// return;
//}
//else if (ddlTransType.SelectedValue.ToString().Contains("OC") && txtSearchValue.Text.Length < 12)
//{
// ucMessage.OpenMessage("Invalid OWS_ISS_REFID, Serach Test is small to execute. Please Check.", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel8, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// return;
//}
//else if (ddlTransType.SelectedValue.ToString().Contains("ON") && txtSearchValue.Text.Length < 12)
//{
// ucMessage.OpenMessage("Invalid OWS_ISS_REFID, Serach Test is small to execute. Please Check.", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel8, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// return;
//}
//else if (ddlTransType.SelectedValue.ToString().Contains("CN") && txtSearchValue.Text.Length < 12)
//{
// ucMessage.OpenMessage("Invalid OWS_ISS_REFID, Serach Test is small to execute. Please Check.", Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel8, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
// return;
//}
oResult = ad.Load_CustomerPortfolio_List(ddlTransType.SelectedValue.ToString(), txtSearchValue.Text, ddlIssueStatus.SelectedValue.ToString());
}
if (oResult.Status)
{
gvTransactionList.DataSource = oResult.Return;
gvTransactionList.DataBind();
}
else
{
DataTable dt1 = new DataTable();
gvTransactionList.DataSource = dt1;
gvTransactionList.DataBind();
}
}
else
{
DataTable dt2 = new DataTable();
gvTransactionList.DataSource = dt2;
gvTransactionList.DataBind();
}
}
else
{
DataTable dt3 = new DataTable();
gvTransactionList.DataSource = dt3;
gvTransactionList.DataBind();
}
}
protected void ddlCertificateType_SelectedIndexChanged(object sender, EventArgs e)
{
if (hdIssueTransNo.Value == "")
{
ddlCertificateType.SelectedIndex = 0;
ucMessage.OpenMessage("Enter a valid reg no. Please check!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return;
}
string sCertType = "";
if (ddlCertificateType.SelectedIndex > 0)
{
if (ddlCertificateType.SelectedValue == "1")
{
sCertType = "Issuance";
}
else if (ddlCertificateType.SelectedValue == "2")
{
sCertType = "Encashment";
}
else if (ddlCertificateType.SelectedValue == "3")
{
sCertType = "Interest";
}
else
{
ddlCertificateType.SelectedIndex = 0;
ucMessage.OpenMessage("Enter a valid certicate type. Please check!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return;
}
}
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.Load_CertificatePrintLog(hdIssueTransNo.Value, sCertType, ddlCertCustomerType.SelectedValue.ToString());
if (oResult.Status)
{
DataTable dtCertPrintLog = (DataTable)oResult.Return;
if (dtCertPrintLog.Rows.Count > 0)
{
if (dtCertPrintLog.Rows[0]["PrintDate"] != DBNull.Value)
{
txtLastCertDate.Text = Convert.ToDateTime(dtCertPrintLog.Rows[0]["PrintDate"]).ToString("dd/MM/yyyy");
}
else
{
txtLastCertDate.Text = "";
}
txtNoofCertPrint.Text = Convert.ToInt32(dtCertPrintLog.Rows[0]["CertIssueNo"]).ToString("N0");
if (Convert.ToInt32(dtCertPrintLog.Rows[0]["CertIssueNo"]) > 0)
{
txtDuplicate.Text = "DUPLICATE";
}
else
{
txtDuplicate.Text = "";
}
txtLastMaker.Text = Convert.ToString(dtCertPrintLog.Rows[0]["MakerID"]);
ddlWaiveCharges.SelectedIndex = 0;
txtChargeAmount.Text = Convert.ToDouble(dtCertPrintLog.Rows[0]["ChargeAmount"]).ToString("N2");
hdChargeAmount.Value = txtChargeAmount.Text;
txtVATAmount.Text = (Convert.ToDouble(dtCertPrintLog.Rows[0]["ChargeAmount"]) * (Convert.ToDouble(dtCertPrintLog.Rows[0]["VATRate"]) / 100)).ToString("N2");;
txtTotalAmount.Text = (Convert.ToDouble(txtChargeAmount.Text) + Convert.ToDouble(txtVATAmount.Text)).ToString("N2");
}
else
{
txtLastCertDate.Text = "";
txtNoofCertPrint.Text = "0";
txtLastMaker.Text = "";
txtDuplicate.Text = "";
ddlCertificateType.SelectedValue = "0";
ddlCertCustomerType.SelectedValue = "REGULAR";
ddlWaiveCharges.SelectedIndex = 0;
txtChargeAmount.Text = "0.00";
hdChargeAmount.Value = txtChargeAmount.Text;
txtVATAmount.Text = "0.00";
txtTotalAmount.Text = (Convert.ToDouble(txtChargeAmount.Text) + Convert.ToDouble(txtVATAmount.Text)).ToString("N2");
}
}
}
public void LoadDataByRegNo(string sIssueUpdateTrnsNo, string sRegNo, string sApprovalStaus)
{
TotalClear();
Issue oIssue = new Issue();
oIssue.RegNo = sRegNo != "" ? sRegNo : txtRegistrationNo.Text.Trim();
oIssue.UpdateIssueTransNo = sIssueUpdateTrnsNo;
if (sApprovalStaus.Equals("2"))
{
oIssue.IsApproved = 2;
}
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
oIssue.BankID = oConfig.BankCodeID;
oIssue.DivisionID = oConfig.DivisionID;
}
IssueDAL oIssueDAL = new IssueDAL();
Result oResult = oIssueDAL.LoadDataByRegNo(oIssue);
oIssue = (Issue)oResult.Return;
//Store Issue object to Session
Session[Constants.SES_CURRENT_ISSUE] = oIssue;
if (oResult.Status)
{
#region Issue Detail
LoadBySPType(oIssue);
hdUpdateIssueTransNo.Value = oIssue.UpdateIssueTransNo;
hdIssueTransNo.Value = oIssue.IssueTransNo;
//Issue Details
DDListUtil.Assign(ddlSpType, oIssue.SPType.SPTypeID);
DDListUtil.Assign(ddlCustomerType, oIssue.CustomerType.CustomerTypeID);
DDListUtil.Assign(ddlBranch, oIssue.Branch.BranchID);
DDListUtil.Assign(ddlYear, oIssue.UserDetails.CheckDate.Year);
txtTransNo.Text = oIssue.UpdateIssueTransNo;
if (oIssue.ChangeDate.Year <= 1900)
{
txtChangeDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
else
{
txtChangeDate.Text = oIssue.ChangeDate.ToString(Constants.DATETIME_FORMAT);
}
txtTotalAmount.Text = oIssue.IssueAmount.ToString();
txtIssueDate.Text = oIssue.OldVersionIssueDate.ToString(Constants.DATETIME_FORMAT);
txtRegistrationNo.Text = oIssue.RegNo;
#endregion
#region Change Details
txtRemarks.Text = oIssue.IssueUpdateRemarks;
if (oIssue.UpdateNewIssueDate.Year <= 1900)
{
txtNewIssueDate.Text = string.Empty;
}
else
{
txtNewIssueDate.Text = oIssue.UpdateNewIssueDate.ToString(Constants.DATETIME_FORMAT);
}
txtNewIssueName.Text = oIssue.IssueName;
txtOldIssueName.Text = oIssue.OldIssueName;
txtOldIssueDate.Text = oIssue.OldVersionIssueDate.ToString(Constants.DATETIME_FORMAT);
#endregion
#region Customer Details
gvCustomerDetail.DataSource = null;
gvCustomerDetail.DataBind();
if (oIssue.CustomerDetailsList.Count > 0)
{
DataTable dtCustomerDetail = new DataTable("dtCustomerDetail");
dtCustomerDetail.Columns.Add(new DataColumn("bfCustomerID", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfCustomerName", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfDateOfBirth", typeof(DateTime)));
dtCustomerDetail.Columns.Add(new DataColumn("bfAddress", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfPhone", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfDateOfBirth2", typeof(DateTime)));
dtCustomerDetail.Columns.Add(new DataColumn("bfNationality", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfPassportNo", typeof(string)));
dtCustomerDetail.Columns.Add(new DataColumn("bfForeignAddress", typeof(string)));
DataRow rowCD = null;
for (int i = 0; i < oIssue.CustomerDetailsList.Count; i++)
{
rowCD = dtCustomerDetail.NewRow();
rowCD["bfCustomerID"] = oIssue.CustomerDetailsList[i].CustomerID.ToString();
rowCD["bfCustomerName"] = oIssue.CustomerDetailsList[i].CustomerName.ToString();
if (oIssue.CustomerDetailsList[i].DateOfBirth.Year > 1900)
{
rowCD["bfDateOfBirth"] = oIssue.CustomerDetailsList[i].DateOfBirth;
}
rowCD["bfAddress"] = oIssue.CustomerDetailsList[i].Address.ToString();
rowCD["bfPhone"] = oIssue.CustomerDetailsList[i].Phone.ToString();
//if (oIssue.CustomerDetailsList[i].DateOfBirth2.Year > 1900)
//{
// rowCD["bfDateOfBirth2"] = oIssue.CustomerDetailsList[i].DateOfBirth2;
//}
rowCD["bfNationality"] = oIssue.CustomerDetailsList[i].Nationality.ToString();
rowCD["bfPassportNo"] = oIssue.CustomerDetailsList[i].PassportNo.ToString();
rowCD["bfForeignAddress"] = oIssue.CustomerDetailsList[i].ForeignAddress.ToString();
dtCustomerDetail.Rows.Add(rowCD);
}
gvCustomerDetail.DataSource = dtCustomerDetail;
gvCustomerDetail.DataBind();
}
#endregion
#region Nominee Details
gvNomDetail.DataSource = null;
gvNomDetail.DataBind();
if (oIssue.NomineeList.Count > 0 || oIssue.OldNomineeList.Count > 0)
{
DataTable dtNominee = new DataTable();
dtNominee.Columns.Add(new DataColumn("SlNo", typeof(string)));
dtNominee.Columns.Add(new DataColumn("NomineeName", typeof(string)));
dtNominee.Columns.Add(new DataColumn("Relation", typeof(string)));
dtNominee.Columns.Add(new DataColumn("Address", typeof(string)));
dtNominee.Columns.Add(new DataColumn("NomineeShare", typeof(string)));
dtNominee.Columns.Add(new DataColumn("Amount", typeof(string)));
DataRow rowNominee = null;
for (int i = 0; i < oIssue.NomineeList.Count; i++)
{
rowNominee = dtNominee.NewRow();
rowNominee["Slno"] = oIssue.NomineeList[i].SlNo;
rowNominee["NomineeName"] = oIssue.NomineeList[i].NomineeName;
rowNominee["Relation"] = oIssue.NomineeList[i].Relation;
rowNominee["Address"] = oIssue.NomineeList[i].Address;
rowNominee["NomineeShare"] = oIssue.NomineeList[i].NomineeShare;
rowNominee["Amount"] = oIssue.NomineeList[i].Amount;
dtNominee.Rows.Add(rowNominee);
}
gvNomDetail.DataSource = dtNominee;
gvNomDetail.DataBind();
dtNominee.Rows.Clear();
for (int iNomIndx = 0; iNomIndx < oIssue.OldNomineeList.Count; iNomIndx++)
{
rowNominee = dtNominee.NewRow();
rowNominee["Slno"] = oIssue.OldNomineeList[iNomIndx].SlNo;
rowNominee["NomineeName"] = oIssue.OldNomineeList[iNomIndx].NomineeName;
rowNominee["Relation"] = oIssue.OldNomineeList[iNomIndx].Relation;
rowNominee["Address"] = oIssue.OldNomineeList[iNomIndx].Address;
rowNominee["NomineeShare"] = oIssue.OldNomineeList[iNomIndx].NomineeShare;
rowNominee["Amount"] = oIssue.OldNomineeList[iNomIndx].Amount;
dtNominee.Rows.Add(rowNominee);
}
gvOldNomineeList.DataSource = dtNominee;
gvOldNomineeList.DataBind();
}
#endregion
#region User Details
UserDetails oUserDetails = ucUserDet.UserDetail;
if (!SEARCH_FROM.Equals(1))
{
if (SEARCH_FROM.Equals(2) && sApprovalStaus.Equals("1"))
{
//Lodaing from StopSearch form
//with unapproved data
oUserDetails.MakerID = oIssue.UserDetails.MakerID;
oUserDetails.MakeDate = DateTime.Now;
oUserDetails.CheckerID = oIssue.UserDetails.CheckerID;
oUserDetails.CheckDate = oIssue.UserDetails.CheckDate;
oUserDetails.CheckerComment = oIssue.UserDetails.CheckerComment;
ucUserDet.UserDetail = oUserDetails;
}
else if (SEARCH_FROM.Equals(0))
{
//Lodaing for Approve
//viewed by Checker
oUserDetails.MakerID = oIssue.UserDetails.MakerID;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
}
}
#endregion
}
else
{
ucMessage.OpenMessage("Invalid Registration no. Please check..", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
protected void SearchAction()
{
string sType = Request.QueryString["pType"];
gvData.DataSource = null;
gvData.DataBind();
if (!string.IsNullOrEmpty(sType))
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
#region Receive
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.RECEIVE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Receive Approval Queue List";
ReceiveDAL oReceiveDAL = new ReceiveDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Receive' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oReceiveDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
}
#endregion Receive
#region Issue
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_UPDATE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Issue Update Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue Update' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadTmpIssueUpdateDataTableList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_OLD).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Old Customer Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Old Customer Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedOldCustomerIssueList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_ONL).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Online Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'SP Online Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedOnlineIssueList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion Issue
#region interst payment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.INTEREST_PAYMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Interst Payment Approval Queue List";
InterestPaymentDAL oIntPayDAL = new InterestPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Interst Payment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIntPayDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIntPayList = (DataTable)oResult.Return;
if (dtTmpIntPayList != null)
{
gvData.DataSource = dtTmpIntPayList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIntPayList;
}
}
#endregion interst payment
#region Encashment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.ENCASHED).PadLeft(5, '0')))
{
lgText.InnerHtml = "Encashment Approval Queue List";
EncashmentDAL oEncashDAL = new EncashmentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Encashment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oEncashDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIntPayList = (DataTable)oResult.Return;
if (dtTmpIntPayList != null)
{
gvData.DataSource = dtTmpIntPayList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIntPayList;
}
}
#endregion Encashment
#region Stop Payment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.STOP_PAYMENT_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Payment Mark Approval Queue List";
StopPaymentDAL oStopPayDAL = new StopPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Payment Mark' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oStopPayDAL.LoadUnapprovedPaymentMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.STOP_PAYMENT_REMOVE_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Payment Remove Mark Approval Queue List";
StopPaymentDAL oStopPayDAL = new StopPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Payment Remove Marks' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oStopPayDAL.LoadUnapprovedPaymentRemoveMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.DUPLICATE_ISSUE).PadLeft(5, '0')))
{
lgText.InnerHtml = "Duplicate Issues Approval Queue List";
DuplicateIssueDAL oDIDAL = new DuplicateIssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Duplicate Issues' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oDIDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Stop Payment
#region Lien
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Lien Mark Approval Queue List";
LienDAL oLienDAL = new LienDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Lien Mark' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oLienDAL.LoadUnapprovedLienMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK_REMOVE).PadLeft(5, '0')))
{
lgText.InnerHtml = "Lien Mark Remove Approval Queue List";
LienDAL oLienDAL = new LienDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Lien Mark Remove' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oLienDAL.LoadUnapprovedLienRemoveMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Lien
#region Reinvestment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.REINVESTMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reinvestment Approval Queue List";
ReinvestmentDAL oRiDAL = new ReinvestmentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reinvestment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oRiDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Reinvestment
#region ACE Register
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.ACE_MANAGER).PadLeft(5, '0')))
{
lgText.InnerHtml = "ACE Registration Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedACERegisterList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion ACE Register
//Make Filter By User
//Config oConfig = Session[Constants.SES_USER_CONFIG] as Config;
if (!string.IsNullOrEmpty(oConfig.FilterMakerID))
{
DDListUtil.Assign(ddlUserName, oConfig.FilterMakerID.Trim());
FilterData(oConfig.FilterMakerID.Trim());
}
}
}
