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