protected void SaveButton_Click(object sender, EventArgs e)
{
Hashtable htPriceRefixation = new Hashtable();
try
{
commonGatewayObj.BeginTransaction();
htPriceRefixation.Add("FUND_CD", fundNameDropDownList.SelectedValue.ToString().ToUpper());
htPriceRefixation.Add("FUND_NM", opendMFDAO.GetFundName(fundNameDropDownList.SelectedValue.ToString()));
htPriceRefixation.Add("REFIX_DT", Convert.ToDateTime(PriceDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
htPriceRefixation.Add("REFIX_SL_PR", Convert.ToDecimal(SalePriceTextBox.Text.Trim().ToString()));
htPriceRefixation.Add("REFIX_REP_PR", Convert.ToDecimal(RepPriceTextBox.Text.Trim().ToString()));
htPriceRefixation.Add("USER_NM", userObj.UserID.ToString());
htPriceRefixation.Add("ENT_DT", DateTime.Today.ToString("dd-MMM-yyyy"));
htPriceRefixation.Add("ENT_TM", DateTime.Now.ToShortTimeString());
commonGatewayObj.Insert(htPriceRefixation, "PRICE_REFIX");
commonGatewayObj.CommitTransaction();
PriceDateTextBox.Text = "";
SalePriceTextBox.Text = "";
RepPriceTextBox.Text = "";
fundNameDropDownList.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
public void InsertHowlaData(DataTable dtTradeCusData)
{
if (dtTradeCusData.Rows.Count > 0)
{
try
{
//long SI = Convert.ToInt32(dividendDAOObj.GetMaxSI("CDBL_DATA", "ID")) + 1;
int numberOfRows = 0;
commonGatewayObj.BeginTransaction();
Hashtable htTradeCusData = new Hashtable();
for (int loop = 0; loop < dtTradeCusData.Rows.Count; loop++)
{
//htTradeCusData.Add("ID", SI);
htTradeCusData.Add("F_CD", Convert.ToInt32(dtTradeCusData.Rows[loop]["F_CD"].ToString()));
htTradeCusData.Add("SP_DATE", dtTradeCusData.Rows[loop]["SP_DATE"].ToString());
htTradeCusData.Add("BK_REF", dtTradeCusData.Rows[loop]["BK_REF"].ToString().ToUpper());
htTradeCusData.Add("HOWLA_NO", dtTradeCusData.Rows[loop]["HOWLA_NO"].ToString());
htTradeCusData.Add("HOWLA_TP", dtTradeCusData.Rows[loop]["HOWLA_TP"].ToString());
htTradeCusData.Add("IN_OUT", dtTradeCusData.Rows[loop]["IN_OUT"].ToString().ToUpper());
htTradeCusData.Add("SETTLE_DT", dtTradeCusData.Rows[loop]["SETTLE_DT"].ToString());
htTradeCusData.Add("COMP_CD", Convert.ToInt32(dtTradeCusData.Rows[loop]["COMP_CD"].ToString()));
htTradeCusData.Add("SP_QTY", dtTradeCusData.Rows[loop]["SP_QTY"].ToString());
htTradeCusData.Add("SP_RATE", dtTradeCusData.Rows[loop]["SP_RATE"].ToString());
htTradeCusData.Add("CL_DATE", dtTradeCusData.Rows[loop]["CL_DATE"].ToString());
htTradeCusData.Add("BK_CD", dtTradeCusData.Rows[loop]["BK_CD"].ToString());
htTradeCusData.Add("HOWLA_CHG", dtTradeCusData.Rows[loop]["HOWLA_CHG"].ToString());
htTradeCusData.Add("LAGA_CHG", dtTradeCusData.Rows[loop]["LAGA_CHG"].ToString());
htTradeCusData.Add("VOUCH_REF", dtTradeCusData.Rows[loop]["VOUCH_REF"].ToString());
htTradeCusData.Add("OP_NAME", dtTradeCusData.Rows[loop]["OP_NAME"].ToString());
htTradeCusData.Add("N_P", dtTradeCusData.Rows[loop]["N_P"].ToString());
htTradeCusData.Add("ISIN_CD", dtTradeCusData.Rows[loop]["ISIN_CD"].ToString());
htTradeCusData.Add("FORGN_FLG", dtTradeCusData.Rows[loop]["FORGN_FLG"].ToString());
htTradeCusData.Add("SPOT_ID", dtTradeCusData.Rows[loop]["SPOT_ID"].ToString());
htTradeCusData.Add("INSTR_GRP", dtTradeCusData.Rows[loop]["INSTR_GRP"].ToString());
htTradeCusData.Add("MARKT_TP", dtTradeCusData.Rows[loop]["MARKT_TP"].ToString());
htTradeCusData.Add("CUSTOMER", dtTradeCusData.Rows[loop]["CUSTOMER"].ToString());
htTradeCusData.Add("BOID", dtTradeCusData.Rows[loop]["BOID"].ToString());
commonGatewayObj.Insert(htTradeCusData, "TEST.HOWLA");
htTradeCusData = new Hashtable();
// SI++;
numberOfRows++;
}
//Hashtable htDividendParaUpdate = new Hashtable();
//htDividendParaUpdate.Add("IS_UPLOAD_CDBL_DATA", "Y");
//commonGatewayObj.Update(htDividendParaUpdate, "DIVIDEND_PARA", "FUND_CODE=" + Convert.ToInt32(fundNameDropDownList.SelectedValue.ToString()) + " AND FY='" + fyDropDownList.Text.ToString() + "'AND RECORD_DATE='" + recordDateDropDownList.Text.ToString() + "'");
commonGatewayObj.CommitTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + numberOfRows + " Record(s) Save Successfully');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.ToString() + "');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found.');", true);
}
}
public void InsertCdblData(DataTable dtCDBLdata)
{
try
{
long SI = commonGatewayObj.GetMaxNo("CDBL_DATA", "ID") + 1;
commonGatewayObj.BeginTransaction();
Hashtable htCdblData = new Hashtable();
for (int loop = 0; loop < dtCDBLdata.Rows.Count; loop++)
{
htCdblData.Add("ID", SI);
htCdblData.Add("FUND_CODE", fundNameDropDownList.SelectedValue.ToString());
htCdblData.Add("DIVI_NO", ClosingDateDropDownList.SelectedValue.ToString());
htCdblData.Add("FY", DividendFYDropDownList.SelectedItem.Text);
htCdblData.Add("RECORD_DATE", ClosingDateDropDownList.SelectedItem.Text);
htCdblData.Add("BO", dtCDBLdata.Rows[loop]["BO"]);
htCdblData.Add("NAME1", dtCDBLdata.Rows[loop]["NAME1"]);
htCdblData.Add("BALANCE", dtCDBLdata.Rows[loop]["BALANCE"]);
htCdblData.Add("BO_TYPE", dtCDBLdata.Rows[loop]["BO_TYPE"]);
htCdblData.Add("BO_CATAGORY", dtCDBLdata.Rows[loop]["BO_CATAGORY"]);
htCdblData.Add("ADDRESS1", dtCDBLdata.Rows[loop]["ADDRESS1"]);
htCdblData.Add("ADDRESS2", dtCDBLdata.Rows[loop]["ADDRESS2"]);
htCdblData.Add("ADDRESS3", dtCDBLdata.Rows[loop]["ADDRESS3"]);
htCdblData.Add("CITY", dtCDBLdata.Rows[loop]["CITY"]);
htCdblData.Add("COUNTRY", dtCDBLdata.Rows[loop]["COUNTRY"]);
htCdblData.Add("POST_CODE", dtCDBLdata.Rows[loop]["POST_CODE"]);
htCdblData.Add("PHONE1", dtCDBLdata.Rows[loop]["PHONE1"]);
htCdblData.Add("PHONE2", dtCDBLdata.Rows[loop]["PHONE2"]);
htCdblData.Add("RESIDENCY", dtCDBLdata.Rows[loop]["RESIDENCY"]);
htCdblData.Add("BANK", dtCDBLdata.Rows[loop]["BANK_NAME"]);
htCdblData.Add("BRANCH", dtCDBLdata.Rows[loop]["BRANCH_NAME"]);
htCdblData.Add("BANK_ACC", dtCDBLdata.Rows[loop]["BANK_ACC_NO"]);
htCdblData.Add("ROUTING_NO", dtCDBLdata.Rows[loop]["ROUTING_NO"]);
htCdblData.Add("NAME2", dtCDBLdata.Rows[loop]["NAME2"]);
htCdblData.Add("GENDER", dtCDBLdata.Rows[loop]["GENDER"]);
htCdblData.Add("BO_NATIONALITY", dtCDBLdata.Rows[loop]["BO_NATIONALITY"]);
htCdblData.Add("ETIN", dtCDBLdata.Rows[loop]["ETIN"]);
htCdblData.Add("IS_VALID_ETIN", dtCDBLdata.Rows[loop]["IS_VALID_ETIN"]);
htCdblData.Add("REG_BK", dtCDBLdata.Rows[loop]["REG_BK"]);
htCdblData.Add("REG_BR", dtCDBLdata.Rows[loop]["REG_BR"]);
htCdblData.Add("REG_NO", dtCDBLdata.Rows[loop]["REG_NO"]);
htCdblData.Add("NO_OF_REGNO", dtCDBLdata.Rows[loop]["NO_OF_REGNO"]);
commonGatewayObj.Insert(htCdblData, "CDBL_DATA");
htCdblData = new Hashtable();
SI++;
}
Hashtable htDividendParaUpdate = new Hashtable();
//htDividendParaUpdate.Add("IS_UPLOAD_CDBL_DATA", "Y");
// commonGatewayObj.Update(htDividendParaUpdate, "DIVIDEND_PARA", "FUND_CODE=" + Convert.ToInt32(fundNameDropDownList.SelectedValue.ToString()) + " AND FY='" + fyDropDownList.Text.ToString() + "'AND RECORD_DATE='" + recordDateDropDownList.Text.ToString() + "'");
commonGatewayObj.CommitTransaction();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('CDBL Data Save Successfully');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.ToString() + "');", true);
}
}
protected void updatePriceButton_Click(object sender, EventArgs e)
{
string closingPriceDate = closingPriceDateTextBox.Text.ToString();
if (closingPriceDate == updateTillTextBox.Text.ToString())
{
closingPriceDateTextBox.Focus();
Response.Redirect("Process.aspx");
//ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Don't Click Reload/Refresh Button!! Closing Price Already Updated.');", true);
}
else
{
//string closingPriceDate = closingPriceDateTextBox.Text.ToString();
DataTable dtSelectQuery = new DataTable();
StringBuilder sbMst = new StringBuilder();
StringBuilder sbfilter = new StringBuilder();
sbfilter.Append(" ");
sbMst.Append("SELECT COMP.COMP_CD, PUB_TRANS.* FROM COMP INNER JOIN PUB_TRANS ON COMP.INSTR_CD = PUB_TRANS.INST_CD WHERE(PUB_TRANS.TRANS_DT ='" + Convert.ToDateTime(closingPriceDate).ToString("dd-MMM-yyyy") + "')");
sbMst.Append(sbfilter.ToString());
dtSelectQuery = commonGatewayObj.Select(sbMst.ToString());
if (dtSelectQuery.Rows.Count > 0)
{
long id = 0;
Hashtable htDseClosingPrice = new Hashtable();
for (int looper = 0; looper < dtSelectQuery.Rows.Count; looper++)
{
id = seqObj.Sequence("dse_closing_price_seq");
htDseClosingPrice = new Hashtable();
htDseClosingPrice.Add("ID", id);
htDseClosingPrice.Add("COMP_CD", Convert.ToInt32(dtSelectQuery.Rows[looper]["COMP_CD"].ToString()));
htDseClosingPrice.Add("INST_CD", dtSelectQuery.Rows[looper]["INST_CD"].ToString());
htDseClosingPrice.Add("OPEN", Convert.ToDecimal(dtSelectQuery.Rows[looper]["OPEN"].ToString()));
htDseClosingPrice.Add("HIGH", Convert.ToDecimal(dtSelectQuery.Rows[looper]["HIGH"].ToString()));
htDseClosingPrice.Add("LOW", Convert.ToDecimal(dtSelectQuery.Rows[looper]["LOW"].ToString()));
htDseClosingPrice.Add("CLOSE", Convert.ToDecimal(dtSelectQuery.Rows[looper]["CLOSE"].ToString()));
htDseClosingPrice.Add("CHG", Convert.ToDecimal(dtSelectQuery.Rows[looper]["CHG"].ToString()));
htDseClosingPrice.Add("TRADE", Convert.ToDecimal(dtSelectQuery.Rows[looper]["TRADE"].ToString()));
htDseClosingPrice.Add("VOL", Convert.ToDecimal(dtSelectQuery.Rows[looper]["VOL"].ToString()));
htDseClosingPrice.Add("VAL", Convert.ToDecimal(dtSelectQuery.Rows[looper]["VAL"].ToString()));
htDseClosingPrice.Add("TRANS_DT", Convert.ToDateTime(dtSelectQuery.Rows[looper]["TRANS_DT"]).ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(htDseClosingPrice, "DSE_CLOSING_PRICE");
}
MaxDate();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Closing Price Updeated Successfully!');", true);
//ClientScript.RegisterStartupScript(this.GetType(), "download", "window.opener.fnRefresh();", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('No Data Found!');", true);
}
}
}
protected void savetButton_Click(object sender, EventArgs e)
{
try
{
if (unitRepprtObj.CheckDuplicate(refixationDateTextBox.Text))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert('Save Failed: Duplicate Price Refixaton Date');", true);
}
else
{
Hashtable htInsert = new Hashtable();
int countCheck = 0;
commonGatewayObj.BeginTransaction();
foreach (GridViewRow Drv in SurrenderListGridView.Rows)
{
htInsert.Add("NAV_DATE", NAVDateTextBox.Text);
htInsert.Add("REFIX_DT", refixationDateTextBox.Text);
htInsert.Add("FUND_CD", Drv.Cells[0].Text.ToString());
htInsert.Add("FUND_NM", Drv.Cells[1].Text.ToString());
TextBox effectDateTextBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("effectDateTextBox");
TextBox salePriceTextBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("salePriceTextBox");
TextBox surrenderPriceTextBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("surrenderPriceTextBox");
TextBox navMPTextBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("navMPTextBox");
TextBox navCPTextBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("navCPTextBox");
htInsert.Add("EFFECTIVE_DATE", Convert.ToDateTime(effectDateTextBox.Text).ToString("dd-MMM-yyyy"));
htInsert.Add("REFIX_SL_PR", Convert.ToDecimal(salePriceTextBox.Text.ToString()));
htInsert.Add("REFIX_REP_PR", Convert.ToDecimal(surrenderPriceTextBox.Text.ToString()));
htInsert.Add("NAV_MP", Convert.ToDecimal(navMPTextBox.Text.ToString()));
htInsert.Add("NAV_CP", Convert.ToDecimal(navCPTextBox.Text.ToString()));
htInsert.Add("USER_NM", userObj.UserID.ToString());
htInsert.Add("ENT_DT", DateTime.Today.ToString("dd-MMM-yyyy"));
htInsert.Add("ENT_TM", DateTime.Now.ToShortTimeString());
commonGatewayObj.Insert(htInsert, "PRICE_REFIX");
commonGatewayObj.CommitTransaction();
htInsert = new Hashtable();
countCheck++;
}
}
refixationDateTextBox.Text = "";
NAVDateTextBox.Text = "";
dvGridSurrender.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert('Save Successfully');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
private void InsertData()
{
Hashtable httable = new Hashtable();
httable.Add("comp_cd", Convert.ToInt16(companyCodeTextBox.Text));
httable.Add("fy", financialYearTextBox.Text.ToString());
if (!recordDateTextBox.Text.Equals(""))
{
httable.Add("RECORD_DT", Convert.ToDateTime(recordDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!bookToTextBox.Text.Equals(""))
{
httable.Add("BOOK_TO", Convert.ToDateTime(bookToTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!stockTextBox.Text.Equals(""))
{
httable.Add("BONUS", Convert.ToDecimal(stockTextBox.Text));
}
if (!rightApprovalDateTextBox.Text.Equals(""))
{
httable.Add("RIGHT_APPR_DT", Convert.ToDateTime(rightApprovalDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!rightTextBox.Text.Equals(""))
{
httable.Add("RIGHT", Convert.ToDecimal(rightTextBox.Text));
}
if (!cashTextBox.Text.Equals(""))
{
httable.Add("CASH", Convert.ToDecimal(cashTextBox.Text));
}
if (!agmDateTextBox.Text.Equals(""))
{
httable.Add("AGM", Convert.ToDateTime(agmDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!remarksTextBox.Text.Equals(""))
{
httable.Add("REMARKS", remarksTextBox.Text.ToString());
}
if (!postedTextBox.Text.Equals(""))
{
httable.Add("POSTED", postedTextBox.Text.ToString());
}
if (!postedDateTextBox.Text.Equals(""))
{
httable.Add("PDATE", Convert.ToDateTime(postedDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
httable.Add("ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(httable, "book_cl");
ClearFields();
//ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Data Saved Successfully.');", true);
}
/// <summary>
/// Mathod for Inserting Individual Fund's Asset Value to the Database.
/// </summary>
void InsertAssetValue()
{
DataTable dtFundName = GetFundName();
int iteration = 0;
int noOfInsertRows = 0;
int msg = 0;
Hashtable htAssetValueInfo = new Hashtable();
foreach (DataGridItem growFund in grdShowFund.Items)
{
CheckBox chkFundItem = (CheckBox)growFund.FindControl("chkFund");
if (chkFundItem.Checked)
{
htAssetValueInfo = new Hashtable();
htAssetValueInfo.Add("F_CD", Convert.ToInt32(dtFundName.Rows[iteration]["F_CD"].ToString()));
htAssetValueInfo.Add("F_NAME", (dtFundName.Rows[iteration]["F_NAME"]).ToString());
htAssetValueInfo.Add("ASSET_VALUE", Convert.ToDouble(((TextBox)growFund.FindControl("assetValueTextBox")).Text));
try
{
noOfInsertRows = noOfInsertRows + commonGatewayObj.Insert(htAssetValueInfo, "ASSET_VALUE");
msg = 1;
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
msg = 0;
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Asset Value Insert Failed!!" + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
iteration++;
}
if (msg == 1)
{
commonGatewayObj.CommitTransaction();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + noOfInsertRows + " Asset Value Inserted Successfully');", true);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
string LoginID = Session["UserID"].ToString();
//string LoginName = Session["UserName"].ToString().ToUpper();
Hashtable httable = new Hashtable();
httable.Add("ID", Convert.ToInt32(pf1s1DAOObj.getMaxIDForNonListedSecurities() + 1));
if (!fundNameDropDownList.SelectedValue.Equals("0"))
{
httable.Add("F_CD", Convert.ToInt16(fundNameDropDownList.SelectedValue));
}
if (!amountTextBox.Text.Equals(""))
{
httable.Add("INV_AMOUNT", Convert.ToDouble(amountTextBox.Text));
}
httable.Add("INV_DATE", Convert.ToDateTime(PortfolioAsOnDropDownList.Text).ToString("dd-MMM-yyyy"));
httable.Add("ENTRY_BY", LoginID);
httable.Add("ENTRY_DATE", DateTime.Now);
if (pf1s1DAOObj.IsDuplicateNonListedSecurities(Convert.ToInt32(fundNameDropDownList.SelectedValue.ToString()), Convert.ToDecimal(amountTextBox.Text.Trim().ToString()), Convert.ToDateTime(PortfolioAsOnDropDownList.Text.Trim().ToString()).ToString("dd-MMM-yyyy")))
{
//ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed: You Are Trying to Duplicate entry.');", true);
string updateMsgNonlistedSecurites = UpdateAmmountInNonlisted(fundNameDropDownList.SelectedValue.ToString(), PortfolioAsOnDropDownList.Text.ToString(), amountTextBox.Text.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Data Updated Successfully');", true);
ClearFields();
}
else
{
commonGatewayObj.Insert(httable, "NON_LISTED_SECURITIES");
ClearFields();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
}
fundNameDropDownList.Focus();
}
protected void processButton_Click(object sender, EventArgs e)
{
DataTable dtBankBranchInfo = commonGatewayObj.Select("SELECT * FROM BANK_BRANCH_BB WHERE BANK_CODE=" + Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()) + " AND IS_PROCE_COMP IS NULL ORDER BY BRANC_NAME");
if (dtBankBranchInfo.Rows.Count > 0)
{
try
{
Hashtable htInsertBankBranch = new Hashtable();
Hashtable htUpdateBankBranch = new Hashtable();
Hashtable htUpdateBankBranchBB = new Hashtable();
string branchName = "";
int Bank_code = 0;
for (int loop = 0; loop < dtBankBranchInfo.Rows.Count; loop++)
{
branchName = dtBankBranchInfo.Rows[loop]["BRANC_NAME"].ToString();
Bank_code = Convert.ToInt32(dtBankBranchInfo.Rows[loop]["BANK_CODE"].ToString());
if (ISBranchExist(branchName, Bank_code))
{
htUpdateBankBranch = new Hashtable();
htUpdateBankBranch.Add("BANK_CODE_BB", dtBankBranchInfo.Rows[loop]["BANK_CODE_BB"].ToString());
htUpdateBankBranch.Add("BRANCH_CODE_BB", dtBankBranchInfo.Rows[loop]["BRANCH_CODE_BB"].ToString());
htUpdateBankBranch.Add("DIST_CODE", dtBankBranchInfo.Rows[loop]["DIST_CODE"].ToString());
htUpdateBankBranch.Add("ROUTING_NO", dtBankBranchInfo.Rows[loop]["ROUTING_NO"].ToString());
htUpdateBankBranch.Add("BRANCH_DISTRICT", dtBankBranchInfo.Rows[loop]["DISTRICT"].ToString());
commonGatewayObj.Update(htUpdateBankBranch, "BANK_BRANCH", "BRANCH_NAME='" + branchName.ToString() + "' AND BANK_CODE=" + Bank_code);
}
else
{
htInsertBankBranch = new Hashtable();
htInsertBankBranch.Add("BANK_CODE", Bank_code);
htInsertBankBranch.Add("BRANCH_CODE", getMaxBranchCode(Bank_code));
htInsertBankBranch.Add("BRANCH_NAME", dtBankBranchInfo.Rows[loop]["BRANC_NAME"].ToString());
htInsertBankBranch.Add("BANK_CODE_BB", dtBankBranchInfo.Rows[loop]["BANK_CODE_BB"].ToString());
htInsertBankBranch.Add("BRANCH_CODE_BB", dtBankBranchInfo.Rows[loop]["BRANCH_CODE_BB"].ToString());
htInsertBankBranch.Add("DIST_CODE", dtBankBranchInfo.Rows[loop]["DIST_CODE"].ToString());
htInsertBankBranch.Add("ROUTING_NO", dtBankBranchInfo.Rows[loop]["ROUTING_NO"].ToString());
htInsertBankBranch.Add("BRANCH_DISTRICT", dtBankBranchInfo.Rows[loop]["DISTRICT"].ToString());
commonGatewayObj.Insert(htInsertBankBranch, "BANK_BRANCH");
}
htUpdateBankBranchBB = new Hashtable();
htUpdateBankBranchBB.Add("IS_PROCE_COMP", "Y");
commonGatewayObj.Update(htUpdateBankBranchBB, "BANK_BRANCH_BB", "BRANC_NAME='" + branchName.ToString() + "' AND BANK_CODE=" + Bank_code);
}
commonGatewayObj.CommitTransaction();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('Complete Successfylly');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
//errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('Error');", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('No Data Found or Process is completed');", true);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
string LoginID = Session["UserID"].ToString();
string LoginName = Session["UserName"].ToString().ToUpper();
string record_date = recordDateTextBox.Text.ToString();
string recordate;
DateTime?dtrecoddate;
if (!string.IsNullOrEmpty(record_date))
{
dtrecoddate = Convert.ToDateTime(record_date);
recordate = dtrecoddate.Value.ToString("dd-MMM-yyyy");
}
else
{
dtrecoddate = null;
recordate = "";
}
Hashtable httable = new Hashtable();
httable.Add("VCH_DT", Convert.ToDateTime(howlaDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
if (!stockExchangeDropDownList.SelectedValue.Equals("0"))
{
httable.Add("STOCK_EX", Convert.ToChar(stockExchangeDropDownList.SelectedValue));
}
if (!fundNameDropDownList.SelectedValue.Equals("0"))
{
httable.Add("F_CD", Convert.ToInt16(fundNameDropDownList.SelectedValue));
}
if (!companyNameDropDownList.SelectedValue.Equals("0"))
{
httable.Add("COMP_CD", Convert.ToInt16(companyNameDropDownList.SelectedValue));
}
if (!transTypeDropDownList.SelectedValue.Equals("0"))
{
httable.Add("TRAN_TP", Convert.ToChar(transTypeDropDownList.SelectedValue));
}
if (!noOfShareTextBox.Text.Equals(""))
{
httable.Add("NO_SHARE", Convert.ToDouble(noOfShareTextBox.Text));
}
if (!amountTextBox.Text.Equals(""))
{
httable.Add("AMOUNT", Convert.ToDouble(amountTextBox.Text));
}
if (!voucherNoTextBox.Text.Equals(""))
{
httable.Add("VCH_NO", (voucherNoTextBox.Text).ToString());
}
if (!rateTextBox.Text.Equals(""))
{
httable.Add("RATE", Convert.ToDouble(rateTextBox.Text));
}
if (!amountAfterComissionTextBox.Text.Equals(""))
{
httable.Add("AMT_AFT_COM", Convert.ToDouble(amountAfterComissionTextBox.Text));
}
//httable.Add("ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
httable.Add("OP_NAME", LoginID);
if (pf1s1DAOObj.IsDuplicateBonusRightEntry(Convert.ToInt32(fundNameDropDownList.SelectedValue.ToString()), Convert.ToInt32(companyNameDropDownList.SelectedValue.ToString()), Convert.ToDateTime(howlaDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy"), transTypeDropDownList.SelectedValue.ToString(), Convert.ToInt32(noOfShareTextBox.Text.Trim().ToString())))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Duplicate not allowed');", true);
}
else
{
if (transTypeDropDownList.SelectedValue == "B")
{
if (stockExchangeDropDownList.SelectedValue == "A")
{
if (!recordate.Equals(""))
{
httable.Add("RECORD_DT", recordate);
}
string strQbooKCL = "SELECT COMP_CD, FY, RECORD_DT, BOOK_TO, BONUS, RIGHT_APPR_DT, RIGHT, CASH, AGM, REMARKS, POSTED, PDATE, ENTRY_DATE FROM BOOK_CL WHERE COMP_CD=" + companyNameDropDownList.SelectedValue + " AND RECORD_DT='" + recordate + "'" + " and posted is null";
DataTable dtbookCl = commonGatewayObj.Select(strQbooKCL);
if (dtbookCl != null && dtbookCl.Rows.Count > 0)
{
string strRecordateFT = "SELECT VCH_DT, F_CD, COMP_CD, TRAN_TP, VCH_NO, NO_SHARE, RATE, COST_RATE, CRT_AFT_COM, AMOUNT, AMT_AFT_COM, STOCK_EX, OP_NAME, PVCH_NO, RECORD_DT FROM FUND_TRANS_HB Where f_cd='" + fundNameDropDownList.SelectedValue.ToString() + "' AND comp_cd=" + companyNameDropDownList.SelectedValue.ToString() + " and RECORD_DT='" + recordate + "'";
DataTable dtRecorDateFT = commonGatewayObj.Select(strRecordateFT);
if (dtRecorDateFT != null && dtRecorDateFT.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Bonus already posted.');", true);
ClearFields();
}
else
{
if (httable["TRAN_TP"].ToString() == "B")
{
commonGatewayObj.Insert(httable, "fund_trans_hb");
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('No data found in Book Closer Entry');", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Please Select Stock Exchange as ALL');", true);
}
}
else if (transTypeDropDownList.SelectedValue == "I")
{
if (httable["TRAN_TP"].ToString() == "I")
{
commonGatewayObj.Insert(httable, "fund_trans_hb");
string strupdateQueryAVgRateFromComp = "update comp set AVG_RT='" + Convert.ToDouble(rateTextBox.Text) + "',CSE_RT='" + Convert.ToDouble(rateTextBox.Text) + "',ADC_RT='" + Convert.ToDouble(rateTextBox.Text) + "' where comp_cd =" + companyNameDropDownList.SelectedValue.ToString() + "";
int updateQueryAVgRateFromCompNumOfRows = commonGatewayObj.ExecuteNonQuery(strupdateQueryAVgRateFromComp);
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Update Successfully');", true);
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
}
}
else
{
commonGatewayObj.Insert(httable, "fund_trans_hb");
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
}
ClearFields();
}
fundNameDropDownList.Focus();
}
protected void PrintSaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
long money_Receipt_ID = 0;
Hashtable htInsertMoneyReceipt = new Hashtable();
try
{
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
if (unitSaleBLObj.CheckDuplicateMoneyReceiptNo(regObj, "TR", Convert.ToInt64(ReceiptNoTextBox.Text.Trim())))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Receipt Number " + "');", true);
}
else
{
money_Receipt_ID = commonGatewayObj.GetMaxNo("MONEY_RECEIPT", "ID") + 1;
commonGatewayObj.BeginTransaction();
htInsertMoneyReceipt.Add("ID", money_Receipt_ID);
htInsertMoneyReceipt.Add("RECEIPT_NO", ReceiptNoTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RECEIPT_TYPE", "TR");
htInsertMoneyReceipt.Add("RECEIPT_DATE", ReceiptDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("REG_BK", fundCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_BR", branchCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_NO", regNoTextBox.Text.Trim());
if (holderBOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BO", holderBOTextBox.Text.Trim());
}
htInsertMoneyReceipt.Add("HNAME", NameTextBox.Text.Trim());
htInsertMoneyReceipt.Add("ADDRESS", addressTextBox.Text.Trim());
htInsertMoneyReceipt.Add("REG_BK_I", fundCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_BR_I", branchCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_NO_I", regNoTextBox.Text.Trim());
if (holderBOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BO_I", holderBOTextBox.Text.Trim());
}
htInsertMoneyReceipt.Add("HNAME_I", NameTextBox.Text.Trim());
htInsertMoneyReceipt.Add("ADDRESS_I", addressTextBox.Text.Trim());
htInsertMoneyReceipt.Add("UNIT_QTY", QtyTextBox.Text.Trim());
htInsertMoneyReceipt.Add("TR_CERT_DELIVERY_DT", DeliveryDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("SL_TR_RN_NO", SaleTRRNNoTextBox.Text.Trim().ToUpper());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_BY", userObj.UserID.ToString());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(htInsertMoneyReceipt, "MONEY_RECEIPT");
commonGatewayObj.CommitTransaction();
ClearText();
Session["MONEY_RECEIPT_ID"] = money_Receipt_ID.ToString();
Session["MONEY_RECEIPT_TYPE"] = "REP";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "window.open('ReportViewer/UnitReportMoneyReceiptReportViewer.aspx');", true);
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
Session["MONEY_RECEIPT_ID"] = null;
Session["MONEY_RECEIPT_TYPE"] = null;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save and print Failed');", true);
}
}
public void SaveSaleUniAccountVoucher(string accountSchema)
{
try
{
int countCheck = 0;
long tranNumber = commonGatewayObj.GetMaxNo(accountSchema + ".GL_BASICINFO", "TRAN_ID");
long contrlNumber = commonGatewayObj.GetMaxNo(accountSchema + ".GL_BASICINFO", "TO_NUMBER(CTRLNO)") - 1;
string acc_op_id = unitRepBLObj.getAcc_OP_ID(fundNameDropDownList.SelectedValue.ToString());
long acc_terminal_no = unitRepBLObj.getAcc_terminal_no(fundNameDropDownList.SelectedValue.ToString());
int faceValue = unitRepBLObj.getUnitFaceValue(fundNameDropDownList.SelectedValue.ToString());
string bankPaymentCode = unitRepBLObj.getUnitBankPaymentCode(fundNameDropDownList.SelectedValue.ToString());
string getUnitFundBankCode = unitRepBLObj.getUnitFundBankCode(fundNameDropDownList.SelectedValue.ToString());
string shareCapitalCode = "101010000";
string premiumReserveCode = "101020000";
string premiumIncomeCode = "302010000";
Hashtable htInsert = new Hashtable();
Hashtable htUpdate = new Hashtable();
commonGatewayObj.BeginTransaction();
DataTable dtFundYearEndInfo = commonGatewayObj.Select("SELECT * FROM FUND_INFO WHERE FUND_CD='" + fundNameDropDownList.SelectedValue.ToString() + "'");
int year = Convert.ToDateTime(TranDateTextBox.Text.ToString()).Year;
int month = Convert.ToDateTime(TranDateTextBox.Text.ToString()).Month;
string yearStartDate = dtFundYearEndInfo.Rows[0]["YEAR_START_MONTH"].ToString();
string yearEndDate = dtFundYearEndInfo.Rows[0]["YEAR_END_MONTH"].ToString();
if (yearStartDate == "01-JUL")
{
if (month < 6)
{
yearEndDate = yearEndDate + "-" + year.ToString();
year--;
yearStartDate = yearStartDate + "-" + year.ToString();
}
else
{
yearStartDate = yearStartDate + "-" + year.ToString();
year++;
yearEndDate = yearEndDate + "-" + year.ToString();
}
}
else
{
yearStartDate = yearStartDate + "-" + year.ToString();
yearEndDate = yearEndDate + "-" + year.ToString();
}
if (unitRepBLObj.IsDuplicateAccVoucherNo(accountSchema, VoucherNoTexBox.Text.Trim(), "2", yearStartDate, yearEndDate))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save Failed Duplicate Payment Voucher Number');", true);
}
else
{
decimal unitSaleQtyCash = 0;
decimal unitSaleTotalValueCash = 0;
string moneyReceiptID = "";
foreach (GridViewRow Drv in SaleListGridView.Rows)
{
decimal unitFaceValue = Convert.ToDecimal(faceValue);
decimal unitSaleQty = Convert.ToDecimal(Drv.Cells[5].Text.ToString());
decimal unitSaleRate = Convert.ToDecimal(Drv.Cells[6].Text.ToString());
decimal unitSaleTotalValue = Convert.ToDecimal(Drv.Cells[7].Text.ToString());
decimal unitRateDiffernceValue = Convert.ToDecimal(Drv.Cells[10].Text.ToString());
decimal totalBankPayment = Convert.ToDecimal(unitSaleRate * unitSaleQty);
decimal totalShareCapital = Convert.ToDecimal(unitFaceValue * unitSaleQty);
decimal totalPremiumIncome = Convert.ToDecimal(unitRateDiffernceValue * unitSaleQty);
decimal totalPremiumReserve = (totalShareCapital + totalPremiumIncome) - totalBankPayment;
if (Drv.Cells[11].Text.ToString().ToUpper() == "CASH")
{
unitSaleQtyCash = unitSaleQtyCash + Convert.ToDecimal(Drv.Cells[5].Text.ToString());
unitSaleTotalValueCash = unitSaleTotalValueCash + Convert.ToDecimal(Drv.Cells[7].Text.ToString());
if (moneyReceiptID == "")
{
moneyReceiptID = moneyReceiptID + Drv.Cells[0].Text.ToString();
}
else
{
moneyReceiptID = moneyReceiptID + "," + Drv.Cells[0].Text.ToString();
}
}
else
{
htUpdate = new Hashtable();
htUpdate.Add("ACC_VOUCHER_ENTRY_BY", userObj.UserID.ToString());
htUpdate.Add("ACC_VOUCHER_ENTRY_DATE", TranDateTextBox.Text.Trim());
htUpdate.Add("ACC_VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
commonGatewayObj.Update(htUpdate, "MONEY_RECEIPT ", "ID=" + Convert.ToInt64(Drv.Cells[0].Text.ToString()));
//Bank Payment
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", bankPaymentCode);
htInsert.Add("BANKACNO", bankPaymentCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalBankPayment);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
if (Drv.Cells[11].Text.ToString().ToUpper() == "BOTH")
{
htInsert.Add("CHEQUENO", Drv.Cells[8].Text.Trim().ToString() + " ,CASH");
htInsert.Add("CHEQUE_DATE", Drv.Cells[9].Text.Trim().ToString());
}
else if (Drv.Cells[11].Text.ToString().ToUpper() == "MULT")
{
}
else
{
htInsert.Add("CHEQUENO", Drv.Cells[8].Text.Trim().ToString());
htInsert.Add("CHEQUE_DATE", Drv.Cells[9].Text.Trim().ToString());
}
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//ShareCapital
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", shareCapitalCode);
htInsert.Add("BANKACNO_CONTRA", shareCapitalCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalShareCapital);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//Premimum Income
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumIncomeCode);
htInsert.Add("BANKACNO_CONTRA", premiumIncomeCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumIncome);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//premium reserve
if (totalPremiumReserve > 0)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumReserveCode);
htInsert.Add("BANKACNO", premiumReserveCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumReserve);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
else if (totalPremiumReserve < 0)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumReserveCode);
htInsert.Add("BANKACNO_CONTRA", premiumReserveCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumReserve * (-1));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
}
countCheck++;
if (countCheck == SaleListGridView.Rows.Count && unitSaleQtyCash > 0 && unitSaleTotalValueCash > 0)
{
decimal totalBankPaymentCash = Convert.ToDecimal(unitSaleRate * unitSaleQtyCash);
decimal totalShareCapitalCash = Convert.ToDecimal(unitFaceValue * unitSaleQtyCash);
decimal totalPremiumIncomeCash = Convert.ToDecimal(unitRateDiffernceValue * unitSaleQtyCash);
decimal totalPremiumReserveCash = (totalShareCapitalCash + totalPremiumIncomeCash) - totalBankPaymentCash;
htUpdate = new Hashtable();
htUpdate.Add("ACC_VOUCHER_ENTRY_BY", userObj.UserID.ToString());
htUpdate.Add("ACC_VOUCHER_ENTRY_DATE", TranDateTextBox.Text.Trim());
htUpdate.Add("ACC_VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
commonGatewayObj.Update(htUpdate, "MONEY_RECEIPT ", "ID IN (" + moneyReceiptID + ")");
//Bank Payment
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", bankPaymentCode);
htInsert.Add("BANKACNO", bankPaymentCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQtyCash.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalBankPaymentCash);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("CHEQUENO", "CASH");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//ShareCapital
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", shareCapitalCode);
htInsert.Add("BANKACNO_CONTRA", shareCapitalCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQtyCash.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalShareCapitalCash);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//Premimum Income
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumIncomeCode);
htInsert.Add("BANKACNO_CONTRA", premiumIncomeCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQtyCash.ToString() + " Unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumIncomeCash);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
//premium reserve
if (totalPremiumReserve > 0)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumReserveCode);
htInsert.Add("BANKACNO", premiumReserveCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQtyCash.ToString() + " unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumReserveCash);
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
else if (totalPremiumReserve < 0)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", premiumReserveCode);
htInsert.Add("BANKACNO_CONTRA", premiumReserveCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQtyCash.ToString() + " unit sold @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", totalPremiumReserveCash * (-1));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "2");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
}
}
contrlNumber++;
tranNumber++;
commonGatewayObj.ExecuteNonQuery(" UPDATE " + accountSchema + ".GL_BASICINFO SET TRAN_ID=" + tranNumber + " , CTRLNO='" + contrlNumber + "' WHERE 1=1");
commonGatewayObj.CommitTransaction();
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
protected void PrintSaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
long money_Receipt_ID = 0;
Hashtable htInsertMoneyReceipt = new Hashtable();
Hashtable htUpdateMoneyReceipt = new Hashtable();
try
{
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
commonGatewayObj.BeginTransaction();
money_Receipt_ID = commonGatewayObj.GetMaxNo("MONEY_RECEIPT", "ID") + 1;
htUpdateMoneyReceipt.Add("VALID", "N");
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_TYPE", "E");
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_BY", userObj.UserID.ToString());
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Update(htUpdateMoneyReceipt, "MONEY_RECEIPT", "ID=" + moneyReceipDropDownList.SelectedValue.ToString());
htInsertMoneyReceipt.Add("ID", money_Receipt_ID);
htInsertMoneyReceipt.Add("RECEIPT_NO", moneyReceipDropDownList.SelectedItem.Text);
htInsertMoneyReceipt.Add("RECEIPT_TYPE", "REP");
htInsertMoneyReceipt.Add("RECEIPT_DATE", ReceiptDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("REG_BK", fundCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_BR", branchCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_NO", regNoTextBox.Text.Trim());
if (holderBOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BO", holderBOTextBox.Text.Trim());
}
htInsertMoneyReceipt.Add("HNAME", NameTextBox.Text.Trim());
htInsertMoneyReceipt.Add("ADDRESS", addressTextBox.Text.Trim());
htInsertMoneyReceipt.Add("UNIT_QTY", QtyTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RATE", RateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("SL_TR_RN_NO", SaleTRRNNoTextBox.Text.Trim().ToUpper());
if (EFTRadioButton.Checked)
{
htInsertMoneyReceipt.Add("REP_PAY_TYPE", "EFT");
}
else
{
htInsertMoneyReceipt.Add("REP_PAY_TYPE", "CHQ");
}
htInsertMoneyReceipt.Add("REP_PAY_DATE", PayDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_BY", userObj.UserID.ToString());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(htInsertMoneyReceipt, "MONEY_RECEIPT");
commonGatewayObj.CommitTransaction();
ClearText();
Session["MONEY_RECEIPT_ID"] = money_Receipt_ID.ToString();
Session["MONEY_RECEIPT_TYPE"] = "REP";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "window.open('ReportViewer/UnitReportMoneyReceiptReportViewer.aspx');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
Session["MONEY_RECEIPT_ID"] = null;
Session["MONEY_RECEIPT_TYPE"] = null;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save and print Failed');", true);
}
}
public void saveTransfer(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitTransfer transferObj, UnitUser unitUserObj)
{
try
{
commonGatewayObj.BeginTransaction();
Hashtable htTransferRegInfo = new Hashtable();
Hashtable htTransCertNoTemp = new Hashtable();
int SL_TR_RN = 0;
int CertNo = 0;
string certType = "";
string[] saleNoArray;
string[] certArray;
string statusFlag = "T";
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)
{
htTransferRegInfo = new Hashtable();
htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString());
htTransferRegInfo.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(htTransferRegInfo, "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)
{
htTransferRegInfo = new Hashtable();
htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString());
htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString());
htTransferRegInfo.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(htTransferRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
commonGatewayObj.Update(htTransferRegInfo, "SALE_CERT", "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 + "'");
commonGatewayObj.Update(htTransferRegInfo, "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 = "T" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0)
{
htTransferRegInfo = new Hashtable();
htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_NO", transferObj.TransfereeRegNo.ToString());
htTransferRegInfo.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(htTransferRegInfo, "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();
}
htTransferRegInfo = new Hashtable();
htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString()));
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
htTransferRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper());
htTransferRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString()));
htTransferRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper());
htTransferRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString()));
htTransferRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_BR", transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("CURR_REG_NO", Convert.ToInt32(transferObj.TransfereeRegNo.ToString()));
htTransferRegInfo.Add("OLD_SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper());
commonGatewayObj.Insert(htTransferRegInfo, "TRANS_CERT");
}
DataTable dtTransfer = dtTrnasfer(dtTransferSaleCert);
for (int i = 0; i < dtTransfer.Rows.Count; i++)
{
//htTransCertNoTemp = new Hashtable();
//htTransCertNoTemp.Add("F_CD", regObj.FundCode.ToString().ToUpper());
//htTransCertNoTemp.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper());
//htTransCertNoTemp.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString()));
//htTransCertNoTemp.Add("CERTIFICATE", dtTransfer.Rows[i]["CERTIFICATE"].ToString());
//htTransCertNoTemp.Add("OLD_SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString());
// commonGatewayObj.Insert(htTransCertNoTemp, "TRANS_CERT_NO_TEMP");
htTransferRegInfo = new Hashtable();
htTransferRegInfo.Add("F_CD", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("BR_CODE", regObj.FundCode.ToString().ToUpper() + "_" + transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("TR_NO", Convert.ToInt32(transferObj.TransferNo.ToString()));
htTransferRegInfo.Add("TR_DT", Convert.ToDateTime(transferObj.TransferDate.ToString()).ToString("dd-MMM-yyyy"));
htTransferRegInfo.Add("REG_BK_O", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("REG_BR_O", transferObj.TferorBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("REG_NO_O", Convert.ToInt32(transferObj.TransferorRegNo.ToString()));
htTransferRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString()));
htTransferRegInfo.Add("REG_BK_I", regObj.FundCode.ToString().ToUpper());
htTransferRegInfo.Add("REG_BR_I", transferObj.TfereeBranchCode.ToString().ToUpper());
htTransferRegInfo.Add("REG_NO_I", Convert.ToInt32(transferObj.TransfereeRegNo.ToString()));
htTransferRegInfo.Add("USER_NM", unitUserObj.UserID.ToString());
htTransferRegInfo.Add("ENT_DT", DateTime.Now.ToString());
htTransferRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
htTransferRegInfo.Add("OLD_SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString());
commonGatewayObj.Insert(htTransferRegInfo, "TRANSFER");
}
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
protected void PrintSaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
long money_Receipt_ID = 0;
Hashtable htInsertMoneyReceipt = new Hashtable();
Hashtable htUpdateMoneyReceipt = new Hashtable();
try
{
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
money_Receipt_ID = commonGatewayObj.GetMaxNo("MONEY_RECEIPT", "ID") + 1;
commonGatewayObj.BeginTransaction();
htUpdateMoneyReceipt.Add("VALID", "N");
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_TYPE", "E");
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_BY", userObj.UserID.ToString());
htUpdateMoneyReceipt.Add("RECEIPT_EDIT_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Update(htUpdateMoneyReceipt, "MONEY_RECEIPT", "ID=" + moneyReceipDropDownList.SelectedValue.ToString());
htInsertMoneyReceipt.Add("ID", money_Receipt_ID);
htInsertMoneyReceipt.Add("RECEIPT_NO", moneyReceipDropDownList.SelectedItem.Text);
htInsertMoneyReceipt.Add("RECEIPT_TYPE", "SL");
htInsertMoneyReceipt.Add("RECEIPT_DATE", ReceiptDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("REG_BK", fundCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_BR", branchCodeDDL.SelectedValue.ToString());
if (regNoTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("REG_NO", regNoTextBox.Text.Trim());
}
if (holderBOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BO", holderBOTextBox.Text.Trim());
}
if (NameTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("HNAME", NameTextBox.Text.Trim());
}
htInsertMoneyReceipt.Add("ADDRESS", addressTextBox.Text.Trim());
htInsertMoneyReceipt.Add("UNIT_QTY", QtyTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RATE", RateTextBox.Text.Trim());
if (ChqRadioButton.Checked)
{
htInsertMoneyReceipt.Add("PAY_TYPE", "CHQ");
htInsertMoneyReceipt.Add("CHQ_TYPE", ChequeTypeDropDownList.SelectedValue.ToString());
}
else if (CashRadioButton.Checked)
{
htInsertMoneyReceipt.Add("PAY_TYPE", "CASH");
}
else if (BothRadioButton.Checked)
{
htInsertMoneyReceipt.Add("PAY_TYPE", "BOTH");
htInsertMoneyReceipt.Add("CHQ_TYPE", ChequeTypeDropDownList.SelectedValue.ToString());
}
else if (MultiRadioButton.Checked)
{
htInsertMoneyReceipt.Add("PAY_TYPE", "MULT");
}
if (CHQDDPONOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("CHQ_DD_NO", CHQDDPONOTextBox.Text.Trim());
}
if (chequeDateTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("CHQ_DD_DATE", chequeDateTextBox.Text.Trim());
}
if (RoutingNoTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("ROUTING_NO", RoutingNoTextBox.Text.Trim());
}
if (BankInfoTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BANK_INFO", BankInfoTextBox.Text.Trim());
}
if (CashAmountTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("CASH_AMT", CashAmountTextBox.Text.Trim());
}
if (MultiplePayTypeTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("MULTI_PAY_REMARKS", MultiplePayTypeTextBox.Text.Trim());
}
if (sellingAgentCodeTextBox.Text != "")
{
if (sellingAgentCodeTextBox.Text != "0")
{
if (sellingAgentCodeTextBox.Text == agentNameDDL.SelectedValue.ToString())
{
htInsertMoneyReceipt.Add("SELLING_AGENT_ID", agentNameDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("SELLING_AGENT_NAME", agentNameDDL.SelectedItem.Text.ToString());
}
}
}
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_BY", userObj.UserID.ToString());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(htInsertMoneyReceipt, "MONEY_RECEIPT");
commonGatewayObj.CommitTransaction();
ClearText();
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'SL' AND SL_REP_TR_RN_NO IS NULL AND ACC_VOUCHER_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
Session["MONEY_RECEIPT_ID"] = money_Receipt_ID.ToString();
Session["MONEY_RECEIPT_TYPE"] = "SL";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "window.open('ReportViewer/UnitReportMoneyReceiptReportViewer.aspx');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
Session["MONEY_RECEIPT_ID"] = null;
Session["MONEY_RECEIPT_TYPE"] = null;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Edit and print Failed');", true);
}
}
public void SaveUnitSale(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, DataTable dtDinomination, UnitUser unitUserObj)
{
Hashtable htUnitSale = new Hashtable();
Hashtable htUnitSaleCert = new Hashtable();
Hashtable htCertNoTemp = new Hashtable();
string certificate = "";
try
{
commonGatewayObj.BeginTransaction();
htUnitSale.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htUnitSale.Add("REG_BR", unitRegObj.BranchCode.ToString());
htUnitSale.Add("REG_NO", unitRegObj.RegNumber.ToString());
htUnitSale.Add("SL_NO", Convert.ToInt32(unitSaleObj.SaleNo.ToString()));
htUnitSale.Add("SL_DT", Convert.ToDateTime(unitSaleObj.SaleDate).ToString("dd-MMM-yyyy"));
htUnitSale.Add("SL_PRICE", Convert.ToDecimal(unitSaleObj.SaleRate.ToString()));
htUnitSale.Add("QTY", Convert.ToInt32(unitSaleObj.SaleUnitQty.ToString()));
htUnitSale.Add("SL_TYPE", unitSaleObj.SaleType.ToString().ToUpper());
htUnitSale.Add("USER_NM", unitUserObj.UserID.ToString());
htUnitSale.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
htUnitSale.Add("ENT_DT", DateTime.Now.ToString());
if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0"))
{
htUnitSale.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo));
}
if (!((unitSaleObj.MoneyReceiptNo.ToString() == "0") && unitSaleObj.PaymentType.ToString() == "CHQ" && unitSaleObj.ChequeNo == null && unitSaleObj.ChequeDate == null))
{
htUnitSale.Add("PAY_TYPE", unitSaleObj.PaymentType);
}
if (unitSaleObj.ChequeNo != null)
{
htUnitSale.Add("CHQ_DD_NO", unitSaleObj.ChequeNo);
}
if (unitSaleObj.ChequeDate == null)
{
htUnitSale.Add("CHEQUE_DT", DBNull.Value);
}
else
{
htUnitSale.Add("CHEQUE_DT", unitSaleObj.ChequeDate);
}
if (!(unitSaleObj.BankCode.ToString() == "0"))
{
htUnitSale.Add("BANK_CODE", Convert.ToInt16(unitSaleObj.BankCode));
}
if (!(unitSaleObj.BranchCode.ToString() == "0"))
{
htUnitSale.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode));
}
if (!(unitSaleObj.CashAmount.ToString() == "0"))
{
htUnitSale.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount));
}
if (unitSaleObj.MultiPayType != null)
{
htUnitSale.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType);
}
commonGatewayObj.Insert(htUnitSale, "SALE");
htCertNoTemp.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htCertNoTemp.Add("REG_BR", unitRegObj.BranchCode.ToString());
htCertNoTemp.Add("REG_NO", unitRegObj.RegNumber.ToString());
htCertNoTemp.Add("SL_NO", Convert.ToInt32(unitSaleObj.SaleNo.ToString()));
for (int looper = 0; looper < dtDinomination.Rows.Count; looper++)
{
htUnitSaleCert.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htUnitSaleCert.Add("REG_BR", unitRegObj.BranchCode.ToString());
htUnitSaleCert.Add("REG_NO", unitRegObj.RegNumber.ToString());
htUnitSaleCert.Add("SL_NO", Convert.ToInt32(unitSaleObj.SaleNo.ToString()));
htUnitSaleCert.Add("CERT_TYPE", dtDinomination.Rows[looper]["dino"].ToString().ToUpper());
htUnitSaleCert.Add("CERT_NO", Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()));
htUnitSaleCert.Add("CERTIFICATE", SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()), dtDinomination.Rows[looper]["dino"].ToString().ToUpper()));
htUnitSaleCert.Add("QTY", Convert.ToInt32(dtDinomination.Rows[looper]["cert_weight"].ToString()));
htUnitSaleCert.Add("USER_NM", unitUserObj.UserID.ToString());
htUnitSaleCert.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
htUnitSaleCert.Add("ENT_DT", DateTime.Now.ToString());
commonGatewayObj.Insert(htUnitSaleCert, "SALE_CERT");
htUnitSaleCert = new Hashtable();
if (certificate == "")
{
certificate = SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()), dtDinomination.Rows[looper]["dino"].ToString().ToUpper());
}
else
{
certificate = certificate + "," + SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()), dtDinomination.Rows[looper]["dino"].ToString().ToUpper());
}
}
htCertNoTemp.Add("CERTIFICATE", certificate);
htCertNoTemp.Add("USER_NM", unitUserObj.UserID.ToString());
htCertNoTemp.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
htCertNoTemp.Add("ENT_DT", DateTime.Now.ToString());
// commonGatewayObj.Insert(htCertNoTemp, "CERT_NO_TEMP");
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
public void SaveAccountVoucherWithChequePayment(string accountSchema)
{
try
{
int countCheck = 0;
long tranNumber = commonGatewayObj.GetMaxNo(accountSchema + ".GL_BASICINFO", "TRAN_ID");
long contrlNumber = commonGatewayObj.GetMaxNo(accountSchema + ".GL_BASICINFO", "TO_NUMBER(CTRLNO)") - 1;
string acc_op_id = unitRepBLObj.getAcc_OP_ID(fundNameDropDownList.SelectedValue.ToString());
long acc_terminal_no = unitRepBLObj.getAcc_terminal_no(fundNameDropDownList.SelectedValue.ToString());
int faceValue = unitRepBLObj.getUnitFaceValue(fundNameDropDownList.SelectedValue.ToString());
string bankPaymentCode = unitRepBLObj.getUnitBankPaymentCode(fundNameDropDownList.SelectedValue.ToString());
string getUnitFundBankCode = unitRepBLObj.getUnitFundBankCode(fundNameDropDownList.SelectedValue.ToString());
Hashtable htInsert = new Hashtable();
Hashtable htUpdate = new Hashtable();
commonGatewayObj.BeginTransaction();
DataTable dtFundYearEndInfo = commonGatewayObj.Select("SELECT * FROM FUND_INFO WHERE FUND_CD='" + fundNameDropDownList.SelectedValue.ToString() + "'");
int year = Convert.ToDateTime(TranDateTextBox.Text.ToString()).Year;
int month = Convert.ToDateTime(TranDateTextBox.Text.ToString()).Month;
string yearStartDate = dtFundYearEndInfo.Rows[0]["YEAR_START_MONTH"].ToString();
string yearEndDate = dtFundYearEndInfo.Rows[0]["YEAR_END_MONTH"].ToString();
if (yearStartDate == "01-JUL")
{
if (month < 6)
{
yearEndDate = yearEndDate + "-" + year.ToString();
year--;
yearStartDate = yearStartDate + "-" + year.ToString();
}
else
{
yearStartDate = yearStartDate + "-" + year.ToString();
year++;
yearEndDate = yearEndDate + "-" + year.ToString();
}
}
else
{
yearStartDate = yearStartDate + "-" + year.ToString();
yearEndDate = yearEndDate + "-" + year.ToString();
}
if (unitRepBLObj.IsDuplicateAccVoucherNo(accountSchema, VoucherNoTexBox.Text.Trim(), "1", yearStartDate, yearEndDate))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save Failed Duplicate Payment Voucher Number');", true);
}
else
{
foreach (GridViewRow Drv in SurrenderListGridView.Rows)
{
CheckBox leftCheckBox = (CheckBox)SurrenderListGridView.Rows[countCheck].FindControl("leftCheckBox");
//TextBox VoucherNoTexBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("VoucherNumberTextBox");
TextBox ChequeNoTexBox = (TextBox)SurrenderListGridView.Rows[countCheck].FindControl("ChequeNumberTextBox");
if (leftCheckBox.Checked)
{
decimal unitFaceValue = Convert.ToDecimal(faceValue);
decimal unitSaleQty = Convert.ToDecimal(Drv.Cells[8].Text.ToString());
decimal unitSaleRate = Convert.ToDecimal(Drv.Cells[9].Text.ToString());
decimal unitSaleTotalValue = Convert.ToDecimal(Drv.Cells[10].Text.ToString());
DataTable dtHolderBankInfo = unitRepBLObj.dtGetHolderBankInfo(Drv.Cells[2].Text.ToUpper().ToString(), Drv.Cells[3].Text.ToUpper().ToString(), Convert.ToInt32(Drv.Cells[4].Text.ToString()));
htUpdate = new Hashtable();
if (dtHolderBankInfo.Rows.Count > 0)
{
htUpdate.Add("HOLDER_AC_NO", dtHolderBankInfo.Rows[0]["BK_AC_NO"].ToString());
htUpdate.Add("HOLDER_ROUTING_NO", dtHolderBankInfo.Rows[0]["ROUTING_NO"].ToString());
}
htUpdate.Add("CHEQUE_DATE", ChequeDateTextBox.Text.ToString());
htUpdate.Add("CHEQUE_POSTED_BY", userObj.UserID.ToString());
htUpdate.Add("CHEQUE_POSTED_DATE", DateTime.Now.ToString());
htUpdate.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htUpdate.Add("CHEQUE_NO", ChequeNoTexBox.Text.Trim().ToString());
if (unitRepBLObj.IsValidMobileNumber(regObj))
{
htUpdate.Add("SMS_CREATE_DATE", DateTime.Now.ToString());
}
htUpdate.Add("SIGNATORY1_ID", Signatory1DropDownList.SelectedValue.ToUpper().ToString());
htUpdate.Add("SIGANTORY2_ID", Signatory2DropDownList.SelectedValue.ToUpper().ToString());
htUpdate.Add("FUND_INFO_BANK_CODE", getUnitFundBankCode);
commonGatewayObj.Update(htUpdate, "REPURCHASE ", "REG_BK='" + Drv.Cells[2].Text.ToUpper().ToString() + "' AND REG_BR='" + Drv.Cells[3].Text.ToUpper().ToString() + "' AND REG_NO=" + Convert.ToInt32(Drv.Cells[4].Text.ToString()) + " AND REP_NO=" + Convert.ToInt32(Drv.Cells[5].Text.ToString()));
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", "101010000");
htInsert.Add("BANKACNO", "101010000");
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit surrendered @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", Convert.ToDecimal(unitFaceValue * unitSaleQty));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "1");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
if (unitSaleRate < unitFaceValue)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", "101020000");
htInsert.Add("BANKACNO_CONTRA", "101020000");
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit surrendered @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", Convert.ToDecimal((unitFaceValue * unitSaleQty) - unitSaleTotalValue));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "1");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
else if (unitSaleRate > unitFaceValue)
{
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", "101020000");
htInsert.Add("BANKACNO", "101020000");
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit surrendered @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "D");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", Convert.ToDecimal(unitSaleTotalValue - ((unitFaceValue * unitSaleQty))));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "1");
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
contrlNumber++;
htInsert = new Hashtable();
htInsert.Add("TRAN_ID", tranNumber + 1);
htInsert.Add("ACCCODE", bankPaymentCode);
htInsert.Add("BANKACNO_CONTRA", bankPaymentCode);
htInsert.Add("TRAN_TIME", DateTime.Now.ToShortTimeString());
htInsert.Add("TRAN_DATE", TranDateTextBox.Text.Trim());
htInsert.Add("REMARKS", unitSaleQty.ToString() + " unit surrendered @tk." + unitSaleRate.ToString() + " per unit ");
htInsert.Add("TRAN_TYPE", "C");
htInsert.Add("VOUCHER_NO", VoucherNoTexBox.Text.Trim().ToString());
htInsert.Add("TOTAL_AMNT", Convert.ToDecimal(unitSaleTotalValue));
htInsert.Add("CTRLNO", contrlNumber);
htInsert.Add("OP_ID", userObj.UserID.ToString());
htInsert.Add("VOUCHER_TYPE", "1");
htInsert.Add("CHEQUENO", ChequeNoTexBox.Text.Trim().ToString());
htInsert.Add("CHEQUE_DATE", ChequeDateTextBox.Text.Trim());
htInsert.Add("TERMINAL_NO", acc_terminal_no);
htInsert.Add("RECENT", "y");
htInsert.Add("LATESTDEL", "m");
htInsert.Add("ISOUT", "N");
htInsert.Add("ISREV", "N");
htInsert.Add("OLDDATA", "N");
commonGatewayObj.Insert(htInsert, accountSchema + ".GL_TRAN");
}
countCheck++;
}
contrlNumber++;
tranNumber++;
commonGatewayObj.ExecuteNonQuery(" UPDATE " + accountSchema + ".GL_BASICINFO SET TRAN_ID=" + tranNumber + " , CTRLNO='" + contrlNumber + "' WHERE 1=1");
commonGatewayObj.CommitTransaction();
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
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;
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
try
{
int countRows = 0;
commonGatewayObj.BeginTransaction();
DataTable dtTradeCustDSE = (DataTable)Session["dtTradeCusetDSE"];
if (dtTradeCustDSE.Rows.Count > 0)
{
// dt.Rows[0]["vch_dt"].ToString();
string howlaDate = dtTradeCustDSE.Rows[0]["SP_DATE"].ToString();
DataTable dtMarketPriceByHowladate = new DataTable();
PfolioBL pfolioBLObj = new PfolioBL();
if (!pfolioBLObj.getMPUpdateStatus(howlaDate, "AVERAGE"))
{
grdShowDSEMP.Visible = false;
DSETradeCustLabel.Text = "Save Failed: Market price is not updated";
DSETradeCustLabel.Style.Add("color", "red");
}
else
{
if (!pfolioBLObj.getHowlaUpdateStatus(HowlaDateTextBox.Text.ToString(), "DSE"))
{
if (dvGridDSETradeInfo.Visible == true)
{
Hashtable htTradeCustDSE = new Hashtable();
for (int loop = 0; loop < dtTradeCustDSE.Rows.Count; loop++)
{
htTradeCustDSE.Add("F_CD", dtTradeCustDSE.Rows[loop]["F_CD"]);
htTradeCustDSE.Add("SP_DATE", dtTradeCustDSE.Rows[loop]["SP_DATE"]);
htTradeCustDSE.Add("BK_REF", dtTradeCustDSE.Rows[loop]["BK_REF"]);
htTradeCustDSE.Add("HOWLA_NO", dtTradeCustDSE.Rows[loop]["HOWLA_NO"]);
htTradeCustDSE.Add("HOWLA_TP", dtTradeCustDSE.Rows[loop]["HOWLA_TP"]);
htTradeCustDSE.Add("IN_OUT", dtTradeCustDSE.Rows[loop]["IN_OUT"]);
htTradeCustDSE.Add("SETTLE_DT", dtTradeCustDSE.Rows[loop]["SETTLE_DT"]);
htTradeCustDSE.Add("COMP_CD", dtTradeCustDSE.Rows[loop]["COMP_CD"]);
htTradeCustDSE.Add("SP_QTY", dtTradeCustDSE.Rows[loop]["SP_QTY"]);
htTradeCustDSE.Add("SP_RATE", dtTradeCustDSE.Rows[loop]["SP_RATE"]);
htTradeCustDSE.Add("CL_DATE", dtTradeCustDSE.Rows[loop]["CL_DATE"]);
htTradeCustDSE.Add("BK_CD", dtTradeCustDSE.Rows[loop]["BK_CD"]);
htTradeCustDSE.Add("HOWLA_CHG", dtTradeCustDSE.Rows[loop]["HOWLA_CHG"]);
htTradeCustDSE.Add("LAGA_CHG", dtTradeCustDSE.Rows[loop]["LAGA_CHG"]);
htTradeCustDSE.Add("VOUCH_REF", dtTradeCustDSE.Rows[loop]["VOUCH_REF"]);
htTradeCustDSE.Add("OP_NAME", dtTradeCustDSE.Rows[loop]["OP_NAME"]);
htTradeCustDSE.Add("N_P", dtTradeCustDSE.Rows[loop]["N_P"]);
htTradeCustDSE.Add("ISIN_CD", dtTradeCustDSE.Rows[loop]["ISIN_CD"]);
htTradeCustDSE.Add("FORGN_FLG", dtTradeCustDSE.Rows[loop]["FORGN_FLG"]);
htTradeCustDSE.Add("SPOT_ID", dtTradeCustDSE.Rows[loop]["SPOT_ID"]);
htTradeCustDSE.Add("INSTR_GRP", dtTradeCustDSE.Rows[loop]["INSTR_GRP"]);
htTradeCustDSE.Add("MARKT_TP", dtTradeCustDSE.Rows[loop]["MARKT_TP"]);
htTradeCustDSE.Add("CUSTOMER", dtTradeCustDSE.Rows[loop]["CUSTOMER"]);
htTradeCustDSE.Add("BOID", dtTradeCustDSE.Rows[loop]["BOID"]);
commonGatewayObj.Insert(htTradeCustDSE, "HOWLA");
htTradeCustDSE = new Hashtable();
countRows++;
}
commonGatewayObj.CommitTransaction();
dvGridDSETradeInfo.Visible = false;
Session["dtTradeCusetDSE"] = null;
DSETradeCustLabel.Text = " Howla DSE " + countRows.ToString() + " Rows Save Successfully";
DSETradeCustLabel.Style.Add("color", "#009933");
}
else
{
DSETradeCustLabel.Text = "Save Failed: DSE Howla Already Saved On That Date";
DSETradeCustLabel.Style.Add("color", "red");
}
}
else
{
DSETradeCustLabel.Text = "Save Failed:Please Press the Show DSE Howla button";
DSETradeCustLabel.Style.Add("color", "red");
}
}
//string strQuery = "select TO_CHAR(max(vch_dt),'DD-MON-YYYY')last_tr_dt,TO_CHAR(max(vch_dt) + 1,'DD-MON-YYYY')vch_dt from fund_trans_hb where f_cd =" + dtFundNameDropDownList.Rows[i]["F_CD"].ToString() +
// " and tran_tp in ('C','S') and stock_ex in ('C','A')";
//dtMarketPriceByHowladate = commonGatewayObj.Select(strQuery);
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
Session["dtTradeCusetDSE"] = null;
DSETradeCustLabel.Text = " Howla DSE Save failed Error:" + ex.Message.ToString();
DSETradeCustLabel.Style.Add("color", "red");
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if (pf1s1DAOObj.IsCompCode(companyNameDropDownList.SelectedValue))
{
companyNameDropDownList.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Company Info already Inserted.');", true);
}
else
{
string LoginID = Session["UserID"].ToString();
string LoginName = Session["UserName"].ToString().ToUpper();
Hashtable httable = new Hashtable();
httable.Add("comp_cd", Convert.ToInt16(companyNameDropDownList.SelectedValue));
if (!sectorDropDownList.SelectedValue.Equals("0"))
{
httable.Add("SECTOR_CD", Convert.ToInt16(sectorDropDownList.SelectedValue));
}
if (!lastYearEndTextBox.Text.Equals(""))
{
httable.Add("FINANCIAL_YEAR", Convert.ToString(lastYearEndTextBox.Text));
}
if (!authorizedCapitalTextBox.Text.Equals(""))
{
httable.Add("AUTHO_CAP", Convert.ToDecimal(authorizedCapitalTextBox.Text));
}
if (!paidupCapitalTextBox.Text.Equals(""))
{
httable.Add("PAIDUP_CAP", Convert.ToDecimal(paidupCapitalTextBox.Text));
}
if (!reserveAndSurplusTextBox.Text.Equals(""))
{
httable.Add("RESERVE_SURPLUS", Convert.ToDecimal(reserveAndSurplusTextBox.Text));
}
if (!faceValueTextBox.Text.Equals(""))
{
httable.Add("FACE_VAL", Convert.ToDecimal(faceValueTextBox.Text));
}
if (!totalNoOfSecuritiesTextBox.Text.Equals(""))
{
httable.Add("TOTAL_NO_SHARES", Convert.ToDecimal(totalNoOfSecuritiesTextBox.Text));
}
if (!marketLotTextBox.Text.Equals(""))
{
httable.Add("MARKET_LOT", Convert.ToDecimal(marketLotTextBox.Text));
}
if (!marketCategoryDropDownList.SelectedValue.Equals("0"))
{
httable.Add("MARKET_CATEGORY", Convert.ToChar(marketCategoryDropDownList.SelectedValue));
}
if (!electronicShareDropDownList.SelectedValue.Equals("0"))
{
httable.Add("ELECTRONIC_SHARE", Convert.ToChar(electronicShareDropDownList.SelectedValue));
}
if (!firstQuarterEpsTextBox.Text.Equals(""))
{
httable.Add("Q1_EPS", Convert.ToDecimal(firstQuarterEpsTextBox.Text));
}
if (!secondQuarterTextBox.Text.Equals(""))
{
httable.Add("Q2_EPS", Convert.ToDecimal(secondQuarterTextBox.Text));
}
if (!thirdQuarterTextBox.Text.Equals(""))
{
httable.Add("Q3_EPS", Convert.ToDecimal(thirdQuarterTextBox.Text));
}
if (!fourthQuarterTextBox.Text.Equals(""))
{
httable.Add("Q4_EPS", Convert.ToDecimal(fourthQuarterTextBox.Text));
}
if (!navTextBox.Text.Equals(""))
{
httable.Add("NAV", Convert.ToDecimal(navTextBox.Text));
}
if (!stockDividendTextBox.Text.Equals(""))
{
httable.Add("STOCK_DIVIDEND", Convert.ToDecimal(stockDividendTextBox.Text));
}
if (!cashDividendTextBox.Text.Equals(""))
{
httable.Add("CASH_DIVIDEND", Convert.ToDecimal(cashDividendTextBox.Text));
}
if (!recordDateFromTextBox.Text.Equals(""))
{
httable.Add("RECORD_DATE_FROM", Convert.ToDateTime(recordDateFromTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!recordDateToTextBox.Text.Equals(""))
{
httable.Add("RECORD_DATE_TO", Convert.ToDateTime(recordDateToTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!agmDateTextBox.Text.Equals(""))
{
httable.Add("AGM_DATE", Convert.ToDateTime(agmDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!rightShareTextBox.Text.Equals(""))
{
httable.Add("RIGHT_SHARE", Convert.ToDecimal(rightShareTextBox.Text));
}
if (!rightApprovalDateTextBox.Text.Equals(""))
{
httable.Add("RIGHT_APPROVAL_DATE", Convert.ToDateTime(rightApprovalDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!rightRecordDateFromTextBox.Text.Equals(""))
{
httable.Add("RIGHT_RECORD_DATE_FROM", Convert.ToDateTime(rightRecordDateFromTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!rightRecordDateToTextBox.Text.Equals(""))
{
httable.Add("RIGHT_RECORD_DATE_TO", Convert.ToDateTime(rightRecordDateToTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!cashEpsTextBox.Text.Equals(""))
{
httable.Add("CASH_EPS", Convert.ToDecimal(cashEpsTextBox.Text));
}
if (!interimStockDividendTextBox.Text.Equals(""))
{
httable.Add("INTERIM_STOCK_DIVIDEND", Convert.ToDecimal(interimStockDividendTextBox.Text));
}
if (!interimCashDividendTextBox.Text.Equals(""))
{
httable.Add("INTERIM_CASH_DIVIDEND", Convert.ToDecimal(interimCashDividendTextBox.Text));
}
if (!interimRecordDateFromTextBox.Text.Equals(""))
{
httable.Add("INTERIM_RECORD_DATE_FROM", Convert.ToDateTime(interimRecordDateFromTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!interimRecordDateToTextBox.Text.Equals(""))
{
httable.Add("INTERIM_RECORD_DATE_TO", Convert.ToDateTime(interimRecordDateToTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
}
if (!shareOfDirectorTextBox.Text.Equals(""))
{
httable.Add("SHARE_HOLDER_DIR", Convert.ToDecimal(shareOfDirectorTextBox.Text));
}
if (!shareOfPublicTextBox.Text.Equals(""))
{
httable.Add("SHARE_HOLDER_PUB", Convert.ToDecimal(shareOfPublicTextBox.Text));
}
if (!shareOfGovtTextBox.Text.Equals(""))
{
httable.Add("SHARE_HOLDER_GOVT", Convert.ToDecimal(shareOfGovtTextBox.Text));
}
if (!shareOfForeignTextBox.Text.Equals(""))
{
httable.Add("SHARE_HOLDER_FOREIGN", Convert.ToDecimal(shareOfForeignTextBox.Text));
}
if (!shareOfInstitutionTextBox.Text.Equals(""))
{
httable.Add("SHARE_HOLDER_INSTITUTION", Convert.ToDecimal(shareOfInstitutionTextBox.Text));
}
if (!percentageGrothEpsTextBox.Text.Equals(""))
{
httable.Add("PERCENTAGE_GROTH_EPS", Convert.ToDecimal(percentageGrothEpsTextBox.Text));
}
if (!percentageGrothCashEpsTextBox.Text.Equals(""))
{
httable.Add("PERCENTAGE_GROTH_CASH_EPS", Convert.ToDecimal(percentageGrothCashEpsTextBox.Text));
}
if (!netProfitTextBox.Text.Equals(""))
{
httable.Add("NET_PROFIT", Convert.ToDecimal(netProfitTextBox.Text));
}
if (!totalEquityTextBox.Text.Equals(""))
{
httable.Add("TOTAL_EQUITY", Convert.ToDecimal(totalEquityTextBox.Text));
}
if (!longTermDebtTextBox.Text.Equals(""))
{
httable.Add("LONG_TERM_DEBT", Convert.ToDecimal(longTermDebtTextBox.Text));
}
httable.Add("ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
httable.Add("ENTRY_BY", LoginID);
commonGatewayObj.Insert(httable, "analysis_mst1");
ClearFields();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Saved Successfully');", true);
}
}
public void SaveUnitRenewal(UnitHolderRegistration unitRegObj, DataTable dtTransferSaleCert, UnitRenewal renwalObj, DataTable dtDinomination, UnitUser unitUserObj)
{
Hashtable htUnitSaleCert = new Hashtable();
Hashtable htRenwal = new Hashtable();
Hashtable htRenewalIN = new Hashtable();
Hashtable htRenewalOUT = new Hashtable();
UnitTransferBL unitTransferBLObj = new UnitTransferBL();
int SL_TR_RN = 0;
int CertNo = 0;
string certType = "";
string[] saleNoArray;
string[] certArray;
string valid = "N";
string remarks = "RENEWAL NO:" + renwalObj.RenewalNo.ToString();
string Old_SL_TR_RN = "";
string FORM_CODE = "";
if (renwalObj.RenewalType.ToString().ToUpper() == "S" || renwalObj.RenewalType.ToString().ToUpper() == "C")
{
FORM_CODE = "UNIT-UMA";
}
else if (renwalObj.RenewalType.ToString().ToUpper() == "S")
{
FORM_CODE = "UNIT-CHA";
}
try
{
commonGatewayObj.BeginTransaction();
for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++)
{
if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0)
{
htUnitSaleCert = new Hashtable();
htUnitSaleCert.Add("VALID", valid);
htUnitSaleCert.Add("REMARKS", remarks);
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(htUnitSaleCert, "SALE_CERT", "REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.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)
{
htUnitSaleCert = new Hashtable();
htUnitSaleCert.Add("VALID", valid);
htUnitSaleCert.Add("REMARKS", remarks);
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(htUnitSaleCert, "TRANS_CERT", "F_CD='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
// commonGatewayObj.Update(htUnitSaleCert, "SALE_CERT", " 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 + "'");
// commonGatewayObj.Update(htUnitSaleCert, "RENEWAL_OUT", "REN_NO='" + SL_TR_RN + "' 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 = "T" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0)
{
htUnitSaleCert = new Hashtable();
htUnitSaleCert.Add("VALID", valid);
htUnitSaleCert.Add("REMARKS", remarks);
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(htUnitSaleCert, "RENEWAL_OUT", "REN_NO='" + SL_TR_RN + "' AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "R" + SL_TR_RN.ToString();
}
htRenewalIN = new Hashtable();
htRenewalIN.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htRenewalIN.Add("REG_BR", unitRegObj.BranchCode.ToString().ToUpper());
htRenewalIN.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString()));
htRenewalIN.Add("REN_NO", renwalObj.RenewalNo.ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
htRenewalIN.Add("CERT_TYPE", certArray[0].ToString().ToUpper());
htRenewalIN.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString()));
htRenewalIN.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper());
htRenewalIN.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString()));
htRenewalIN.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper());
commonGatewayObj.Insert(htRenewalIN, "RENEWAL_IN");
}
DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert);
for (int i = 0; i < dtTransfer.Rows.Count; i++) //Insert Into Renewal Table
{
htRenwal = new Hashtable();
htRenwal.Add("REN_NO", renwalObj.RenewalNo.ToString());
htRenwal.Add("REN_DT", Convert.ToDateTime(renwalObj.RenewalDate).ToString("dd-MMM-yyyy"));
htRenwal.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htRenwal.Add("REG_BR", unitRegObj.BranchCode.ToString());
htRenwal.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString()));
htRenwal.Add("FORM_CODE", FORM_CODE);
htRenwal.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString());
htRenwal.Add("REN_TYPE", renwalObj.RenewalType.ToString().ToUpper());
htRenwal.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString()));
htRenwal.Add("USER_NM", unitUserObj.UserID.ToString());
htRenwal.Add("ENT_DT", DateTime.Now.ToString());
htRenwal.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
commonGatewayObj.Insert(htRenwal, "RENEWAL");
}
for (int looper = 0; looper < dtDinomination.Rows.Count; looper++)//Insert Into RenewalOut Table
{
htRenewalOUT = new Hashtable();
htRenewalOUT.Add("REG_BK", unitRegObj.FundCode.ToString().ToUpper());
htRenewalOUT.Add("REG_BR", unitRegObj.BranchCode.ToString());
htRenewalOUT.Add("REG_NO", Convert.ToInt32(unitRegObj.RegNumber.ToString()));
htRenewalOUT.Add("REN_NO", renwalObj.RenewalNo.ToString());
htRenewalOUT.Add("CERT_TYPE", dtDinomination.Rows[looper]["dino"].ToString().ToUpper());
htRenewalOUT.Add("CERT_NO", Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()));
htRenewalOUT.Add("CERTIFICATE", SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["cert_no"].ToString()), dtDinomination.Rows[looper]["dino"].ToString().ToUpper()));
htRenewalOUT.Add("QTY", Convert.ToInt32(dtDinomination.Rows[looper]["cert_weight"].ToString()));
commonGatewayObj.Insert(htRenewalOUT, "RENEWAL_OUT");
}
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
protected void PrintSaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
long money_Receipt_ID = 0;
Hashtable htInsertMoneyReceipt = new Hashtable();
try
{
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
regObj.RegNumber = regNoTextBox.Text.Trim();
CDSStatus = opendMFDAO.getCDSStatus(fundCodeDDL.SelectedValue.ToString());
decimal TotalUnitsBalance = 0;
if (CDSStatus == "Y")
{
TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalanceCDS(regObj);
}
else
{
TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalance(regObj);
}
decimal unitQty = Convert.ToDecimal(QtyTextBox.Text.Trim());
if (unitQty > TotalUnitsBalance)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed: Insufficient Units');", true);
}
else if (unitSaleBLObj.CheckDuplicateMoneyReceiptNo(regObj, "REP", Convert.ToInt64(ReceiptNoTextBox.Text.Trim())))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Receipt Number " + "');", true);
}
else
{
money_Receipt_ID = commonGatewayObj.GetMaxNo("MONEY_RECEIPT", "ID") + 1;
commonGatewayObj.BeginTransaction();
htInsertMoneyReceipt.Add("ID", money_Receipt_ID);
htInsertMoneyReceipt.Add("RECEIPT_NO", ReceiptNoTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RECEIPT_TYPE", "REP");
htInsertMoneyReceipt.Add("RECEIPT_DATE", ReceiptDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("REG_BK", fundCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_BR", branchCodeDDL.SelectedValue.ToString());
htInsertMoneyReceipt.Add("REG_NO", regNoTextBox.Text.Trim());
if (holderBOTextBox.Text.Trim() != "")
{
htInsertMoneyReceipt.Add("BO", holderBOTextBox.Text.Trim());
}
htInsertMoneyReceipt.Add("HNAME", NameTextBox.Text.Trim());
htInsertMoneyReceipt.Add("ADDRESS", addressTextBox.Text.Trim());
htInsertMoneyReceipt.Add("UNIT_QTY", QtyTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RATE", RateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("SL_TR_RN_NO", SaleTRRNNoTextBox.Text.Trim().ToUpper());
if (EFTRadioButton.Checked)
{
htInsertMoneyReceipt.Add("REP_PAY_TYPE", "EFT");
}
else
{
htInsertMoneyReceipt.Add("REP_PAY_TYPE", "CHQ");
}
htInsertMoneyReceipt.Add("REP_PAY_DATE", PayDateTextBox.Text.Trim());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_BY", userObj.UserID.ToString());
htInsertMoneyReceipt.Add("RECEIPT_ENTRY_DATE", DateTime.Today.ToString("dd-MMM-yyyy"));
commonGatewayObj.Insert(htInsertMoneyReceipt, "MONEY_RECEIPT");
commonGatewayObj.CommitTransaction();
ClearText();
Session["MONEY_RECEIPT_ID"] = money_Receipt_ID.ToString();
Session["MONEY_RECEIPT_TYPE"] = "REP";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "window.open('ReportViewer/UnitReportMoneyReceiptReportViewer.aspx');", true);
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
Session["MONEY_RECEIPT_ID"] = null;
Session["MONEY_RECEIPT_TYPE"] = null;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save and print Failed');", true);
}
}
