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); } }