public string getPayType(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
DataTable dtpayTypeInfo = commonGatewayObj.Select(" SELECT PAY_TYPE FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString() + "' AND REP_NO=" + repObj.RepurchaseNo);
string payType = dtpayTypeInfo.Rows[0]["PAY_TYPE"].ToString().ToUpper();
return(payType);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(RepNoTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseRate = Convert.ToInt32(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
try
{
if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else
{
DataTable dtGrid = opendMFDAO.getTableDataGrid();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
drGrid = dtGrid.NewRow();
drGrid["SL_NO"] = gridRow.Cells[1].Text.Trim().ToString();
drGrid["CERTIFICATE"] = gridRow.Cells[2].Text.Trim().ToString();
drGrid["QTY"] = gridRow.Cells[3].Text.Trim().ToString();
dtGrid.Rows.Add(drGrid);
}
}
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
//RepNoTextBox.Text = unitRepBLObj.getNextRepurchaseNo(regObj, userObj).ToString();
//unitRepObj.RepurchaseNo = unitRepBLObj.getNextRepurchaseNo(regObj, userObj) - 1;
//RepDateTextBox.Text = unitRepBLObj.getLastRepDate(regObj, unitRepObj).ToString("dd-MMM-yyyy");
//RepRateTextBox.Text = unitRepBLObj.getLastRepRate(regObj, unitRepObj).ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
public decimal getLastRepRate(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
decimal lastRepRate = 0;
DataTable dtLastSaleRate = new DataTable();
dtLastSaleRate = commonGatewayObj.Select("SELECT DISTINCT REP_PRICE AS MAX_REP_PRICE FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND REP_DT IN (SELECT MAX(REP_DT) AS MAX_REP_DATE FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND REP_NO =" + repObj.RepurchaseNo + ")");
if (dtLastSaleRate.Rows.Count > 0)
{
lastRepRate = Convert.ToDecimal(dtLastSaleRate.Rows[0]["MAX_REP_PRICE"].ToString());
}
return(lastRepRate);
}
public bool IsIDAccount(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
bool IDAccountStatus = false;
if (repObj.PayType.ToString().ToUpper() == "EFT")
{
DataTable dtValidBEFTNInfo = commonGatewayObj.Select("SELECT * FROM U_MASTER WHERE ID_FLAG='Y' AND U_MASTER.REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND U_MASTER.REG_BR='" + regObj.BranchCode.ToString() + "' AND U_MASTER.REG_NO=" + regObj.RegNumber);
if (dtValidBEFTNInfo.Rows.Count > 0)
{
IDAccountStatus = true;
}
}
return(IDAccountStatus);
}
public bool IsDuplicateRepurchase(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
DataTable dtRepurchase = new DataTable();
dtRepurchase = commonGatewayObj.Select("SELECT * FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND REP_NO=" + Convert.ToInt32(repObj.RepurchaseNo.ToString()));
if (dtRepurchase.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public DateTime getLastRepDate(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
DateTime lastSaleDate;
DataTable dtLastSaleDate = new DataTable();
dtLastSaleDate = commonGatewayObj.Select("SELECT MAX(REP_DT) AS MAX_REP_DATE FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'AND REP_NO=" + repObj.RepurchaseNo);
if (dtLastSaleDate.Rows.Count > 0)
{
lastSaleDate = Convert.ToDateTime(dtLastSaleDate.Rows[0]["MAX_REP_DATE"].Equals(DBNull.Value) ? DateTime.Today.ToString() : dtLastSaleDate.Rows[0]["MAX_REP_DATE"].ToString());
}
else
{
lastSaleDate = DateTime.Today;
}
return(lastSaleDate);
}
public bool IsValidBEFTN(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
bool BeftnStatus = true;
if (repObj.PayType.ToString().ToUpper() == "EFT")
{
DataTable dtValidBEFTNInfo = commonGatewayObj.Select("SELECT U_MASTER.BK_AC_NO, BANK_BRANCH.ROUTING_NO FROM U_MASTER INNER JOIN BANK_BRANCH ON U_MASTER.BK_NM_CD = BANK_BRANCH.BANK_CODE AND U_MASTER.BK_BR_NM_CD = BANK_BRANCH.BRANCH_CODE WHERE U_MASTER.REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND U_MASTER.REG_BR='" + regObj.BranchCode.ToString() + "' AND U_MASTER.REG_NO=" + regObj.RegNumber + " AND BANK_BRANCH.ROUTING_NO IS NOT NULL ");
if (dtValidBEFTNInfo.Rows.Count > 0)
{
if (dtValidBEFTNInfo.Rows[0]["BK_AC_NO"].ToString().Length > 13)
{
BeftnStatus = false;
}
}
else
{
BeftnStatus = false;
}
}
return(BeftnStatus);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(RepNoTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
long totalSurrenderUnits = 0;
DataTable dtGrid = opendMFDAO.getTableDataGrid();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
drGrid = dtGrid.NewRow();
drGrid["SL_NO"] = gridRow.Cells[1].Text.Trim().ToString();
drGrid["CERTIFICATE"] = gridRow.Cells[2].Text.Trim().ToString();
drGrid["QTY"] = gridRow.Cells[3].Text.Trim().ToString();
totalSurrenderUnits = totalSurrenderUnits + Convert.ToInt64(gridRow.Cells[3].Text.Trim().ToString());
dtGrid.Rows.Add(drGrid);
}
}
if (dtGrid.Rows.Count > 0)
{
if (totalSurrenderUnits == Convert.ToInt64(TotalUnitRepurchaseTextBox.Text))
{
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
//NormalRadioButton.Checked = true;
//DeathRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed : Total Selected Units and Add Total Units is not equal');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to No Sale Selected');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void RegNoTextBox_TextChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitRepurchase unitRepObj = new UnitRepurchase();
if (opendMFDAO.IsValidRegistration(unitRegObj))
{
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtTotalSaleUnitCerts = opendMFDAO.getDtTotalSaleUnitCerts(unitRegObj);
decimal TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
HolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
HolderJNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
string[] BranchCodeSign = unitRegObj.BranchCode.Split('/');
string imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + "_" + BranchCodeSign[0] + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
}
if (dtTotalSaleUnitCerts.Rows.Count > 0)
{
dvContentBottom.Visible = true;
leftDataGrid.DataSource = dtTotalSaleUnitCerts;
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = TotalUnitsBalance.ToString();
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
TotalUnitRepurchaseTextBox.Text = "";
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dvContentBottom.Visible = false;
//NormalRadioButton.Checked = true;
//DeathRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Repurchase');", true);
}
RepNoTextBox.Text = unitRepBLObj.getNextRepurchaseNo(unitRegObj, userObj).ToString();
unitRepObj.RepurchaseNo = unitRepBLObj.getNextRepurchaseNo(unitRegObj, userObj) - 1;
RepDateTextBox.Text = unitRepBLObj.getLastRepDate(unitRegObj, unitRepObj).ToString("dd-MMM-yyyy");
RepRateTextBox.Text = unitRepBLObj.getLastRepRate(unitRegObj, unitRepObj).ToString();
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = "";
dvContentBottom.Visible = false;
//NormalRadioButton.Checked = true;
//DeathRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Repurchase');", true);
}
}
else
{
ClearText();
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = "";
dvContentBottom.Visible = false;
//NormalRadioButton.Checked = true;
//DeathRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(RepNoTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Surrender Value con not be equal or less than Zero');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
DataTable dtGrid = opendMFDAO.getTableDataGridCDS();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
TextBox SL_TR_NOTxt = (TextBox)gridRow.FindControl("SL_TR_NoTextBox");
TextBox SURRENDER_UNITSTxt = (TextBox)gridRow.FindControl("Sale_UnitsTextBox");
TextBox EXIST_UNITSTxt = (TextBox)gridRow.FindControl("Exist_UnitsTextBox");
drGrid = dtGrid.NewRow();
drGrid["SL_TR_NO"] = SL_TR_NOTxt.Text.Trim().ToString();
drGrid["SURRENDER_UNITS"] = SURRENDER_UNITSTxt.Text.Trim().ToString();
drGrid["EXIST_UNITS"] = EXIST_UNITSTxt.Text.Trim().ToString();
dtGrid.Rows.Add(drGrid);
}
}
unitRepBLObj.saveRepurchaseCDS(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
}
else
{
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(moneyReceipDropDownList.SelectedItem.Text.ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
unitRepObj.PayType = payTypeLabel.Text.ToUpper();
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
long totalSurrenderUnits = 0;
DataTable dtGrid = opendMFDAO.getTableDataGrid();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
drGrid = dtGrid.NewRow();
drGrid["SL_NO"] = gridRow.Cells[1].Text.Trim().ToString();
drGrid["CERTIFICATE"] = gridRow.Cells[2].Text.Trim().ToString();
drGrid["QTY"] = gridRow.Cells[3].Text.Trim().ToString();
totalSurrenderUnits = totalSurrenderUnits + Convert.ToInt64(gridRow.Cells[3].Text.Trim().ToString());
dtGrid.Rows.Add(drGrid);
}
}
if (dtGrid.Rows.Count > 0)
{
if (totalSurrenderUnits == Convert.ToInt64(TotalUnitRepurchaseTextBox.Text) && totalSurrenderUnits == Convert.ToInt64(QtyTextBox.Text))
{
commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + unitRepObj.RepurchaseNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString()));
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'REP' AND SL_REP_TR_RN_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed : Total Selected Units and Add Total Units is not equal');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to No Sale Selected');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
public void saveRepurchase(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitRepurchase repObj, UnitUser unitUserObj)
{
try
{
UnitTransferBL unitTransferBLObj = new UnitTransferBL();
commonGatewayObj.BeginTransaction();
Hashtable htRepurchaseRegInfo = new Hashtable();
Hashtable htCertNoTemp = new Hashtable();
int SL_TR_RN = 0;
int CertNo = 0;
string certType = "";
string[] saleNoArray;
string[] certArray;
string statusFlag = "R";
string Old_SL_TR_RN = "";
for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++)
{
if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0)
{
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htRepurchaseRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "S" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0)
{
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htRepurchaseRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
commonGatewayObj.Update(htRepurchaseRegInfo, "SALE_CERT", "REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
commonGatewayObj.Update(htRepurchaseRegInfo, "RENEWAL_OUT", "REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "T" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0)
{
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htRepurchaseRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "R" + SL_TR_RN.ToString();
}
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REP_NO", Convert.ToInt32(repObj.RepurchaseNo.ToString()));
htRepurchaseRegInfo.Add("REG_NO", Convert.ToInt32(regObj.RegNumber.ToString()));
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
htRepurchaseRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper());
htRepurchaseRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString()));
htRepurchaseRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper());
htRepurchaseRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString()));
htRepurchaseRegInfo.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper());
commonGatewayObj.Insert(htRepurchaseRegInfo, "REP_CERT_NO");
}
DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert);
for (int i = 0; i < dtTransfer.Rows.Count; i++)
{
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("REP_NO", Convert.ToInt32(repObj.RepurchaseNo.ToString()));
htRepurchaseRegInfo.Add("REP_DT", Convert.ToDateTime(repObj.RepurchaseDate.ToString()).ToString("dd-MMM-yyyy"));
htRepurchaseRegInfo.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString());
htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("REP_PRICE", decimal.Parse(repObj.RepurchaseRate.ToString()));
htRepurchaseRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString()));
htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper());
htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString());
htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString());
htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
if (repObj.ChequeIssueTo == null)
{
htRepurchaseRegInfo.Add("CHQ_ISSUE_TO", DBNull.Value);
}
else
{
htRepurchaseRegInfo.Add("CHQ_ISSUE_TO", repObj.ChequeIssueTo.ToString());
}
commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE");
}
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
public void saveRepurchaseCDS(DataTable dtSaleTrInfo, UnitHolderRegistration regObj, UnitRepurchase repObj, UnitUser unitUserObj)
{
try
{
commonGatewayObj.BeginTransaction();
Hashtable htRepurchaseRegInfo = new Hashtable();
StringBuilder sbQuery = new StringBuilder();
string[] saleNoArray;
for (int loop = 0; loop < dtSaleTrInfo.Rows.Count; loop++)
{
if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('S') >= 0)
{
sbQuery = new StringBuilder();
saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('S');
sbQuery.Append("UPDATE SALE SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString()));
sbQuery.Append(" WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'");
sbQuery.Append(" AND REG_NO=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND SL_NO=" + Convert.ToInt32(saleNoArray[1].ToString()));
commonGatewayObj.ExecuteNonQuery(sbQuery.ToString());
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("REP_NO", repObj.RepurchaseNo);
htRepurchaseRegInfo.Add("REP_DT", repObj.RepurchaseDate);
htRepurchaseRegInfo.Add("SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"]);
htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("REP_PRICE", repObj.RepurchaseRate);
htRepurchaseRegInfo.Add("QTY", dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"]);
htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper());
htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString());
htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString());
htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE");
}
else if (dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().ToUpper().IndexOf('T') >= 0)
{
sbQuery = new StringBuilder();
saleNoArray = dtSaleTrInfo.Rows[loop]["SL_TR_NO"].ToString().Split('T');
sbQuery.Append("UPDATE TRANSFER SET QTY_OUT=NVL(QTY_OUT,0)+" + Convert.ToInt64(dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"].ToString()));
sbQuery.Append(" WHERE F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND BR_CODE='" + regObj.FundCode.ToString() + "_" + regObj.BranchCode.ToString().ToUpper() + "'");
sbQuery.Append(" AND REG_NO_I=" + Convert.ToInt32(regObj.RegNumber.ToString()) + " AND TR_NO=" + Convert.ToInt32(saleNoArray[1].ToString()));
commonGatewayObj.ExecuteNonQuery(sbQuery.ToString());
htRepurchaseRegInfo = new Hashtable();
htRepurchaseRegInfo.Add("REP_NO", repObj.RepurchaseNo);
htRepurchaseRegInfo.Add("REP_DT", repObj.RepurchaseDate);
htRepurchaseRegInfo.Add("SL_TR_NO", dtSaleTrInfo.Rows[loop]["SL_TR_NO"]);
htRepurchaseRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htRepurchaseRegInfo.Add("REG_NO", regObj.RegNumber.ToString());
htRepurchaseRegInfo.Add("REP_PRICE", repObj.RepurchaseRate);
htRepurchaseRegInfo.Add("QTY", dtSaleTrInfo.Rows[loop]["SURRENDER_UNITS"]);
htRepurchaseRegInfo.Add("PAY_TYPE", repObj.PayType.ToString().ToUpper());
htRepurchaseRegInfo.Add("USER_NM", unitUserObj.UserID.ToString());
htRepurchaseRegInfo.Add("ENT_DT", DateTime.Now.ToString());
htRepurchaseRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
commonGatewayObj.Insert(htRepurchaseRegInfo, "REPURCHASE");
}
}
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(moneyReceipDropDownList.SelectedItem.Text.ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
commonGatewayObj.BeginTransaction();
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Surrender Value con not be equal or less than Zero');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
int CheckCount = 0;
long surrenderCheckUnit = 0;
DataTable dtGrid = opendMFDAO.getTableDataGridCDS();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
TextBox SL_TR_NOTxt = (TextBox)gridRow.FindControl("SL_TR_NoTextBox");
TextBox SURRENDER_UNITSTxt = (TextBox)gridRow.FindControl("Sale_UnitsTextBox");
TextBox EXIST_UNITSTxt = (TextBox)gridRow.FindControl("Exist_UnitsTextBox");
drGrid = dtGrid.NewRow();
drGrid["SL_TR_NO"] = SL_TR_NOTxt.Text.Trim().ToString();
drGrid["SURRENDER_UNITS"] = SURRENDER_UNITSTxt.Text.Trim().ToString();
drGrid["EXIST_UNITS"] = EXIST_UNITSTxt.Text.Trim().ToString();
dtGrid.Rows.Add(drGrid);
surrenderCheckUnit = surrenderCheckUnit + Convert.ToInt64(SURRENDER_UNITSTxt.Text.Trim().ToString());
CheckCount++;
}
}
if (CheckCount == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: No Surrender Units Selected');", true);
}
else if (surrenderCheckUnit != Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Selected Units Mis Match to Actual Surrender Units');", true);
}
else if ((CheckCount > 0) && (surrenderCheckUnit != Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString())))
{
commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + unitRepObj.RepurchaseNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString()));
unitRepBLObj.saveRepurchaseCDS(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
commonGatewayObj.CommitTransaction();
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'REP' AND SL_REP_TR_RN_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Ambiguous Situation');", true);
}
}
}
else
{
ClearText();
commonGatewayObj.RollbackTransaction();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void ShowReportButton_Click(object sender, EventArgs e)
{
try
{
//StringBuilder sbRepurchase = new StringBuilder();
//sbRepurchase.Append("SELECT SUM(QTY) AS QTY, SUM(QTY * REP_PRICE) AS AMOUNT FROM (SELECT REPURCHASE.REP_NO, REPURCHASE.REP_DT, REPURCHASE.QTY, U_MASTER.HNAME, REPURCHASE.SL_TR_NO, ");
//sbRepurchase.Append(" ");
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(fromRepNoTextBox.Text.Trim().ToString());
StringBuilder sbMaster = new StringBuilder();
StringBuilder sbFilter = new StringBuilder();
DataTable dtReportStatement = new DataTable();
StringBuilder sbReportString = new StringBuilder();
string copy = fundCodeTextBox.Text.ToString() + " Copy";
if (accoountRadioButton.Checked)
{
copy = "Accounts Copy";
}
sbMaster.Append("SELECT NVL(REPURCHASE.REP_NO,0) AS REP_NO , TO_CHAR(REPURCHASE.REP_DT, 'DD-MON-YYYY') AS REP_DT, U_MASTER.REG_BK, U_MASTER.REG_BR, U_MASTER.REG_NO AS RG_NO, ");
sbMaster.Append(" U_MASTER.HNAME, U_JHOLDER.JNT_NAME, U_MASTER.REG_BK || '/' || U_MASTER.REG_BR || '/' || U_MASTER.REG_NO AS REG_NO,U_MASTER.TIN,U_MASTER.BO,");
sbMaster.Append(" U_MASTER.ADDRS1, U_MASTER.ADDRS2, U_MASTER.CITY, U_MASTER.BK_AC_NO,U_MASTER.BK_NM_CD,U_MASTER.ID_FLAG,U_MASTER.ID_BK_NM_CD, U_MASTER.ID_BK_BR_NM_CD,");
sbMaster.Append(" U_MASTER.BK_BR_NM_CD, U_MASTER.BK_FLAG,REPURCHASE.QTY, REPURCHASE.REP_PRICE AS RATE, REPURCHASE.QTY * REPURCHASE.REP_PRICE AS AMOUNT, REPURCHASE.SL_TR_NO, U_MASTER.CIP, U_MASTER.ID_AC,");
sbMaster.Append(" DECODE(REPURCHASE.PAY_TYPE,'EFT','BEFTN','CHEQUE') AS PAY_TYPE ");
sbMaster.Append(" FROM U_MASTER INNER JOIN REPURCHASE ON U_MASTER.REG_BK = REPURCHASE.REG_BK AND U_MASTER.REG_BR = REPURCHASE.REG_BR AND U_MASTER.REG_NO = REPURCHASE.REG_NO");
sbMaster.Append(" LEFT OUTER JOIN U_JHOLDER ON U_MASTER.REG_BK = U_JHOLDER.REG_BK AND U_MASTER.REG_BR = U_JHOLDER.REG_BR AND U_MASTER.REG_NO = U_JHOLDER.REG_NO");
sbMaster.Append(" WHERE 1=1");
sbMaster.Append(" AND (U_MASTER.REG_BK = '" + fundCodeTextBox.Text.Trim().ToString().ToUpper() + "') AND (U_MASTER.REG_BR = '" + branchCodeTextBox.Text.Trim().ToString().ToUpper() + "')");
if (fromRepNoTextBox.Text != "")
{
sbFilter.Append(" AND (REPURCHASE.REP_NO = " + Convert.ToInt32(fromRepNoTextBox.Text.Trim().ToString()) + ")");
}
if (fromRegNoTextBox.Text != "")
{
sbFilter.Append(" AND (U_MASTER.REG_NO = " + Convert.ToInt32(fromRegNoTextBox.Text.Trim().ToString()) + ")");
}
if (fromRepDateTextBox.Text != "")
{
sbFilter.Append(" AND ( REPURCHASE.REP_DT ='" + Convert.ToDateTime(fromRepDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')");
}
sbFilter.Append(" ORDER BY TO_NUMBER(SUBSTR(REPURCHASE.SL_TR_NO,2)) ");
sbMaster.Append(sbFilter.ToString());
dtReportStatement = commonGatewayObj.Select(sbMaster.ToString());
if (dtReportStatement.Rows.Count > 0)
{
string holderName = dtReportStatement.Rows[0]["HNAME"].ToString().ToUpper();
if (dtReportStatement.Rows[0]["BK_FLAG"].ToString().ToUpper() == "N" || dtReportStatement.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('Please Update Bank Information');", true);
}
else if ((dtReportStatement.Rows[0]["ID_FLAG"].ToString().ToUpper() == "Y") && (dtReportStatement.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["ID_BK_BR_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["ID_AC"].Equals(DBNull.Value)))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('Please Update ID Information');", true);
}
else
{
if (dtReportStatement.Rows[0]["ID_FLAG"].ToString().ToUpper() == "Y")
{
holderName = reportObj.getBankNameByBankCode(Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_NM_CD"].ToString())).ToString() + " , " + reportObj.getBankBranchNameByCode(Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_NM_CD"].ToString()), Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_BR_NM_CD"].ToString())).ToString() + " ID NO:" + dtReportStatement.Rows[0]["ID_AC"].ToString().ToUpper();
}
string BankInfo = ", bank account no : " + dtReportStatement.Rows[0]["BK_AC_NO"].ToString().ToUpper() + " , " + reportObj.getBankNameByBankCode(int.Parse(dtReportStatement.Rows[0]["BK_NM_CD"].ToString())) + "," + " " + reportObj.getBankBranchNameByCode(int.Parse(dtReportStatement.Rows[0]["BK_NM_CD"].ToString()), int.Parse(dtReportStatement.Rows[0]["BK_BR_NM_CD"].ToString()));
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtReportStatement.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtReportStatement.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
BankInfo = BankInfo + " [ " + dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString() + "] ";
}
// string BankInfo = "";
decimal totalRepAmount = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
totalRepAmount = totalRepAmount + Convert.ToDecimal(dtReportStatement.Rows[looper]["AMOUNT"].ToString());
}
if (NoRadioButton.Checked)
{
string payType = unitRepBLObj.getPayType(regObj, unitRepObj);
if (payType.ToString() == "EFT")
{
sbReportString.Append(" Through BEFTN Tk. " + totalRepAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(totalRepAmount) + " ) ");
sbReportString.Append(" be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + "" + BankInfo);
sbReportString.Append(" being the surrended value of units. ");
}
else
{
sbReportString.Append(" An account payee cheque for Tk. " + totalRepAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(totalRepAmount) + " ) ");
sbReportString.Append(" be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + "" + BankInfo);
sbReportString.Append(" being the surrended value of units. ");
}
}
else if (YesRadioButton.Checked)
{
decimal lienAmount = Convert.ToDecimal(LienAmountTextBox.Text.Trim().ToString());
decimal remainingAmount = totalRepAmount - lienAmount;
sbReportString.Append("According to the letter no: " + LienReqRefTextBox.Text.Trim().ToString() + " dated on " + LienReqDateTextBox.Text.Trim().ToString() + ", the above certificates are ");
sbReportString.Append(" surrendered by " + LienbankNameDropDownList.SelectedItem.Text.ToString() + ", " + LienbranchNameDropDownList.SelectedItem.Text.ToString() + " . An account payee cheque for Tk. " + lienAmount.ToString("#,##0.00") + " ( Taka ");
sbReportString.Append(numberToEnglishObj.changeNumericToWords(lienAmount).ToString() + " ) be issued in favour of " + LienbankNameDropDownList.SelectedItem.Text.ToString() + " , " + LienbranchNameDropDownList.SelectedItem.Text.ToString());
sbReportString.Append(" and another account payee cheque of remaining amout for Tk. " + remainingAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(remainingAmount));
sbReportString.Append(" ) be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + BankInfo + " being the surrended value of units. ");
}
Session["dtReportStatement"] = dtReportStatement;
Session["fundCode"] = fundCodeTextBox.Text.Trim().ToString();
Session["branchCode"] = branchCodeTextBox.Text.Trim().ToString();
Session["sbReportString"] = sbReportString.ToString();
Session["copy"] = copy;
// ClientScript.RegisterStartupScript(this.GetType(), "UnitHolderInfo", "window.open('ReportViewer/UnitReportRepurchaseVoucherReportViewer.aspx')", true);
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "UnitHolderInfo", "window.open('ReportViewer/UnitReportRepurchaseVoucherReportViewer.aspx')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('No data found');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
