public bool IsValidSaleNumber(UnitHolderRegistration regObj, UnitSale saleObj) { DataTable dtValidSaleNumber = new DataTable(); bool ValidSaleNumber = false; string queryString = "SELECT * FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString() + "' AND REG_BR='" + regObj.BranchCode + "' AND SL_NO=" + Convert.ToInt32(saleObj.SaleNo.ToString()); dtValidSaleNumber = commonGatewayObj.Select(queryString.ToString()); if (dtValidSaleNumber.Rows.Count > 0) { if (dtValidSaleNumber.Rows[0]["SL_NO"].Equals(DBNull.Value)) { ValidSaleNumber = false; } else { int SaleNo = Convert.ToInt32(dtValidSaleNumber.Rows[0]["SL_NO"].ToString()); if (saleObj.SaleNo.ToString() == SaleNo.ToString()) { ValidSaleNumber = true; } else { ValidSaleNumber = false; } } } else { ValidSaleNumber = false; } return(ValidSaleNumber); }
public DataTable dtGetSaleCertBySaleNo(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj) { // DataTable dtDinomination = new DataTable(); DataTable dtDinomination = commonGatewayObj.Select("SELECT * FROM SALE_CERT WHERE SL_NO=" + unitSaleObj.SaleNo + " AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + unitRegObj.RegNumber); return(dtDinomination); }
public void displayRegInfo() { UnitSale saleObj = new UnitSale(); UnitHolderRegistration unitRegObj = new UnitHolderRegistration(); unitRegObj.FundCode = fundCodeTextBox.Text.Trim(); unitRegObj.BranchCode = branchCodeTextBox.Text.Trim(); unitRegObj.RegNumber = regNoTextBox.Text.Trim(); if (opendMFDAO.IsValidRegistration(unitRegObj)) { DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj); if (dtRegInfo.Rows.Count > 0) { holderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString(); jHolderTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString(); holderAddress1TextBox.Text = dtRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS1"].ToString(); holderAddress2TextBox.Text = dtRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS2"].ToString(); holderTelphoneTextBox.Text = dtRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TEL_NO"].ToString(); string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString(); if (string.Compare(CIP, "Y", true) == 0) { tdCIP.InnerHtml = " YES "; } else if (string.Compare(CIP, "N", true) == 0) { tdCIP.InnerHtml = " NO "; } displaySign(); dinoGridView.DataSource = opendMFDAO.getTableDinomination(); dinoGridView.DataBind(); dinoGridView.Visible = false; saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj).ToString(); // MoneyReceiptNoTextBox.Text = unitSaleBLObj.getNextMoneReceiptNo(unitRegObj, userObj).ToString(); saleObj.SaleNo = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj) - 1; saleDateTextBox.Text = opendMFDAO.getLastSaleDate(unitRegObj, saleObj).ToString("dd-MMM-yyyy"); saleRateTextBox.Text = opendMFDAO.getLastSaleRate(unitRegObj, saleObj).ToString(); saleTypeDropDownList.SelectedValue = unitSaleBLObj.GetNextSaleType(unitRegObj, userObj).ToString(); } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); // PhotoImage.ImageUrl = Path.Combine(ConfigReader.PhotoLocation, "Notavailable.JPG").ToString(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", " window.fnResetAll();", true); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; } } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true); } }
public void displayRegInfo() { UnitSale saleObj = new UnitSale(); UnitHolderRegistration unitRegObj = new UnitHolderRegistration(); unitRegObj.FundCode = fundCodeTextBox.Text.Trim(); unitRegObj.BranchCode = branchCodeTextBox.Text.Trim(); unitRegObj.RegNumber = regNoTextBox.Text.Trim(); if (opendMFDAO.IsValidRegistration(unitRegObj)) { moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptInfoforDDL(unitRegObj, "SL"); moneyReceipDropDownList.DataTextField = "RECEIPT_NO"; moneyReceipDropDownList.DataValueField = "ID"; moneyReceipDropDownList.DataBind(); DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj); if (dtRegInfo.Rows.Count > 0) { holderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString(); jHolderTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString(); holderAddress1TextBox.Text = dtRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS1"].ToString(); holderAddress2TextBox.Text = dtRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS2"].ToString(); holderTelphoneTextBox.Text = dtRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TEL_NO"].ToString(); string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString(); if (string.Compare(CIP, "Y", true) == 0) { tdCIP.InnerHtml = " YES "; } else if (string.Compare(CIP, "N", true) == 0) { tdCIP.InnerHtml = " NO "; } displaySign(); saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj).ToString(); saleObj.SaleNo = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj) - 1; } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", " window.fnResetAll();", true); tdCIP.InnerHtml = ""; } } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true); } }
public DataTable dtGetSaleInfoCDS(UnitHolderRegistration regObj, UnitSale saleObj) { StringBuilder sbQuery = new StringBuilder(); sbQuery.Append(" SELECT SALE.*,U_MASTER.*,U_JHOLDER.* FROM U_MASTER INNER JOIN SALE "); sbQuery.Append(" ON U_MASTER.REG_BK = SALE.REG_BK AND U_MASTER.REG_BR = SALE.REG_BR AND U_MASTER.REG_NO = SALE.REG_NO LEFT OUTER JOIN"); sbQuery.Append(" U_JHOLDER ON U_MASTER.REG_BK = U_JHOLDER.REG_BK AND U_MASTER.REG_BR = U_JHOLDER.REG_BR AND U_MASTER.REG_NO = U_JHOLDER.REG_NO"); sbQuery.Append(" WHERE (SALE.REG_BR = '" + regObj.BranchCode.ToString() + "') AND (SALE.SL_NO = " + saleObj.SaleNo + ") AND (SALE.REG_BK = '" + regObj.FundCode.ToString() + "')"); DataTable dtGetSaleInfo = commonGatewayObj.Select(sbQuery.ToString()); return(dtGetSaleInfo); }
protected void findButton_Click(object sender, EventArgs e) { displayRegInfo(); UnitSale saleObj = new UnitSale(); UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(regObj, userObj).ToString(); saleObj.SaleNo = opendMFDAO.GetMaxSaleNo(regObj) - 1; }
public bool IsDuplicateSale(UnitHolderRegistration regObj, UnitSale saleObj) { DataTable dtSale = commonGatewayObj.Select("SELECT * FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND SL_NO=" + Convert.ToInt32(saleObj.SaleNo)); if (dtSale.Rows.Count > 0) { return(true); } else { return(false); } }
protected void findButton_Click(object sender, EventArgs e) { displayRegInfo(); UnitSale saleObj = new UnitSale(); UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(regObj, userObj).ToString(); // MoneyReceiptNoTextBox.Text = unitSaleBLObj.getNextMoneReceiptNo(regObj, userObj).ToString(); saleObj.SaleNo = opendMFDAO.GetMaxSaleNo(regObj) - 1; saleDateTextBox.Text = opendMFDAO.getLastSaleDate(regObj, saleObj).ToString("dd-MMM-yyyy"); saleRateTextBox.Text = opendMFDAO.getLastSaleRate(regObj, saleObj).ToString(); }
public DataTable dtGetSaleInfo(UnitHolderRegistration regObj, UnitSale saleObj) { StringBuilder sbQuery = new StringBuilder(); sbQuery.Append(" SELECT SALE.SL_NO, SALE.SL_DT, SALE.REG_NO, SALE.SL_PRICE, SALE.QTY, SALE.SL_TYPE, SALE.MONY_RECT_NO, SALE.PAY_TYPE, SALE.CHQ_DD_NO,"); sbQuery.Append(" SALE.CASH_AMT, SALE.BANK_CODE, SALE.BRANCH_CODE, SALE.MULTI_PAY_REMARKS, SALE.CHEQUE_DT, SALE_CERT.CERT_TYPE AS DINO,SALE_CERT.ROWID,"); sbQuery.Append(" SALE_CERT.CERT_NO, SALE_CERT.CERTIFICATE, SALE_CERT.QTY AS CERT_WEIGHT, SALE.REG_BK, SALE.REG_BR, U_MASTER.HNAME, "); sbQuery.Append(" U_JHOLDER.JNT_NAME, U_MASTER.ADDRS1, U_MASTER.ADDRS2,U_MASTER.TEL_NO, U_MASTER.CITY, U_MASTER.CIP , SALE_CERT.STATUS_FLAG FROM U_MASTER INNER JOIN SALE INNER JOIN "); sbQuery.Append(" SALE_CERT ON SALE.SL_NO = SALE_CERT.SL_NO AND SALE.REG_BK = SALE_CERT.REG_BK AND SALE.REG_BR = SALE_CERT.REG_BR ON "); sbQuery.Append(" U_MASTER.REG_BK = SALE.REG_BK AND U_MASTER.REG_BR = SALE.REG_BR AND U_MASTER.REG_NO = SALE.REG_NO LEFT OUTER JOIN"); sbQuery.Append(" U_JHOLDER ON U_MASTER.REG_BK = U_JHOLDER.REG_BK AND U_MASTER.REG_BR = U_JHOLDER.REG_BR AND U_MASTER.REG_NO = U_JHOLDER.REG_NO"); sbQuery.Append(" WHERE (SALE.REG_BR = '" + regObj.BranchCode.ToString() + "') AND (SALE.SL_NO = " + saleObj.SaleNo + ") AND (SALE.REG_BK = '" + regObj.FundCode.ToString() + "')"); DataTable dtGetSaleInfo = commonGatewayObj.Select(sbQuery.ToString()); return(dtGetSaleInfo); }
protected void DeleteButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text.ToString(); regObj.BranchCode = branchCodeTextBox.Text.ToString(); regObj.RegNumber = regNoTextBox.Text.Trim().ToString(); UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); try { if (unitSaleBLObj.IsValidSaleNumber(regObj, saleObj)) { DataTable dtSaleInfo = unitSaleBLObj.dtGetSaleInfoCDS(regObj, saleObj); if (dtSaleInfo.Rows.Count > 0) { unitSaleBLObj.DeleteSaleEditInfoCDS(regObj, saleObj, userObj); SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString(); tdCIP.InnerHtml = ""; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Sale Informaion Deleted');", true); } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Sale Information is not Available');", true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Sale Number');", true); } } catch (Exception ex) { errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
public void DeleteSaleEditInfoCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { StringBuilder sbQuery = new StringBuilder(); try { commonGatewayObj.BeginTransaction(); commonGatewayObj.DeleteByCommand("SALE", "SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); sbQuery.Append(" INSERT INTO SALE_ED_INFO ( SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, "); sbQuery.Append(" CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT,USER_NM, EDIT_TYPE, ENT_DT ) "); sbQuery.Append(" SELECT SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT, "); sbQuery.Append(" '" + unitUserObj.UserID + "' USER_NM,'D' EDIT_TYPE ,'" + DateTime.Now.ToString("dd-MMM-yyyy") + "' ENT_DT FROM SALE "); sbQuery.Append(" WHERE SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void displayRegInfo() { UnitSale saleObj = new UnitSale(); UnitHolderRegistration unitRegObj = new UnitHolderRegistration(); unitRegObj.FundCode = fundCodeTextBox.Text.Trim(); unitRegObj.BranchCode = branchCodeTextBox.Text.Trim(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); DataTable dtDino = unitSaleBLObj.getTableDinoForEdit(); if (unitSaleBLObj.IsValidSaleNumber(unitRegObj, saleObj)) { DataTable dtSaleInfo = unitSaleBLObj.dtGetSaleInfo(unitRegObj, saleObj); if (dtSaleInfo.Rows.Count > 0) { dinoGridView.Visible = true; regNoTextBox.Text = dtSaleInfo.Rows[0]["REG_NO"].ToString(); holderNameTextBox.Text = dtSaleInfo.Rows[0]["HNAME"].ToString(); jHolderTextBox.Text = dtSaleInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["JNT_NAME"].ToString(); holderAddress1TextBox.Text = dtSaleInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["ADDRS1"].ToString(); holderAddress2TextBox.Text = dtSaleInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["ADDRS2"].ToString(); holderTelphoneTextBox.Text = dtSaleInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["TEL_NO"].ToString(); string CIP = dtSaleInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CIP"].ToString(); if (string.Compare(CIP, "Y", true) == 0) { tdCIP.InnerHtml = " YES "; } else if (string.Compare(CIP, "N", true) == 0) { tdCIP.InnerHtml = " NO "; } displaySign(); MoneyReceiptNoTextBox.Text = dtSaleInfo.Rows[0]["MONY_RECT_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["MONY_RECT_NO"].ToString(); saleDateTextBox.Text = dtSaleInfo.Rows[0]["SL_DT"].Equals(DBNull.Value) ? "" :Convert.ToDateTime(dtSaleInfo.Rows[0]["SL_DT"].ToString()).ToString("dd-MMM-yyyy"); saleRateTextBox.Text = dtSaleInfo.Rows[0]["SL_PRICE"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_PRICE"].ToString(); saleTypeDropDownList.SelectedValue = dtSaleInfo.Rows[0]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_TYPE"].ToString(); unitQtyTextBox.Text = dtSaleInfo.Rows[0]["QTY"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["QTY"].ToString(); if (dtSaleInfo.Rows[0]["PAY_TYPE"].Equals(DBNull.Value)) { } else { string payType = dtSaleInfo.Rows[0]["PAY_TYPE"].ToString(); if (payType.ToString().ToUpper() == "CHQ" || payType.ToString().ToUpper() == "DD" || payType.ToString().ToUpper() == "PO") { ChqRadioButton.Checked = true; ChequeTypeDropDownList.SelectedValue = dtSaleInfo.Rows[0]["PAY_TYPE"].ToString(); bankNameDropDownList.Enabled = true; branchNameDropDownList.Enabled = true; CashAmountTextBox.Enabled = false; MultiplePayTypeTextBox.Enabled = false; CHQDDNoRemarksTextBox.Enabled = true; bankNameDropDownList.SelectedValue = dtSaleInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value)? "0":dtSaleInfo.Rows[0]["BANK_CODE"].ToString(); branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtSaleInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BANK_CODE"].ToString())); branchNameDropDownList.DataTextField = "BRANCH_NAME"; branchNameDropDownList.DataValueField = "BRANCH_CODE"; branchNameDropDownList.DataBind(); branchNameDropDownList.SelectedValue = dtSaleInfo.Rows[0]["BRANCH_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BRANCH_CODE"].ToString(); CHQDDNoRemarksTextBox.Text = dtSaleInfo.Rows[0]["CHQ_DD_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHQ_DD_NO"].ToString(); chequeDateTextBox.Text = dtSaleInfo.Rows[0]["CHEQUE_DT"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHEQUE_DT"].ToString(); } } dinoGridView.DataSource = dtSaleInfo; dinoGridView.DataBind(); Session["dtSaleInfo"] = dtSaleInfo; } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Sale Information is not Available');", true); } } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Sale Number');", true); } }
protected void SaveButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; regObj.RegNumber = regNoTextBox.Text; UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); if (MoneyReceiptNoTextBox.Text.Trim() != "") { saleObj.MoneyReceiptNo = Convert.ToInt32(MoneyReceiptNoTextBox.Text.Trim()); } if (ChqRadioButton.Checked) { saleObj.PaymentType = ChequeTypeDropDownList.SelectedValue.ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" && branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } } else if (CashRadioButton.Checked) { saleObj.PaymentType = "CASH"; saleObj.CashAmount = Convert.ToDecimal(Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()) * Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())); } else if (BothRadioButton.Checked) { saleObj.PaymentType = "BOTH"; saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" || branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } if (CashAmountTextBox.Text.Trim() != "") { saleObj.CashAmount = Convert.ToDecimal(CashAmountTextBox.Text.Trim().ToString()); } } else if (MultiRadioButton.Checked) { saleObj.PaymentType = "MULTI"; if (MultiplePayTypeTextBox.Text.Trim() != "") { saleObj.MultiPayType = MultiplePayTypeTextBox.Text.Trim().ToString(); } } saleObj.SaleRate = Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()); saleObj.SaleType = saleTypeDropDownList.SelectedValue.ToString().ToUpper(); saleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()); saleObj.SaleDate = saleDateTextBox.Text.Trim().ToString(); saleObj.SaleRemarks = saleRemarksTextBox.Text.Trim().ToString(); int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj); long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj); try { if (unitSaleBLObj.IsSaleLock(regObj))//Cheking Lock in status { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Sale Operation is Locked " + "');", true); } else if (unitSaleBLObj.IsDuplicateSale(regObj, saleObj))// Checking Duplicate Sale No { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Sale Number " + "');", true); } else if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true); } else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())) { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + "');", true); } else { unitSaleBLObj.SaveUnitSaleCDS(regObj, saleObj, userObj); ClearText(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true); } } catch (Exception ex) { errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
protected void addListButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; dvContent.Visible = true; dinoGridView.Visible = true; int unitQty = 0; int certNo = 0; DataTable dtDinomination = opendMFDAO.getTableDinomination(); DataRow drDinomination = dtDinomination.NewRow(); int certQty = 0; if (kTextBox.Text != "") { if (string.Compare(fundCodeTextBox.Text.Trim().ToString(), "BDF") == 0) { certNo = opendMFDAO.GetMaxCertNo("K", regObj, userObj); certQty = Convert.ToInt32(kTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "K"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "10000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 10000); } } if (jTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("J", regObj, userObj); certQty = Convert.ToInt32(jTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "J"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "5000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 5000); } if (iTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("I", regObj, userObj); certQty = Convert.ToInt32(iTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "I"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "1000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 1000); } if (hTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("H", regObj, userObj); certQty = Convert.ToInt32(hTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "H"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "500"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 500); } if (gTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("G", regObj, userObj); certQty = Convert.ToInt32(gTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "G"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "250"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 250); } if (fTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("F", regObj, userObj); certQty = Convert.ToInt32(fTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "F"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "100"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 100); } if (eTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("E", regObj, userObj); certQty = Convert.ToInt32(eTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "E"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "50"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 50); } if (dTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("D", regObj, userObj); certQty = Convert.ToInt32(dTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "D"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "20"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 20); } if (cTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("C", regObj, userObj); certQty = Convert.ToInt32(cTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "C"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "10"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 10); } if (bTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("B", regObj, userObj); certQty = Convert.ToInt32(bTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "B"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "5"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 5); } if (aTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("A", regObj, userObj); certQty = Convert.ToInt32(aTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "A"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "1"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 1); } UnitSale unitSaleObj = new UnitSale(); if (unitQty == 0) { unitSaleObj.SaleUnitQty = Convert.ToInt32(renewalUnitsTextBox.Text); dtDinomination = opendMFDAO.dtDinomination(unitSaleObj.SaleUnitQty, regObj, userObj); dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); Session["dtDinomination"] = dtDinomination; } else if (unitQty > 0) { if (Convert.ToInt32(renewalUnitsTextBox.Text) != unitQty) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('Unit Quantity and Dinomination Quantity is not Equal');", true); dtDinomination = new DataTable();; dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); //Session["dtDinomination"] = dtDinomination; } else { dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); Session["dtDinomination"] = dtDinomination; } } }
protected void ExportReportButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObject = new UnitHolderRegistration(); regObject.FundCode = fundCodeTextBox.Text.Trim().ToString(); regObject.BranchCode = branchCodeTextBox.Text.Trim().ToString(); string[] BranchCode = branchCodeTextBox.Text.Trim().ToString().Split('/'); string fileName = fundCodeTextBox.Text.Trim().ToString() + "_" + BranchCode[0].ToString() + "_" + BranchCode[1].ToString() + "_TR_"; if (fromTrNoTextBox.Text != "" && toTrNoTextBox.Text != "") { fileName = fileName + fromTrNoTextBox.Text.Trim().ToString() + "_" + toTrNoTextBox.Text.Trim().ToString(); } else if (fromTrNoTextBox.Text != "" && toTrNoTextBox.Text == "") { int MaxTrNo = unitTrObj.getMaxTRNo(regObject); MaxTrNo = MaxTrNo - 1; fileName = fileName + fromTrNoTextBox.Text.Trim().ToString() + "_" + MaxTrNo.ToString(); } else if (fromTrNoTextBox.Text == "" && toTrNoTextBox.Text != "") { fileName = fileName + "1_" + toTrNoTextBox.Text.Trim().ToString(); } else if (fromRegNoTextBox.Text != "" && toRegNoTextBox.Text != "") { fileName = fileName + "REG_"; fileName = fileName + fromRegNoTextBox.Text.Trim().ToString() + "_" + toRegNoTextBox.Text.Trim().ToString(); } else if (fromRegNoTextBox.Text != "" && toRegNoTextBox.Text == "") { fileName = fileName + "REG_"; int MaxRegNo = unitHolderRegBLObj.GetMaxRegNo(regObject); MaxRegNo = MaxRegNo - 1; fileName = fileName + fromRegNoTextBox.Text.Trim().ToString() + "_" + MaxRegNo.ToString(); } else if (fromRegNoTextBox.Text == "" && toRegNoTextBox.Text != "") { fileName = fileName + "REG_"; fileName = fileName + "1_" + toRegNoTextBox.Text.Trim().ToString(); } //else if (fromSaleDateTextBox.Text != "" && toSaleDateTextBox.Text != "") //{ // sbFilter.Append(" AND ( SL_DT BETWEEN '" + Convert.ToDateTime(fromSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "' AND '" + Convert.ToDateTime(toSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')"); //} //else if (fromSaleDateTextBox.Text != "" && toSaleDateTextBox.Text == "") //{ // sbFilter.Append(" AND ( SL_DT => '" + Convert.ToDateTime(fromSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')"); //} //else if (fromSaleDateTextBox.Text == "" && toSaleDateTextBox.Text != "") //{ // sbFilter.Append(" AND (SL_DT <= '" + Convert.ToDateTime(toSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')"); //} //else if (saleTypeDropDownList.SelectedValue.ToString() != "0") //{ // sbFilter.Append(" AND SL_TYPE='" + saleTypeDropDownList.SelectedValue.ToString() + "'"); //} UnitSale saleObj = new UnitSale(); string fileDirectory = ConfigReader.ExportFileLocation.ToString(); StreamWriter swFile = new StreamWriter(fileDirectory + "\\" + fileName + ".txt"); StringBuilder sbFileHeader = new StringBuilder(); StringBuilder sbFileData = new StringBuilder(); sbFileHeader.Append("F_CD~BR_CODE~TR_NO~TR_DT~REG_BK_O~REG_BR_O~REG_NO_O~QTY~TR_USER_NM~TR_ENT_DT~TR_ENT_TM~OLD_SL_TR_NO~"); sbFileHeader.Append("REG_BK~REG_BR~REG_NO~REG_DT~REG_TYPE~HNAME~FMH_NAME~ADDRS1~ADDRS2~CITY~"); sbFileHeader.Append("B_DATE~SEX~MAR_STAT~RELIGION~EDU_QUA~TEL_NO~EMAIL~OPN_BAL~BALANCE~CIP~ID_FLAG~ID_AC~BK_FLAG~DIVIDEND~"); sbFileHeader.Append("CIP_DIV~TOT_DIV~USER_NM~ENT_DT~REMARKS~ENT_TM~NOMI1_REL~NOMI2_REL~NATIONALITY~OCC_CODE~BK_AC_NO~BK_NM_CD~"); sbFileHeader.Append("BK_BR_NM_CD~ID_BK_NM_CD~ID_BK_BR_NM_CD~MO_NAME~JNT_NO~JNT_NAME~JNT_FMH_NAME~JNT_OCC_CODE~JNT_ADDRS1~"); sbFileHeader.Append("JNT_ADDRS2~JNT_NATIONALITY~JNT_CITY~JNT_TEL_NO~JNT_FMH_REL~JNT_MO_NAME~"); //FileHeader.Append("USER_NM~ENT_DT~ENT_TM~MONY_RECT_NO~PAY_TYPE~CHQ_DD_NO~CASH_AMT~BANK_CODE~BRANCH_CODE~MULTI_PAY_REMARKS~CHEQUE_DT~"); sbFileHeader.Append("NOMI1_NO~NOMI1_NAME~NOMI1_FMH_NAME~NOMI1_OCC_CODE~NOMI1_ADDRS1~NOMI1_REL~NOMI1_PERCENTAGE~NOMI1_ADDRS2~"); sbFileHeader.Append("NOMI1_REAMARKS~NOMI1_NATIONALITY~NOMI1_CITY~NOMI_CTL_NO~NOMI1_MO_NAME~"); sbFileHeader.Append("NOMI2_NO~NOMI2_NAME~NOMI2_FMH_NAME~NOMI2_OCC_CODE~NOMI2_ADDRS1~NOMI2_REL~NOMI2_PERCENTAGE~NOMI2_ADDRS2~"); sbFileHeader.Append("NOMI2_REAMARKS~NOMI2_NATIONALITY~NOMI2_CITY~NOMI2_MO_NAME~TR_CERTIFICATE"); sbFileHeader.Append("\r\n"); try { DataTable dtSaleWithRegInfo = dtGetTransferWithRegInfo(); if (dtSaleWithRegInfo.Rows.Count > 0) { for (int loop = 0; loop < dtSaleWithRegInfo.Rows.Count; loop++) { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["TR_DT"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BK_O"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BR_O"].ToString() + "~"); sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REG_NO_O"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["QTY"].ToString() + "~"); if (dtSaleWithRegInfo.Rows[loop]["TR_USER_NM"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_USER_NM"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["TR_ENT_DT"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_ENT_DT"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["TR_ENT_TM"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_ENT_TM"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].ToString() + "~"); } sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REG_BK"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BR"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_NO"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_DT"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_TYPE"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["HNAME"].ToString() + "~"); if (dtSaleWithRegInfo.Rows[loop]["FMH_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["FMH_NAME"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ADDRS1"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ADDRS1"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ADDRS2"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ADDRS2"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["CITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CITY"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["B_DATE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["B_DATE"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["SEX"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["SEX"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["MAR_STAT"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["MAR_STAT"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["RELIGION"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["RELIGION"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["EDU_QUA"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["EDU_QUA"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["TEL_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TEL_NO"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["EMAIL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["EMAIL"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["OPN_BAL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OPN_BAL"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["BALANCE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BALANCE"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["CIP"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CIP"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ID_FLAG"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_FLAG"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ID_AC"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_AC"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["BK_FLAG"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_FLAG"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["DIVIDEND"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["DIVIDEND"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["CIP_DIV"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CIP_DIV"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["TOT_DIV"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TOT_DIV"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["USER_NM"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["USER_NM"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ENT_DT"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ENT_DT"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["REMARKS"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REMARKS"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ENT_TM"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ENT_TM"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["NOMI1_REL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NOMI1_REL"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["NOMI2_REL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NOMI2_REL"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["NATIONALITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NATIONALITY"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["OCC_CODE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OCC_CODE"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["BK_AC_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_AC_NO"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["BK_NM_CD"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_NM_CD"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["BK_BR_NM_CD"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_BR_NM_CD"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ID_BK_NM_CD"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_BK_NM_CD"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["ID_BK_BR_NM_CD"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_BK_BR_NM_CD"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["MO_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["MO_NAME"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NO"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NAME"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_FMH_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_FMH_NAME"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_OCC_CODE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_OCC_CODE"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS1"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS1"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS2"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS2"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_NATIONALITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NATIONALITY"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_CITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_CITY"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_TEL_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_TEL_NO"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_FMH_REL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_FMH_REL"].ToString() + "~"); } if (dtSaleWithRegInfo.Rows[loop]["JNT_MO_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_MO_NAME"].ToString() + "~"); } regObj.FundCode = dtSaleWithRegInfo.Rows[loop]["REG_BK"].ToString(); regObj.BranchCode = dtSaleWithRegInfo.Rows[loop]["REG_BR"].ToString(); regObj.RegNumber = dtSaleWithRegInfo.Rows[loop]["REG_NO"].ToString(); DataTable dtNomineeRegInfo = opendMFDAO.dtNomineeRegInfo(regObj); if (dtNomineeRegInfo.Rows.Count > 0) { sbFileData.Append("1~"); if (dtNomineeRegInfo.Rows[0]["NOMI_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_NAME"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_REL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_REL"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["PERCENTAGE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["PERCENTAGE"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].ToString() + "~"); } sbFileData.Append(" ~"); if (dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].ToString() + "~"); } sbFileData.Append(" ~"); if (dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].ToString() + "~"); } } if (dtNomineeRegInfo.Rows.Count > 1) { sbFileData.Append("2~"); if (dtNomineeRegInfo.Rows[1]["NOMI_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_NAME"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["NOMI_REL"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_REL"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["PERCENTAGE"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["PERCENTAGE"].ToString() + "~"); } if (dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].ToString() + "~"); } sbFileData.Append(" ~"); if (dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].ToString() + "~"); } sbFileData.Append(" ~"); if (dtNomineeRegInfo.Rows[1]["NOMI_MO_NAME"].Equals(DBNull.Value)) { sbFileData.Append(" ~"); } else { sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_MO_NAME"].ToString() + "~"); } } if (dtNomineeRegInfo.Rows.Count <= 0) { sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); } if (dtNomineeRegInfo.Rows.Count == 1) { sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); sbFileData.Append(" ~"); } string OLD_SL_TR_NO = dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].Equals(DBNull.Value) ? "" : dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].ToString(); string queryString = ""; if (OLD_SL_TR_NO != "") { queryString = "SELECT * FROM TRANS_CERT WHERE TR_NO=" + Convert.ToInt32(dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString()) + " AND BR_CODE='" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "' AND F_CD='" + dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "' AND OLD_SL_TR_NO='" + OLD_SL_TR_NO.ToString() + "'"; } else { queryString = "SELECT * FROM TRANS_CERT WHERE TR_NO=" + Convert.ToInt32(dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString()) + " AND BR_CODE='" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "' AND F_CD='" + dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "'"; } string trCertificate = reportObj.getTotalCertNo(queryString.ToString(), dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString()); if (trCertificate != "") { sbFileData.Append(trCertificate.ToString()); } else { sbFileData.Append(" ~"); } sbFileData.Append("\r\n"); } sbFileHeader.Append(sbFileData.ToString()); swFile.Write(sbFileHeader.ToString()); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Data Exported Successfully');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found ');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Data Export Failed Due to Eror:" + ex.ToString() + " ');", true); } finally { swFile.Close(); } }
protected void SaveButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; regObj.RegNumber = regNoTextBox.Text; UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); if (moneyReceipDropDownList.SelectedValue.ToString() != "0") { saleObj.MoneyReceiptNo = Convert.ToInt32(moneyReceipDropDownList.SelectedItem.Text.ToString()); } if (ChqRadioButton.Checked) { saleObj.PaymentType = ChequeTypeDropDownList.SelectedValue.ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" && branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } } else if (CashRadioButton.Checked) { saleObj.PaymentType = "CASH"; saleObj.CashAmount = Convert.ToDecimal(Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()) * Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())); } else if (BothRadioButton.Checked) { saleObj.PaymentType = "BOTH"; saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" || branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } if (CashAmountTextBox.Text.Trim() != "") { saleObj.CashAmount = Convert.ToDecimal(CashAmountTextBox.Text.Trim().ToString()); } } else if (MultiRadioButton.Checked) { saleObj.PaymentType = "MULTI"; if (MultiplePayTypeTextBox.Text.Trim() != "") { saleObj.MultiPayType = MultiplePayTypeTextBox.Text.Trim().ToString(); } } saleObj.SaleRate = Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()); saleObj.SaleType = saleTypeDropDownList.SelectedValue.ToString().ToUpper(); saleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()); saleObj.SaleDate = saleDateTextBox.Text.Trim().ToString(); saleObj.SaleRemarks = saleRemarksTextBox.Text.Trim().ToString(); saleObj.SellingAgentCode = Convert.ToInt32(sellingAgentCodeTextBox.Text.Trim().ToString()); int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj); long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj); try { if (unitSaleBLObj.IsSaleLock(regObj))//Cheking Lock in status { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Sale Operation is Locked " + "');", true); } else if (unitSaleBLObj.IsDuplicateSale(regObj, saleObj))// Checking Duplicate Sale No { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Sale Number " + "');", true); } else if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true); } else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())) { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + "');", true); } else { int rowNumber = 1; int line = 0; DataTable dtDino = opendMFDAO.getTableDinomination(); DataRow drDino; bool invalidCert = false; bool allocateCert = true; bool bannedCert = false; int duplicateCerNoReg = 0; string dino = ""; string cerNo = ""; foreach (DataGridItem gridItem in dinoGridView.Items) { drDino = dtDino.NewRow(); TextBox txtDino = null; TextBox txtCert = null; TextBox txtWeight = null; txtDino = (TextBox)(gridItem.FindControl("dinoTextBox")); txtCert = (TextBox)(gridItem.FindControl("certNoTextBox")); txtWeight = (TextBox)(gridItem.FindControl("weightTextBox")); duplicateCerNoReg = opendMFDAO.duplicateCerNoReg(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); allocateCert = unitSaleBLObj.IsCertificateAllocate(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); bannedCert = unitSaleBLObj.IsCertificateBanned(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); if (duplicateCerNoReg == 0) { if (saleTypeDropDownList.SelectedValue.ToString().ToUpper() == "CIP") { if (opendMFDAO.validationDino(txtDino.Text.ToString().ToUpper(), regObj.FundCode.ToString().ToUpper())) { if (allocateCert) { if (bannedCert) { bannedCert = true; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } else { drDino["dino"] = txtDino.Text.Trim().ToString().ToUpper(); drDino["cert_no"] = Convert.ToInt32(txtCert.Text.Trim().ToString()); drDino["cert_weight"] = Convert.ToInt32(txtWeight.Text.Trim().ToString()); dtDino.Rows.Add(drDino); rowNumber++; } } else { allocateCert = false; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } } else { invalidCert = true; line = rowNumber; break; } } else if (saleTypeDropDownList.SelectedValue.ToString().ToUpper() == "SL") { if (opendMFDAO.validationDino(txtDino.Text.ToString().ToUpper(), regObj.FundCode.ToString().ToUpper()) && opendMFDAO.validationWeight(Convert.ToInt32(txtWeight.Text.ToString()), regObj.FundCode.ToString().ToUpper())) { if (allocateCert) { if (bannedCert) { bannedCert = true; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } else { drDino["dino"] = txtDino.Text.Trim().ToString().ToUpper(); drDino["cert_no"] = Convert.ToInt32(txtCert.Text.Trim().ToString()); drDino["cert_weight"] = Convert.ToInt32(txtWeight.Text.Trim().ToString()); dtDino.Rows.Add(drDino); rowNumber++; } } else { allocateCert = false; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } } else { invalidCert = true; line = rowNumber; break; } } } else { dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } } if (duplicateCerNoReg > 0) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Certificate " + dino + "-" + cerNo + " is Already Sold to Reg No:" + duplicateCerNoReg + "');", true); } else { if (invalidCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!!Invalid Dinomination or Weight at Line: " + line + "');", true); } else if (!allocateCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is not allocated in this branch');", true); } else if (bannedCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is banned for sale');", true); } else if (!invalidCert && allocateCert && !bannedCert) { commonGatewayObj.BeginTransaction(); commonGatewayObj.ExecuteNonQuery("UPDATE U_MASTER SET SELLING_AGENT_ID=" + saleObj.SellingAgentCode + " WHERE REG_BK='" + regObj.FundCode + "' AND REG_BR='" + regObj.BranchCode + "' AND REG_NO='" + regObj.RegNumber + "' AND SELLING_AGENT_ID IS NULL"); commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + saleObj.SaleNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString())); unitSaleBLObj.SaveUnitSale(regObj, saleObj, dtDino, userObj); commonGatewayObj.CommitTransaction(); ClearText(); moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptInfoforDDL(regObj, "SL"); moneyReceipDropDownList.DataTextField = "RECEIPT_NO"; moneyReceipDropDownList.DataValueField = "ID"; moneyReceipDropDownList.DataBind(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true); } } } } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
protected void DeleteButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text.ToString(); regObj.BranchCode = branchCodeTextBox.Text.ToString(); regObj.RegNumber = regNoTextBox.Text.Trim().ToString(); UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); try { if (unitSaleBLObj.IsValidSaleNumber(regObj, saleObj)) { DataTable dtSaleInfo = unitSaleBLObj.dtGetSaleInfo(regObj, saleObj); if (dtSaleInfo.Rows.Count > 0) { saleObj.MoneyReceiptNo = Convert.ToInt32(dtSaleInfo.Rows[0]["MONY_RECT_NO"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["MONY_RECT_NO"].ToString()); saleObj.SaleDate = dtSaleInfo.Rows[0]["SL_DT"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_DT"].ToString(); saleObj.SaleRate = decimal.Parse(dtSaleInfo.Rows[0]["SL_PRICE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["SL_PRICE"].ToString()); saleObj.SaleType = dtSaleInfo.Rows[0]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_TYPE"].ToString(); saleObj.SaleUnitQty = Convert.ToInt32(dtSaleInfo.Rows[0]["QTY"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["QTY"].ToString()); if (dtSaleInfo.Rows[0]["PAY_TYPE"].Equals(DBNull.Value)) { } else { string payType = dtSaleInfo.Rows[0]["PAY_TYPE"].ToString(); if (payType.ToString().ToUpper() == "CHQ" || payType.ToString().ToUpper() == "DD" || payType.ToString().ToUpper() == "PO") { saleObj.PaymentType = payType; saleObj.ChequeNo = dtSaleInfo.Rows[0]["CHQ_DD_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHQ_DD_NO"].ToString(); saleObj.ChequeDate = dtSaleInfo.Rows[0]["CHEQUE_DT"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHEQUE_DT"].ToString(); saleObj.BankCode = Convert.ToInt16(dtSaleInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BANK_CODE"].ToString()); saleObj.BranchCode = Convert.ToInt16(dtSaleInfo.Rows[0]["BRANCH_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BRANCH_CODE"].ToString()); saleObj.CashAmount = Convert.ToDecimal(dtSaleInfo.Rows[0]["CASH_AMT"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["CASH_AMT"].ToString()); saleObj.SaleRemarks = dtSaleInfo.Rows[0]["MULTI_PAY_REMARKS"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["MULTI_PAY_REMARKS"].ToString(); } } DataTable dtDinomination = unitSaleBLObj.dtGetExistingSaleCertBySaleNo(regObj, saleObj); if (dtDinomination.Rows.Count > 0) { unitSaleBLObj.DeleteSaleEditInfo(regObj, saleObj, dtDinomination, userObj); SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString(); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Sale Informaion Deleted');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Delete is not possible due to certificate are surrendered or Transferred');", true); } } else { SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString()); tdCIP.InnerHtml = ""; dinoGridView.Visible = false; ClearText(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Sale Information is not Available');", true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Sale Number');", true); } } catch (Exception ex) { errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
protected void SaveButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; regObj.RegNumber = regNoTextBox.Text; UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); if (moneyReceipDropDownList.SelectedValue.ToString() != "0") { saleObj.MoneyReceiptNo = Convert.ToInt32(moneyReceipDropDownList.SelectedItem.Text.ToString()); } if (ChqRadioButton.Checked) { saleObj.PaymentType = ChequeTypeDropDownList.SelectedValue.ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" && branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } } else if (CashRadioButton.Checked) { saleObj.PaymentType = "CASH"; saleObj.CashAmount = Convert.ToDecimal(Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()) * Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())); } else if (BothRadioButton.Checked) { saleObj.PaymentType = "BOTH"; saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" || branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } if (CashAmountTextBox.Text.Trim() != "") { saleObj.CashAmount = Convert.ToDecimal(CashAmountTextBox.Text.Trim().ToString()); } } else if (MultiRadioButton.Checked) { saleObj.PaymentType = "MULTI"; if (MultiplePayTypeTextBox.Text.Trim() != "") { saleObj.MultiPayType = MultiplePayTypeTextBox.Text.Trim().ToString(); } } saleObj.SaleRate = Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()); saleObj.SaleType = saleTypeDropDownList.SelectedValue.ToString().ToUpper(); saleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()); saleObj.SaleDate = saleDateTextBox.Text.Trim().ToString(); saleObj.SaleRemarks = saleRemarksTextBox.Text.Trim().ToString(); int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj); long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj); try { if (unitSaleBLObj.IsSaleLock(regObj))//Cheking Lock in status { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Sale Operation is Locked " + "');", true); } else if (unitSaleBLObj.IsDuplicateSale(regObj, saleObj))// Checking Duplicate Sale No { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Sale Number " + "');", true); } else if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true); } else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())) { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + "');", true); } else { commonGatewayObj.BeginTransaction(); commonGatewayObj.ExecuteNonQuery("UPDATE U_MASTER SET SELLING_AGENT_ID=" + saleObj.SellingAgentCode + " WHERE REG_BK='" + regObj.FundCode + "' AND REG_BR='" + regObj.BranchCode + "' AND REG_NO='" + regObj.RegNumber + "' AND SELLING_AGENT_ID IS NULL"); commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + saleObj.SaleNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString())); unitSaleBLObj.SaveUnitSaleCDS(regObj, saleObj, userObj); commonGatewayObj.CommitTransaction(); ClearText(); moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptInfoforDDL(regObj, "SL"); moneyReceipDropDownList.DataTextField = "RECEIPT_NO"; moneyReceipDropDownList.DataValueField = "ID"; moneyReceipDropDownList.DataBind(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true); } } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
public void SaveUnitSaleCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { Hashtable htUnitSale = new Hashtable(); 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"); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public DataTable dtGetExistingSaleCertBySaleNo(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj) { DataTable dtDinomination = new DataTable(); DataTable dtSaleCertInfo = commonGatewayObj.Select("SELECT * FROM SALE_CERT WHERE SL_NO=" + unitSaleObj.SaleNo + " AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + unitRegObj.RegNumber); DataTable dtSaleCertWithStatusCheck = commonGatewayObj.Select("SELECT * FROM SALE_CERT WHERE SL_NO=" + unitSaleObj.SaleNo + " AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + unitRegObj.RegNumber + " AND VALID IS NULL AND STATUS_FLAG IS NULL "); if (dtSaleCertInfo.Rows.Count == dtSaleCertWithStatusCheck.Rows.Count) { dtDinomination = dtSaleCertInfo; } return(dtDinomination); }
public void DeleteSaleEditInfo(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(); 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())); htCertNoTemp.Add("SL_DT", Convert.ToDateTime(unitSaleObj.SaleDate).ToString("dd-MMM-yyyy")); htCertNoTemp.Add("SL_PRICE", Convert.ToDecimal(unitSaleObj.SaleRate.ToString())); htCertNoTemp.Add("QTY", Convert.ToInt32(unitSaleObj.SaleUnitQty.ToString())); htCertNoTemp.Add("SL_TYPE", unitSaleObj.SaleType.ToString().ToUpper()); if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0")) { htCertNoTemp.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo)); } else { htCertNoTemp.Add("MONY_RECT_NO", DBNull.Value); } if (unitSaleObj.PaymentType != null) { htCertNoTemp.Add("PAY_TYPE", unitSaleObj.PaymentType); } else { htCertNoTemp.Add("PAY_TYPE", DBNull.Value); } if (unitSaleObj.ChequeNo != null) { htCertNoTemp.Add("CHQ_DD_NO", unitSaleObj.ChequeNo); } else { htCertNoTemp.Add("CHQ_DD_NO", DBNull.Value); } if (unitSaleObj.ChequeDate == null || unitSaleObj.ChequeDate == "") { htCertNoTemp.Add("CHEQUE_DT", DBNull.Value); } else { htCertNoTemp.Add("CHEQUE_DT", Convert.ToDateTime(unitSaleObj.ChequeDate).ToString("dd-MMM-yyyy")); } if (!(unitSaleObj.BankCode.ToString() == "0")) { htCertNoTemp.Add("BANK_CODE", Convert.ToInt16(unitSaleObj.BankCode)); } else { htCertNoTemp.Add("BANK_CODE", DBNull.Value); } if (!(unitSaleObj.BranchCode.ToString() == "0")) { htCertNoTemp.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode)); } else { htCertNoTemp.Add("BRANCH_CODE", DBNull.Value); } if (!(unitSaleObj.CashAmount.ToString() == null)) { htCertNoTemp.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount)); } else { htCertNoTemp.Add("CASH_AMT", DBNull.Value); } if (unitSaleObj.MultiPayType != null) { htCertNoTemp.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType); } else { htCertNoTemp.Add("MULTI_PAY_REMARKS", DBNull.Value); } if (dtDinomination.Rows.Count > 0) { for (int looper = 0; looper < dtDinomination.Rows.Count; looper++) { if (certificate == "") { certificate = SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["CERT_NO"].ToString()), dtDinomination.Rows[looper]["CERT_TYPE"].ToString().ToUpper()); } else { certificate = certificate + "," + SaleCertNo(Convert.ToInt32(dtDinomination.Rows[looper]["CERT_NO"].ToString()), dtDinomination.Rows[looper]["CERT_TYPE"].ToString().ToUpper()); } } } if (certificate != "") { htCertNoTemp.Add("CERTIFICATE", certificate); } else { htCertNoTemp.Add("CERTIFICATE", DBNull.Value); } htCertNoTemp.Add("USER_NM", unitUserObj.UserID.ToString()); htCertNoTemp.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString()); htCertNoTemp.Add("ENT_DT", DateTime.Now.ToString()); htCertNoTemp.Add("EDIT_TYPE", "D"); commonGatewayObj.Insert(htCertNoTemp, "SALE_ED_INFO"); commonGatewayObj.DeleteByCommand("SALE", " SL_NO=" + unitSaleObj.SaleNo + " AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.DeleteByCommand("SALE_CERT", " SL_NO=" + unitSaleObj.SaleNo + " AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
public void SaveSaleEditInfoCDS(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj, UnitUser unitUserObj) { Hashtable htUnitSale = new Hashtable(); Hashtable htUnitSaleCert = new Hashtable(); StringBuilder sbQuery = new StringBuilder(); try { commonGatewayObj.BeginTransaction(); 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()); if (!(unitSaleObj.MoneyReceiptNo.ToString() == "0")) { htUnitSale.Add("MONY_RECT_NO", Convert.ToInt32(unitSaleObj.MoneyReceiptNo)); } else { htUnitSale.Add("MONY_RECT_NO", DBNull.Value); } if (!((unitSaleObj.MoneyReceiptNo.ToString() == "0") && unitSaleObj.PaymentType.ToString() == "CHQ" && unitSaleObj.ChequeNo == null && unitSaleObj.ChequeDate == null)) { htUnitSale.Add("PAY_TYPE", unitSaleObj.PaymentType); } else { htUnitSale.Add("PAY_TYPE", DBNull.Value); } if (unitSaleObj.ChequeNo != null) { htUnitSale.Add("CHQ_DD_NO", unitSaleObj.ChequeNo); } else { htUnitSale.Add("CHQ_DD_NO", DBNull.Value); } 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)); } else { htUnitSale.Add("BANK_CODE", DBNull.Value); } if (!(unitSaleObj.BranchCode.ToString() == "0")) { htUnitSale.Add("BRANCH_CODE", Convert.ToInt16(unitSaleObj.BranchCode)); } else { htUnitSale.Add("BRANCH_CODE", DBNull.Value); } if (!(unitSaleObj.CashAmount.ToString() == "0")) { htUnitSale.Add("CASH_AMT", Convert.ToDecimal(unitSaleObj.CashAmount)); } else { htUnitSale.Add("CASH_AMT", DBNull.Value); } if (unitSaleObj.MultiPayType != null) { htUnitSale.Add("MULTI_PAY_REMARKS", unitSaleObj.MultiPayType); } else { htUnitSale.Add("MULTI_PAY_REMARKS", DBNull.Value); } commonGatewayObj.Update(htUnitSale, "SALE", "SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' "); sbQuery.Append(" INSERT INTO SALE_ED_INFO ( SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, "); sbQuery.Append(" CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT,USER_NM, EDIT_TYPE, ENT_DT ) "); sbQuery.Append(" SELECT SL_NO, SL_DT, REG_BK, REG_BR, REG_NO, SL_PRICE, QTY, SL_TYPE, VALID, MONY_RECT_NO, PAY_TYPE, CHQ_DD_NO, CASH_AMT, BANK_CODE, BRANCH_CODE, MULTI_PAY_REMARKS, CHEQUE_DT, "); sbQuery.Append(" '" + unitUserObj.UserID + "' USER_NM,'E' EDIT_TYPE ,'" + DateTime.Now.ToString("dd-MMM-yyyy") + "' ENT_DT FROM SALE "); sbQuery.Append(" WHERE SL_NO=" + Convert.ToInt32(unitSaleObj.SaleNo.ToString()) + " AND REG_BK='" + unitRegObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber)); commonGatewayObj.ExecuteNonQuery(sbQuery.ToString()); commonGatewayObj.CommitTransaction(); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); throw ex; } }
protected void SaveButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; regObj.RegNumber = regNoTextBox.Text; UnitSale saleObj = new UnitSale(); saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString()); if (MoneyReceiptNoTextBox.Text.Trim() != "") { saleObj.MoneyReceiptNo = Convert.ToInt32(MoneyReceiptNoTextBox.Text.Trim()); } if (ChqRadioButton.Checked) { saleObj.PaymentType = ChequeTypeDropDownList.SelectedValue.ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" && branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } } else if (CashRadioButton.Checked) { saleObj.PaymentType = "CASH"; saleObj.CashAmount = Convert.ToDecimal(Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()) * Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())); } else if (BothRadioButton.Checked) { saleObj.PaymentType = "BOTH"; saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); if (CHQDDNoRemarksTextBox.Text.Trim() != "") { saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString(); } if (chequeDateTextBox.Text.Trim() != "") { saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString(); } if (bankNameDropDownList.SelectedValue.Trim() != "0") { saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString()); } if (branchNameDropDownList.SelectedValue.Trim() != "0" || branchNameDropDownList.SelectedValue.Trim() != "") { saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString()); } if (CashAmountTextBox.Text.Trim() != "") { saleObj.CashAmount = Convert.ToDecimal(CashAmountTextBox.Text.Trim().ToString()); } } else if (MultiRadioButton.Checked) { saleObj.PaymentType = "MULTI"; if (MultiplePayTypeTextBox.Text.Trim() != "") { saleObj.MultiPayType = MultiplePayTypeTextBox.Text.Trim().ToString(); } } saleObj.SaleRate = Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()); saleObj.SaleType = saleTypeDropDownList.SelectedValue.ToString().ToUpper(); saleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()); saleObj.SaleDate = saleDateTextBox.Text.Trim().ToString(); saleObj.SaleRemarks = saleRemarksTextBox.Text.Trim().ToString(); int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj); long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj); try { //if (unitSaleBLObj.IsDuplicateSale(regObj, saleObj))// Checking Duplicate Sale No //{ // ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " "+"Sale Number "+"');", true); //} //else if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true); } else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString())) { unitQtyTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + "');", true); } else if (!opendMFDAO.IsValidRegistration(regObj)) { regNoTextBox.Focus(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Invalid Registration Number!!');", true); } //else if (regObj.FundCode == "IAMPH") //{ // string errorMessage = "Please Contace with Administrator"; // ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed :" + errorMessage + "');", true); //} else { int loop = 0; DataTable dtSaleInfo = (DataTable)Session["dtSaleInfo"]; int rowNumber = 1; int line = 0; int countCheck = 0; DataTable dtDino = unitSaleBLObj.getTableDinoForEdit(); DataRow drDino; bool invalidCert = false; bool allocateCert = true; bool bannedCert = false; int duplicateCerNoReg = 0; string dino = ""; string cerNo = ""; foreach (DataGridItem gridItem in dinoGridView.Items) { drDino = dtDino.NewRow(); TextBox txtDino = null; TextBox txtCert = null; TextBox txtWeight = null; TextBox txtStatus = null; txtDino = (TextBox)(gridItem.FindControl("dinoTextBox")); txtCert = (TextBox)(gridItem.FindControl("certNoTextBox")); txtWeight = (TextBox)(gridItem.FindControl("weightTextBox")); txtStatus = (TextBox)(gridItem.FindControl("statusTextBox")); CheckBox leftCheckBox = (CheckBox)gridItem.FindControl("leftCheckBox"); if (leftCheckBox.Checked) { countCheck++; duplicateCerNoReg = opendMFDAO.duplicateCerNoReg(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); allocateCert = unitSaleBLObj.IsCertificateAllocate(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); bannedCert = unitSaleBLObj.IsCertificateBanned(regObj, txtDino.Text.ToString(), txtCert.Text.ToString()); if (duplicateCerNoReg == Convert.ToInt32(regNoTextBox.Text.Trim().ToString()) || duplicateCerNoReg == 0) { if (opendMFDAO.validationDino(txtDino.Text.ToString().ToUpper(), regObj.FundCode.ToString().ToUpper()) && opendMFDAO.validationWeight(Convert.ToInt32(txtWeight.Text.ToString()), regObj.FundCode.ToString().ToUpper())) { if (allocateCert) { if (bannedCert) { bannedCert = true; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } else { drDino["dino"] = txtDino.Text.Trim().ToString().ToUpper(); drDino["cert_no"] = Convert.ToInt32(txtCert.Text.Trim().ToString()); drDino["cert_weight"] = Convert.ToInt32(txtWeight.Text.Trim().ToString()); drDino["status"] = txtStatus.Text.Trim().ToString().ToUpper(); drDino["ROWID"] = dtSaleInfo.Rows[loop]["ROWID"].ToString(); dtDino.Rows.Add(drDino); rowNumber++; } } else { allocateCert = false; line = rowNumber; dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } } else { invalidCert = true; line = rowNumber; break; } } else { dino = txtDino.Text.Trim().ToString(); cerNo = txtCert.Text.Trim().ToString(); break; } } loop++; } if (duplicateCerNoReg > 0 && !(duplicateCerNoReg == Convert.ToInt32(regNoTextBox.Text.Trim().ToString()))) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Certificate " + dino + "-" + cerNo + " is Already Sold to Reg No:" + duplicateCerNoReg + "');", true); } else { if (invalidCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!!Invalid Dinomination or Weight at Line: " + line + "');", true); } else if (!allocateCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is not allocated in this branch');", true); } else if (bannedCert) { ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is banned for sale');", true); } else if (!invalidCert && allocateCert && !bannedCert) { unitSaleBLObj.SaveSaleEditInfo(regObj, saleObj, dtDino, userObj); ClearText(); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true); } } } } catch (Exception ex) { errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true); } }
protected void addListButton_Click(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); regObj.FundCode = fundCodeTextBox.Text; regObj.BranchCode = branchCodeTextBox.Text; regObj.RegIsCIP = saleTypeDropDownList.SelectedValue.ToString().ToUpper(); dinoGridView.Visible = true; int unitQty = 0; int certNo = 0; DataTable dtDinomination = opendMFDAO.getTableDinomination(); DataRow drDinomination = dtDinomination.NewRow(); int certQty = 0; int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj); long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj); if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { dtDinomination = new DataTable();; dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); unitQtyTextBox.Focus(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true); } else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL") { dtDinomination = new DataTable();; dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); unitQtyTextBox.Focus(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + " Pleas Contact AMCL Head Office to increase sale unit limit');", true); } else { if (string.Compare(regObj.FundCode.ToString(), "CFUF") == 0 || string.Compare(regObj.FundCode.ToString(), "IUF") == 0) { if (lTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("L", regObj, userObj); certQty = Convert.ToInt32(lTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "L"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "20000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 20000); } } if (string.Compare(regObj.FundCode.ToString(), "BDF") == 0 || string.Compare(regObj.FundCode.ToString(), "CFUF") == 0 || string.Compare(regObj.FundCode.ToString(), "IUF") == 0) { if (kTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("K", regObj, userObj); certQty = Convert.ToInt32(kTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "K"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "10000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 10000); } } if (jTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("J", regObj, userObj); certQty = Convert.ToInt32(jTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "J"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "5000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 5000); } if (iTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("I", regObj, userObj); certQty = Convert.ToInt32(iTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "I"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "1000"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 1000); } if (hTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("H", regObj, userObj); certQty = Convert.ToInt32(hTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "H"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "500"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 500); } if (gTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("G", regObj, userObj); certQty = Convert.ToInt32(gTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "G"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "250"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 250); } if (fTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("F", regObj, userObj); certQty = Convert.ToInt32(fTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "F"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "100"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 100); } if (eTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("E", regObj, userObj); certQty = Convert.ToInt32(eTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "E"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "50"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 50); } if (dTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("D", regObj, userObj); certQty = Convert.ToInt32(dTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "D"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "20"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 20); } if (cTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("C", regObj, userObj); certQty = Convert.ToInt32(cTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "C"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "10"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 10); } if (bTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("B", regObj, userObj); certQty = Convert.ToInt32(bTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "B"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "5"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 5); } if (aTextBox.Text != "") { certNo = opendMFDAO.GetMaxCertNo("A", regObj, userObj); certQty = Convert.ToInt32(aTextBox.Text.Trim()); for (int i = 0; i < certQty; i++) { drDinomination = dtDinomination.NewRow(); drDinomination["dino"] = "A"; drDinomination["cert_no"] = certNo; drDinomination["cert_weight"] = "1"; dtDinomination.Rows.Add(drDinomination); certNo++; } unitQty = unitQty + (certQty * 1); } UnitSale unitSaleObj = new UnitSale(); if (unitQty == 0) { unitSaleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text); dtDinomination = opendMFDAO.dtDinomination(unitSaleObj.SaleUnitQty, regObj, userObj); dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); Session["dtDinomination"] = dtDinomination; } else if (unitQty > 0) { if (Convert.ToInt32(unitQtyTextBox.Text) != unitQty) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Unit Quantity and Denomination Quantity is not Equal');", true); dtDinomination = new DataTable();; dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); } else { dinoGridView.DataSource = dtDinomination; dinoGridView.DataBind(); Session["dtDinomination"] = dtDinomination; } } } }