protected void SubmitButton_Click(object sender, EventArgs e)
{
Hashtable htUpdate = new Hashtable();
try
{
bool isDupliacteDRF = unitSaleBLObj.CheckDuplicateSaleRelatedInfo(" AND SALE.REG_BK='" + fundCode + "' AND SALE.DRF_ACCEPT_NO='" + DRFNoTextBox.Text + "'");
bool isDupliacteDRN = unitSaleBLObj.CheckDuplicateSaleRelatedInfo(" AND SALE.REG_BK='" + fundCode + "' AND SALE.DRF_DRN ='" + DRNTextBox.Text + "'");
if (isDupliacteDRF)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate DRF No');", true);
}
else if (isDupliacteDRN)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate DRN');", true);
}
else
{
commonGatewayObj.BeginTransaction();
htUpdate = new Hashtable();
htUpdate.Add("DRF_ACCEPT_ENTRY_BY", userObj.UserID.ToString());
htUpdate.Add("DRF_ACCEPT_ENTRY_DATE", DateTime.Now);
htUpdate.Add("DRF_ACCEPT_NO", DRFNoTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_DRN", DRNTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_ACCEPT_DATE", DamateDateTextBox.Text.Trim().ToString());
commonGatewayObj.Update(htUpdate, "SALE", "REG_BK='" + fundCode.ToUpper().ToString() + "' AND REG_BR='" + branchCode.ToUpper().ToString() + "' AND SALE.DRF_REF_NO=" + DRRefNoDropDownList.SelectedValue.ToString());
commonGatewayObj.CommitTransaction();
DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForDRN("AND SALE.REG_BK='" + fundCode + "'");
DRRefNoDropDownList.DataTextField = "NAME";
DRRefNoDropDownList.DataValueField = "ID";
DRRefNoDropDownList.DataBind();
DRFNoTextBox.Text = "";
DRNTextBox.Text = "";
DamateDateTextBox.Text = "";
FolioNoLabel.Text = "";
CertNoLabel.Text = "";
DistinctNoToLabel.Text = "";
DistNoFromLabel.Text = "";
TotalUnitLabel.Text = "";
DataTable dtSaleInfoForDRF = unitSaleBLObj.dtGetSaleInfoForDemate(" AND SALE.REG_BK='" + fundCode + "' AND SALE.REG_BR='" + branchCode + "' AND SALE.DRF_REF_NO=0");
SaleListGridView.DataSource = dtSaleInfoForDRF;
SaleListGridView.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save Successfully');", true);
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Error:" + ex.Message.ToString() + "');", true);
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
int countCheck = 0;
Hashtable htUpdate = new Hashtable();
try
{
foreach (GridViewRow Drv in SaleListGridView.Rows)
{
TextBox TRSeqNoTextBox = (TextBox)SaleListGridView.Rows[countCheck].FindControl("TRSeqNoTextBox");
bool isDupliacteTrSeqNo = unitSaleBLObj.CheckDuplicateSaleRelatedInfo(" AND SALE.REG_BK='" + fundCode + "' AND SALE.DRF_TR_SEQ_NO='" + TRSeqNoTextBox.Text + "'");
if (isDupliacteTrSeqNo)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate Transfer Sequence Number:" + TRSeqNoTextBox.Text + "');", true);
break;
}
else
{
commonGatewayObj.BeginTransaction();
htUpdate = new Hashtable();
htUpdate.Add("DRF_TR_ENTRY_BY", userObj.UserID.ToString());
htUpdate.Add("DRF_TR_ENTRY_DATE", DateTime.Now);
htUpdate.Add("DRF_TR_SEQ_NO", TRSeqNoTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_TR_DATE", TransferDateTextBox.Text.Trim().ToString());
commonGatewayObj.Update(htUpdate, "SALE", "REG_BK='" + fundCode.ToUpper().ToString() + "' AND REG_BR='" + branchCode.ToUpper().ToString() + "' AND SALE.DRF_REF_NO=" + DRRefNoDropDownList.SelectedValue.ToString());
}
commonGatewayObj.CommitTransaction();
DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForFolioTransfer("AND SALE.REG_BK='" + fundCode + "'");
DRRefNoDropDownList.DataTextField = "NAME";
DRRefNoDropDownList.DataValueField = "ID";
DRRefNoDropDownList.DataBind();
TRSeqFromNoTextBox.Text = "";
TransferDateTextBox.Text = "";
DataTable dtSaleInfoForDRF = unitSaleBLObj.dtGetSaleInfoForDemate(" AND SALE.REG_BK='" + fundCode + "' AND SALE.REG_BR='" + branchCode + "' AND SALE.DRF_REF_NO=0");
SaleListGridView.DataSource = dtSaleInfoForDRF;
SaleListGridView.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save Successfully');", true);
countCheck++;
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Error:" + ex.Message.ToString() + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
fundCode = bcContent.FundCode.ToString();
branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
if (!IsPostBack)
{
DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForFolioTransfer("AND SALE.REG_BK='" + fundCode + "'");
DRRefNoDropDownList.DataTextField = "NAME";
DRRefNoDropDownList.DataValueField = "ID";
DRRefNoDropDownList.DataBind();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Hashtable htUpdate = new Hashtable();
try
{
bool isDupliacteDRFolioNo = unitSaleBLObj.CheckDuplicateSaleRelatedInfo(" AND SALE.REG_BK='" + fundCode + "' AND SALE.DRF_REG_FOLIO_NO='" + RegFolioNoTextBox.Text + "'");
bool isDupliacteDRCertNo = unitSaleBLObj.CheckDuplicateSaleRelatedInfo(" AND SALE.REG_BK='" + fundCode + "' AND SALE.DRF_CERT_NO ='" + CertNoTextBox.Text + "'");
bool isDupliacteDRDistinctiveNo = unitSaleBLObj.CheckDuplicateSaleRelatedInfo("AND ((SALE.DRF_DISTNCT_NO_FROM BETWEEN " + DistinctNoFromTextBox.Text.Trim().ToString() + " AND " + DistinctNoToTextBox.Text.Trim().ToString() + ") AND (SALE.REG_BK = '" + fundCode + "') OR (SALE.DRF_DISTNCT_NO_TO BETWEEN " + DistinctNoFromTextBox.Text.Trim().ToString() + " AND " + DistinctNoToTextBox.Text.Trim().ToString() + ") AND (SALE.REG_BK = '" + fundCode + "'))");
if (isDupliacteDRFolioNo)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate Folio number');", true);
}
else if (isDupliacteDRCertNo)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate Certificate number');", true);
}
else if (isDupliacteDRDistinctiveNo)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Duplicate Distinctive number');", true);
}
else if (((Convert.ToInt64(DistinctNoToTextBox.Text.Trim().ToString()) - Convert.ToInt64(DistinctNoFromTextBox.Text.Trim().ToString()) + 1)) != Convert.ToInt64(TotalUnitsTextBox.Text.Trim().ToString()))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Distinctive Range and Total Units is not Eqqaul');", true);
}
else
{
commonGatewayObj.BeginTransaction();
htUpdate = new Hashtable();
htUpdate.Add("DRF_CUST_REQ_BY", userObj.UserID.ToString());
htUpdate.Add("DRF_CUST_REQ_DATE", DateTime.Now);
htUpdate.Add("DRF_REG_FOLIO_NO", RegFolioNoTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_CERT_NO", CertNoTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_DISTNCT_NO_FROM", DistinctNoFromTextBox.Text.Trim().ToString());
htUpdate.Add("DRF_DISTNCT_NO_TO", DistinctNoToTextBox.Text.Trim().ToString());
commonGatewayObj.Update(htUpdate, "SALE", "REG_BK='" + fundCode.ToUpper().ToString() + "' AND REG_BR='" + branchCode.ToUpper().ToString() + "' AND SALE.DRF_REF_NO=" + DRRefNoDropDownList.SelectedValue.ToString());
commonGatewayObj.CommitTransaction();
DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForCustodian("AND SALE.REG_BK='" + fundCode + "'");
DRRefNoDropDownList.DataTextField = "NAME";
DRRefNoDropDownList.DataValueField = "ID";
DRRefNoDropDownList.DataBind();
RegFolioNoTextBox.Text = "";
CertNoTextBox.Text = "";
DistinctNoFromTextBox.Text = "";
DistinctNoToTextBox.Text = "";
TotalUnitsTextBox.Text = "";
DataTable dtSaleInfoForDRF = unitSaleBLObj.dtGetSaleInfoForDemate(" AND SALE.REG_BK='" + fundCode + "' AND SALE.REG_BR='" + branchCode + "' AND SALE.DRF_REF_NO=0");
SaleListGridView.DataSource = dtSaleInfoForDRF;
SaleListGridView.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Save Successfully');", true);
}
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to Error:" + ex.Message.ToString() + "');", true);
}
}