protected void gvCertInfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
LienRemove oLienRemove = (LienRemove)Session[Constants.SES_LIEN_REMOVE_MARK];
if (oLienRemove != null && gvRow != null)
{
oLienRemove.DtLienRemoveDetail.Rows.RemoveAt(gvRow.RowIndex);
DataTable tmpDt = oLienRemove.DtLienRemoveDetail.Copy();
if (tmpDt.Columns.Contains("SPScripID"))
{
tmpDt.Columns.Remove("SPScripID");
}
gvCertInfo.DataSource = tmpDt;
gvCertInfo.DataBind();
Session[Constants.SES_STOPPAY_REMOVE_MARK] = oLienRemove;
}
decimal dTotalAmount = 0m;
foreach (GridViewRow gvr in gvCertInfo.Rows)
{
dTotalAmount += Util.GetDecimalNumber(gvr.Cells[1].Text);
}
txtCDRemoveAmount.Text = dTotalAmount.ToString("N2");
}
protected void btnSave_Click(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
if (!hdDataType.Value.Equals("2"))
{
LienRemove oLienRemove = GetObject();
LienDAL oLienDAL = new LienDAL();
Result oResult = oLienDAL.SaveLienRemoveMark(oLienRemove);
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_APPROVED_SAVE_DATA, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdLienRemoveTransNo.Value))
{
LienRemove oLienRemove = new LienRemove(hdLienRemoveTransNo.Value);
LienDAL oLienDAL = new LienDAL();
oLienRemove.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oLienDAL.ApproveLienRemoveMark(oLienRemove);
if (oResult.Status)
{
ReportDAL rdal = new ReportDAL();
oResult = rdal.LienLetter(Constants.LETTER_TYPE_LIEN_REMOVE, txtUnlienTransNo.Text);
if (oResult.Status)
{
Session[Constants.SES_RPT_DATA] = oResult.Return;
Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
}
//ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
ClearAfterApprove();
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND + " to Approve", Constants.MSG_TYPE_INFO);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
private void LoadDataByRegNo(string sTransNo, string sRegNo, string sApprovalStaus)
{
LienDAL oLienDAL = new LienDAL();
Result oResult = null;
if (SEARCH_FROM.Equals(2)) //LienMark search
{
oResult = (Result)oLienDAL.LoadLienRemoveMarkByRegNo("", sTransNo, sRegNo, "");
}
else if (SEARCH_FROM.Equals(1) || SEARCH_FROM.Equals(3) || SEARCH_FROM.Equals(4))
{
oResult = (Result)oLienDAL.LoadLienRemoveMarkByRegNo(sTransNo, "", sRegNo, sApprovalStaus);
}
TotalClear();
//hdIssueTransNo.Value = sRegNo;
if (oResult.Status)
{
LienRemove oLienRemove = (LienRemove)oResult.Return;
SetObject(oLienRemove);
if (hdDataType.Value.Equals("2"))
{
EnableDisableControl(true);
Util.ControlEnabled(btnReject, false);
Util.ControlEnabled(btnApprove, false);
Util.ControlEnabled(btnBack, false);
Util.ControlEnabled(btnReset, true);
Util.ControlEnabled(btnSave, true);
Util.ControlEnabled(btnDelete, true);
fsList.Visible = true;
btnRegSearch.Enabled = true;
btnUnLienSearch.Enabled = true;
}
else if (SEARCH_FROM.Equals(4))
{
EnableDisableControl(true);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), true);
}
else
{
EnableDisableControl(false);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadDataByTransactionNo(string sTransactionNo)
{
LienDAL oLienDAL = new LienDAL();
Result oResult = (Result)oLienDAL.LoadLienRemoveMarkByTransactionNo(sTransactionNo);
TotalClear();
if (oResult.Status)
{
LienRemove oLienRemove = (LienRemove)oResult.Return;
SetObject(oLienRemove);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void ddlCDDenom_SelectedIndexChanged(object sender, EventArgs e)
{
ddlCDCertif.Items.Clear();
if (!string.IsNullOrEmpty(ddlCDDenom.SelectedValue))
{
LienRemove oLienRemove = (LienRemove)Session[Constants.SES_LIEN_REMOVE_MARK];
DDListUtil.Add(ddlCDCertif, "", "");
if ((!string.IsNullOrEmpty(oLienRemove.LienRemoveTransNo) && oLienRemove.DtLienRemoveDetail.Rows.Count > 0) || string.IsNullOrEmpty(oLienRemove.LienRemoveTransNo))
{
//Filtered by Denomination
List <Scrip> filteredScripList = oLienRemove.Issue.ScripList.Where(s => s.Denomination.DenominationID.ToString().Equals(ddlCDDenom.SelectedValue)).ToList();
for (int iScripCount = 0; iScripCount < filteredScripList.Count; iScripCount++)
{
DDListUtil.Add(ddlCDCertif, filteredScripList[iScripCount].SPSeries + " " + filteredScripList[iScripCount].SlNo, filteredScripList[iScripCount].SPScripID.ToString());
}
}
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdLienRemoveTransNo.Value))
{
LienRemove oLienRemove = new LienRemove(hdLienRemoveTransNo.Value);
LienDAL oLienDAL = new LienDAL();
oLienRemove.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oLienDAL.RejectLienRemoveMark(oLienRemove);
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_NOT_FOUND + " to Reject", Constants.MSG_TYPE_INFO);
}
}
private LienRemove GetObject()
{
LienRemove oLienRemove = (LienRemove)Session[Constants.SES_LIEN_REMOVE_MARK];
if (oLienRemove != null)
{
if (string.IsNullOrEmpty(oLienRemove.LienRemoveTransNo))
{
oLienRemove.LienRemoveTransNo = "-1";
}
oLienRemove.LienRemoveAmount = Util.GetDecimalNumber(txtCDRemoveAmount.Text);
oLienRemove.LienRemoveDate = Util.GetDateTimeByString(txtUnlienDate.Text);
oLienRemove.LienBank = txtLienBank.Text.ToUpper();
oLienRemove.LienBankAddress = txtBankAddress.Text.ToUpper();
oLienRemove.OurRef = txtOurRefNo.Text.ToUpper();
oLienRemove.TheirRef = txtTheirRefNo.Text.ToUpper();
oLienRemove.Remarks = txtRemarks.Text.ToUpper();
oLienRemove.UserDetails = ucUserDet.UserDetail;
}
return(oLienRemove);
}
private void LoadDataByRegNo(string sTransNo, string sRegNo, string sApprovalStaus, string sType)
{
LienDAL oLienDAL = new LienDAL();
Result oResult = null;
TotalClear();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Reg No", typeof(string)));
dt.Columns.Add(new DataColumn("Issue Date", typeof(string)));
dt.Columns.Add(new DataColumn("Bond Holder", typeof(string)));
dt.Columns.Add(new DataColumn("Certificate No", typeof(string)));
dt.Columns.Add(new DataColumn("Denomination", typeof(string)));
dt.Columns.Add(new DataColumn("Amount", typeof(string)));
DataRow row = null;
ArrayList al = new ArrayList();
if (sType.Equals("LM")) //LienMark search
{
oResult = (Result)oLienDAL.LoadLienMarkByTransactionNo(sTransNo, sApprovalStaus);
if (oResult.Status)
{
Lien oLien = (Lien)oResult.Return;
if (oLien != null)
{
txtLienBank.Text = oLien.LienBank + (oLien.LienBankAddress == "" ? "" : "," + oLien.LienBankAddress);
txtOurRefNo.Text = oLien.OurRef;
txtThierRefNo.Text = oLien.TheirRef;
txtLienTransNo.Text = oLien.LienTransNo;
txtLienDate.Text = oLien.LienDate.ToString(Constants.DATETIME_FORMAT);
if (oLien.DtLienDetails.Rows.Count > 0)
{
for (int i = 0; i < oLien.DtLienDetails.Rows.Count; i++)
{
if (!al.Contains(oLien.DtLienDetails.Rows[i]["SP Series"]))
{
row = dt.NewRow();
row["Reg No"] = oLien.Issue.RegNo;
row["Issue Date"] = oLien.Issue.VersionIssueDate.ToString(Constants.DATETIME_dd_MMM_yyyy);
row["Bond Holder"] = oLien.Issue.BondHolderName;
row["Certificate No"] = oLien.DtLienDetails.Rows[i]["SP Series"] + "-" + oLien.DtLienDetails.Rows[i]["SPScripID"];
row["Denomination"] = oLien.DtLienDetails.Rows[i]["Denomination"];
row["Amount"] = oLien.DtLienDetails.Rows[i]["Denomination"];
dt.Rows.Add(row);
al.Add(oLien.DtLienDetails.Rows[i]["SP Series"]);
}
else
{
dt.Rows[al.IndexOf(oLien.DtLienDetails.Rows[i]["SP Series"])]["Amount"] = Convert.ToDouble(dt.Rows[al.IndexOf(oLien.DtLienDetails.Rows[i]["SP Series"])]["Amount"]) + Convert.ToDouble(oLien.DtLienDetails.Rows[i]["Denomination"]);
dt.Rows[al.IndexOf(oLien.DtLienDetails.Rows[i]["SP Series"])]["Certificate No"] = dt.Rows[al.IndexOf(oLien.DtLienDetails.Rows[i]["SP Series"])]["Certificate No"] + ", " + oLien.DtLienDetails.Rows[i]["SP Series"] + "-" + oLien.DtLienDetails.Rows[i]["SPScripID"];
}
}
}
if (dt.Rows.Count > 0)
{
gvData.DataSource = dt;
}
else
{
gvData.DataSource = null;
}
gvData.DataBind();
}
}
}
else if (sType.Equals("LMR")) //LienMark remove search
{
oResult = (Result)oLienDAL.LoadLienRemoveMarkByRegNo(sTransNo, "", sRegNo, sApprovalStaus);
if (oResult.Status)
{
LienRemove oLienRemove = (LienRemove)oResult.Return;
if (oLienRemove != null)
{
txtLienBank.Text = oLienRemove.LienBank + (oLienRemove.LienBankAddress == "" ? "" : "," + oLienRemove.LienBankAddress);
txtOurRefNo.Text = oLienRemove.OurRef;
txtThierRefNo.Text = oLienRemove.TheirRef;
//txtLienTransNo.Text = oLienRemove.Lien.LienTransNo;
txtLienTransNo.Text = sTransNo;
txtLienDate.Text = oLienRemove.Lien.LienDate.ToString(Constants.DATETIME_FORMAT);
if (oLienRemove.DtLienRemoveDetail.Rows.Count > 0)
{
for (int i = 0; i < oLienRemove.DtLienRemoveDetail.Rows.Count; i++)
{
if (!al.Contains(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"]))
{
row = dt.NewRow();
row["Reg No"] = oLienRemove.Issue.RegNo;
row["Issue Date"] = oLienRemove.Issue.VersionIssueDate.ToString(Constants.DATETIME_dd_MMM_yyyy);
row["Bond Holder"] = oLienRemove.Issue.BondHolderName;
row["Certificate No"] = oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"] + "-" + oLienRemove.DtLienRemoveDetail.Rows[i]["SPScripID"];
row["Denomination"] = oLienRemove.DtLienRemoveDetail.Rows[i]["Denomination"];
row["Amount"] = oLienRemove.DtLienRemoveDetail.Rows[i]["Denomination"];
dt.Rows.Add(row);
al.Add(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"]);
}
else
{
dt.Rows[al.IndexOf(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"])]["Amount"] = Convert.ToDouble(dt.Rows[al.IndexOf(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"])]["Amount"]) + Convert.ToDouble(oLienRemove.DtLienRemoveDetail.Rows[i]["Denomination"]);
dt.Rows[al.IndexOf(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"])]["Certificate No"] = dt.Rows[al.IndexOf(oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"])]["Certificate No"] + ", " + oLienRemove.DtLienRemoveDetail.Rows[i]["SP Series"] + "-" + oLienRemove.DtLienRemoveDetail.Rows[i]["SPScripID"];
}
}
}
if (dt.Rows.Count > 0)
{
gvData.DataSource = dt;
}
else
{
gvData.DataSource = null;
}
gvData.DataBind();
}
}
}
}
private void TotalClear()
{
EnableDisableControl(false);
// Stop Payment Remove Mark set in session
LienRemove oLienRemoveMark = new LienRemove();
if (Session[Constants.SES_LIEN_REMOVE_MARK] == null)
{
Session.Add(Constants.SES_LIEN_REMOVE_MARK, oLienRemoveMark);
}
else
{
Session[Constants.SES_LIEN_REMOVE_MARK] = oLienRemoveMark;
}
gvCustomerDetail.DataSource = null;
gvCustomerDetail.DataBind();
gvNomDetail.DataSource = null;
gvNomDetail.DataBind();
gvCertInfo.DataSource = null;
gvCertInfo.DataBind();
hdLienRemoveTransNo.Value = "";
hdIssueTransNo.Value = "";
hdRegNo.Value = "";
//Lien Remove Mark Transaction No
txtLienAmount.Text = string.Empty;
txtLienTransNo.Text = string.Empty;
txtUnlienTransNo.Text = string.Empty;
txtUnlienDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtRegNo.Text = string.Empty;
//Issue Details
txtIssueDate.Text = string.Empty;
txtIssueName.Text = string.Empty;
if (ddlBranch.Items.Count > 0)
{
ddlBranch.SelectedIndex = 0;
}
ddlCustomerType.Items.Clear();
if (ddlSpType.Items.Count > 0)
{
ddlSpType.SelectedIndex = 0;
}
//Customer(s) Details
gvCustomerDetail.Enabled = true;
//Nominee(s) Details
gvNomDetail.Enabled = true;
//Certificate
gvCertInfo.Enabled = true;
// Lien Remove Detail
txtRemarks.Text = string.Empty;
txtOurRefNo.Text = string.Empty;
txtTheirRefNo.Text = string.Empty;
txtLienBank.Text = string.Empty;
txtBankAddress.Text = string.Empty;
txtLienAmount.Text = string.Empty;
//Certificate Detail
ddlCDDenom.Items.Clear();
ddlCDCertif.Items.Clear();
txtCDUpTo.Text = "1";
txtCDRemoveAmount.Text = string.Empty;
ucUserDet.Reset();
ucUserDet.ResetData();
}
private void SetObject(LienRemove oLienRemove)
{
if (oLienRemove != null)
{
if (oLienRemove.Issue != null)
{
hdLienRemoveTransNo.Value = oLienRemove.LienRemoveTransNo;
hdIssueTransNo.Value = oLienRemove.Issue.IssueTransNo;
hdRegNo.Value = oLienRemove.Issue.RegNo;
//Lien Detail
txtLienDate.Text = oLienRemove.Lien.LienDate.ToString(Constants.DATETIME_FORMAT);
txtLienTransNo.Text = oLienRemove.Lien.LienTransNo;
txtLienAmount.Text = oLienRemove.Lien.LienAmount.ToString();
//Load from LienMark search
if (oLienRemove.LienRemoveDate.Year.Equals(1) || oLienRemove.LienRemoveDate.Year.Equals(1900))
{
txtUnlienDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
}
else //Load from LienMark Remove search
{
txtUnlienDate.Text = oLienRemove.LienRemoveDate.ToString(Constants.DATETIME_FORMAT);
}
txtOurRefNo.Text = oLienRemove.OurRef;
txtTheirRefNo.Text = oLienRemove.TheirRef;
if (!string.IsNullOrEmpty(oLienRemove.LienBank))
{
txtLienBank.Text = oLienRemove.LienBank;
}
else
{
txtLienBank.Text = oLienRemove.Lien.LienBank;
}
if (!string.IsNullOrEmpty(oLienRemove.LienBankAddress))
{
txtBankAddress.Text = oLienRemove.LienBankAddress;
}
else
{
txtBankAddress.Text = oLienRemove.Lien.LienBankAddress;
}
// Remarks
txtRemarks.Text = oLienRemove.Remarks;
//Issue Details
txtRegNo.Text = oLienRemove.Issue.RegNo.ToString();
txtIssueDate.Text = oLienRemove.Issue.VersionIssueDate.ToString(Constants.DATETIME_FORMAT);
txtIssueName.Text = oLienRemove.Issue.IssueName.ToString();
ddlSpType.Text = oLienRemove.Issue.SPType.SPTypeID.Trim();
ddlBranch.Text = oLienRemove.Issue.Branch.BranchID.Trim();
DDListUtil.Assign(ddlCustomerType, oLienRemove.Issue.VersionSPPolicy.DTCustomerTypePolicy, true);
DDListUtil.Assign(ddlCustomerType, oLienRemove.Issue.CustomerType.CustomerTypeID);
// User Info
// ucUserDet.UserDetail = oLienRemove.UserDetails;
#region Customer Details
DataTable dtCustomerDetails = new DataTable();
dtCustomerDetails.Columns.Add(new DataColumn("Customer Name", typeof(string)));
//dtCustomerDetails.Columns.Add(new DataColumn("Customer ID", typeof(string)));
dtCustomerDetails.Columns.Add(new DataColumn("Address", typeof(string)));
DataRow rowCustomerDetails = null;
for (int customerCount = 0; customerCount < oLienRemove.Issue.CustomerDetailsList.Count; customerCount++)
{
rowCustomerDetails = dtCustomerDetails.NewRow();
rowCustomerDetails["Customer Name"] = oLienRemove.Issue.CustomerDetailsList[customerCount].CustomerName;
//rowCustomerDetails["Customer ID"] = oLienRemove.Issue.CustomerDetailsList[customerCount].CustomerID;
rowCustomerDetails["Address"] = oLienRemove.Issue.CustomerDetailsList[customerCount].Address;
dtCustomerDetails.Rows.Add(rowCustomerDetails);
}
gvCustomerDetail.DataSource = dtCustomerDetails;
gvCustomerDetail.DataBind();
#endregion
#region Nominee Detail
DataTable dtNomineeDetail = new DataTable();
dtNomineeDetail.Columns.Add(new DataColumn("Nominee Name", typeof(string)));
dtNomineeDetail.Columns.Add(new DataColumn("Relation", typeof(string)));
dtNomineeDetail.Columns.Add(new DataColumn("Address", typeof(string)));
dtNomineeDetail.Columns.Add(new DataColumn("Nominee Share", typeof(string)));
DataRow rowNomineeDetail = null;
for (int nomineeCount = 0; nomineeCount < oLienRemove.Issue.NomineeList.Count; nomineeCount++)
{
rowNomineeDetail = dtNomineeDetail.NewRow();
rowNomineeDetail["Nominee Name"] = oLienRemove.Issue.NomineeList[nomineeCount].NomineeName;
rowNomineeDetail["Relation"] = oLienRemove.Issue.NomineeList[nomineeCount].Relation;
rowNomineeDetail["Address"] = oLienRemove.Issue.NomineeList[nomineeCount].Address;
rowNomineeDetail["Nominee Share"] = oLienRemove.Issue.NomineeList[nomineeCount].NomineeShare;
dtNomineeDetail.Rows.Add(rowNomineeDetail);
}
gvNomDetail.DataSource = dtNomineeDetail;
gvNomDetail.DataBind();
#endregion
#region Certificate Detail
ArrayList alScrip = new ArrayList();
ddlCDDenom.Items.Clear();
DDListUtil.Add(ddlCDDenom, "", "");
for (int iScripCount = 0; iScripCount < oLienRemove.Issue.ScripList.Count; iScripCount++)
{
if (!alScrip.Contains(oLienRemove.Issue.ScripList[iScripCount].Denomination.DenominationID))
{
DDListUtil.Add(ddlCDDenom, oLienRemove.Issue.ScripList[iScripCount].Denomination.DenominationID.ToString(), oLienRemove.Issue.ScripList[iScripCount].Denomination.DenominationID.ToString());
alScrip.Add(oLienRemove.Issue.ScripList[iScripCount].Denomination.DenominationID);
}
}
#endregion Certificate Detail
// Certificate Detail
txtCDRemoveAmount.Text = oLienRemove.LienRemoveAmount.ToString("N2");
DataTable tmpDt = oLienRemove.DtLienRemoveDetail.Copy();
if (tmpDt.Columns.Contains("SPScripID"))
{
tmpDt.Columns.Remove("SPScripID");
}
gvCertInfo.DataSource = tmpDt;
gvCertInfo.DataBind();
Session[Constants.SES_LIEN_REMOVE_MARK] = oLienRemove;
if ((SEARCH_FROM.Equals(2)) && ddlCDDenom.Items.Count <= 1)
{
ucMessage.OpenMessage("Lien Mark removed!!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
else
{
txtUnlienTransNo.Text = oLienRemove.LienRemoveTransNo;
}
// user detail
UserDetails oUserDetails = ucUserDet.UserDetail;
if (hdDataType.Value.Equals("2"))
{
oUserDetails.MakerID = oLienRemove.UserDetails.MakerID;
oUserDetails.MakeDate = oLienRemove.UserDetails.MakeDate;
oUserDetails.CheckerID = oLienRemove.UserDetails.CheckerID;
oUserDetails.CheckDate = oLienRemove.UserDetails.CheckDate;
oUserDetails.CheckerComment = oLienRemove.UserDetails.CheckerComment;
ucUserDet.UserDetail = oUserDetails;
}
if (SEARCH_FROM.Equals(4))
{
oUserDetails.MakerID = oLienRemove.UserDetails.MakerID;
oUserDetails.CheckerComment = oLienRemove.UserDetails.CheckerComment;
ucUserDet.UserDetail = oUserDetails;
}
else
{
oUserDetails.CheckerID = oLienRemove.UserDetails.CheckerID;
oUserDetails.CheckDate = oLienRemove.UserDetails.CheckDate;
oUserDetails.CheckerComment = oLienRemove.UserDetails.CheckerComment;
ucUserDet.UserDetail = oUserDetails;
}
}
}
}
private void Calculate(string sAction)
{
LienRemove oLienRemove = (LienRemove)Session[Constants.SES_LIEN_REMOVE_MARK];
DataTable dt = null;
if (oLienRemove != null)
{
dt = oLienRemove.DtLienRemoveDetail;
if (dt.Columns.Count <= 0)
{
dt.Columns.Add(new DataColumn("SPScripID", typeof(string)));
dt.Columns.Add(new DataColumn("Denomination", typeof(string)));
dt.Columns.Add(new DataColumn("SP Series", typeof(string)));
dt.Columns.Add(new DataColumn("Sl No", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
}
}
if (sAction.Equals("MS")) //Mark Single
{
#region Mark Single
int iUpTo = Util.GetIntNumber(txtCDUpTo.Text);
if (iUpTo > 0)
{
int iSelectedIndex = ddlCDCertif.SelectedIndex;
for (int certificateIndex = 0; certificateIndex < iUpTo; certificateIndex++)
{
if (certificateIndex + iSelectedIndex == ddlCDCertif.Items.Count)
{
break;
}
bool isExist = false;
if (dt.Rows.Count > 0)
{
DataRow[] selectedRow = dt.Select("SPScripID = " + ddlCDCertif.Items[certificateIndex + iSelectedIndex].Value);
if (selectedRow.Count() > 0)
{
isExist = true;
}
}
if (!isExist)
{
DataRow row = dt.NewRow();
row["SPScripID"] = ddlCDCertif.Items[certificateIndex + iSelectedIndex].Value;
row["Denomination"] = ddlCDDenom.SelectedItem.Value;
string sTmp = ddlCDCertif.Items[certificateIndex + iSelectedIndex].Text;
row["SP Series"] = (sTmp.Substring(0, sTmp.LastIndexOf(' '))).Trim();
row["Sl No"] = (sTmp.Substring(sTmp.LastIndexOf(' ') + 1, (sTmp.Length - sTmp.LastIndexOf(' ')) - 1)).Trim();
row["Status"] = "WAITING FOR APPROVE";
dt.Rows.Add(row);
}
}
}
#endregion
}
else if (sAction.Equals("MA")) //Mark All
{
#region Mark All
if (oLienRemove != null)
{
int iDnomCount = 0;
if (dt.Rows.Count > 0)
{
object objCount = dt.Compute("COUNT(Denomination)", "Denomination = " + ddlCDDenom.SelectedItem.Value);
if (objCount != null)
{
iDnomCount = Convert.ToInt32(objCount);
}
if (iDnomCount > 0)
{
DataRow[] DrDenomCheck = dt.Select("Denomination = " + ddlCDDenom.SelectedItem.Value);
foreach (DataRow DrCheck in DrDenomCheck)
{
dt.Rows.Remove(DrCheck);
}
}
}
for (int scripIndex = 0; scripIndex < oLienRemove.Issue.ScripList.Count; scripIndex++)
{
DataRow row = dt.NewRow();
if (ddlCDDenom.SelectedItem.Value.Equals(oLienRemove.Issue.ScripList[scripIndex].Denomination.DenominationID.ToString()))
{
row["SPScripID"] = oLienRemove.Issue.ScripList[scripIndex].SPScripID;
row["Denomination"] = oLienRemove.Issue.ScripList[scripIndex].Denomination.DenominationID;
row["SP Series"] = oLienRemove.Issue.ScripList[scripIndex].SPSeries;
row["Sl No"] = oLienRemove.Issue.ScripList[scripIndex].SlNo;
row["Status"] = "WAITING FOR APPROVE";
dt.Rows.Add(row);
}
}
}
#endregion
}
else if (sAction.Equals("RA")) //Remove All
{
dt.Rows.Clear();
}
if (dt.Rows.Count > 0)
{
dt.DefaultView.Sort = "Sl No";
}
oLienRemove.DtLienRemoveDetail = dt;
DataTable tmpDt = dt.Copy();
Session[Constants.SES_LIEN_REMOVE_MARK] = oLienRemove;//update session
if (tmpDt.Columns.Contains("SPScripID"))
{
tmpDt.Columns.Remove("SPScripID");
}
gvCertInfo.DataSource = tmpDt;
gvCertInfo.DataBind();
decimal dTotalAmount = 0m;
foreach (GridViewRow gvr in gvCertInfo.Rows)
{
dTotalAmount += Util.GetDecimalNumber(gvr.Cells[1].Text);
}
txtCDRemoveAmount.Text = dTotalAmount.ToString("N2");
}
