protected void btnDelete_Click(object sender, EventArgs e)
{
Result oResult = null;
try
{
if (string.IsNullOrEmpty(hdnClaimTransNo.Value))
{
ucMessage.OpenMessage("Please select a valid Sale Claim for delete.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
else
{
SalesStatementDAL iClaimDAL = new SalesStatementDAL();
oResult = iClaimDAL.DeleteSaleClaim(hdnClaimTransNo.Value);
if (oResult.Status)
{
ucMessage.OpenMessage("Sale Claim data deleted successfully.", Constants.MSG_APPROVED_SAVE_DATA);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
btnReset_Click(sender, e);
}
else
{
ucMessage.OpenMessage("Error: " + oResult.Message, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
}
catch (Exception ex)
{
ucMessage.OpenMessage("Error: " + ex.Message, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
public void SetToDate(DateTime dtFrom)
{
Result oResult = new Result();
DataTable dtTemp = new DataTable();
SalesStatementDAL SSDal = new SalesStatementDAL();
string strWhereCondition = "";
try
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
strWhereCondition = " WHERE(((SPMS_SalesStatementDetails.IssueTransNo) Is Null) And ((SPMS_Reinvestment.OldIssueTransNo) Is Null) " +
" And ((SPMS_OldCustomerIssue.IssueTransNo) Is Null) And ((SPMS_Issue.SPTypeID) = '" + ddlSpType.SelectedValue + "')" +
" And SPMS_Issue.IsApproved = " + (int)SBM_BLV1.baseCommon.enmApprovalStatus.Approved +
" And SPMS_Issue.IsClaimed = 'False' " +
" And SPMS_Issue.DivisionID = '" + oConfig.DivisionID + "' And SPMS_Issue.BankID = '" + oConfig.BankCodeID + "')";
oResult = (Result)SSDal.GetSaleStatementToDateSource(strWhereCondition);
if (oResult.Status)
{
dtTemp = (DataTable)oResult.Return;
ddlDateTo.DataSource = dtTemp;
ddlDateTo.DataTextField = "DisplayMember";
ddlDateTo.DataValueField = "ValueMember";
ddlDateTo.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void FillRegistrationDetailGrid(string sSaleStatementTransNo)
{
if (!string.IsNullOrEmpty(ddlSpType.SelectedValue))
{
if (ddlSpType.SelectedValue.Equals("3MS") ||
ddlSpType.SelectedValue.Equals("BSP") ||
ddlSpType.SelectedValue.Equals("DIB") ||
ddlSpType.SelectedValue.Equals("DPB") ||
ddlSpType.SelectedValue.Equals("FSP") ||
ddlSpType.SelectedValue.Equals("PSC") ||
ddlSpType.SelectedValue.Equals("WDB")
)
{
SalesStatementDAL ssDal = new SalesStatementDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = ssDal.LoadRegistrationDetailsData(ddlSpType.SelectedValue, Util.GetDateTimeByString(txtDateFrom.Text), Util.GetDateTimeByString(ddlDateTo.SelectedValue), sSaleStatementTransNo, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtSaleStatement = oResult.Return as DataTable;
if (dtSaleStatement != null && dtSaleStatement.Rows.Count > 0)
{
dtSaleStatement.Columns.Remove("PolicyID");
gvData.DataSource = dtSaleStatement;
gvData.DataBind();
if (!string.IsNullOrEmpty(sSaleStatementTransNo))
{
foreach (GridViewRow gvr in gvData.Rows)
{
CheckBox chk = (CheckBox)gvr.FindControl("chkSelected");
if (chk != null)
{
chk.Checked = true;
chk.Enabled = false;
}
}
CalculateData();
}
}
ddlDuration.Enabled = true;
ddlDateTo.Enabled = true;
}
else
{
ddlDuration.Enabled = false;
ddlDateTo.Enabled = false;
}
}
else
{
ddlDuration.Enabled = false;
ddlDateTo.Enabled = false;
}
}
private bool SaveAndPreviewAction()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
if (txtReferenceNo.Text.Equals(string.Empty))
{
DataTable dtRegDetail = GetRegistrationDetail();
if (dtRegDetail.Rows.Count > 0)
{
CalculateData();
#region 01. GetObject ... Get Value
SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement = GetObject();
#endregion
#region 02. Call and varify..
SalesStatementDAL salStatementDAL = new SalesStatementDAL();
Result oResult = salStatementDAL.InsertData(oSalesStatement, dtRegDetail);
if (!oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return(false);
}
#endregion
#region 03. for preview
oSalesStatement.SaleStatementReferenceNo = Convert.ToString(oResult.Return);
PreviewAction(oSalesStatement);
#endregion
}
else
{
ucMessage.OpenMessage("Select at least one registration to save & print sales statement.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
return(false);
}
}
return(true);
}
return(false);
}
private void LoadShowData(string strSaleStatementTransNo)
{
// this block is used for Reset the all controls..
gvData.DataSource = null;
gvData.DataBind();
ClearTotal();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
DataTable dtDataTable = new DataTable();
SalesStatementDAL salesDAL = new SalesStatementDAL();
Result oResult = new Result();
try
{
DataColumn dtColIsSelect = new DataColumn();
dtColIsSelect.AllowDBNull = false;
dtColIsSelect.DefaultValue = false;
dtColIsSelect.ReadOnly = false;
dtColIsSelect.DataType = System.Type.GetType("System.Boolean");
dtColIsSelect.Caption = "Select";
dtColIsSelect.ColumnName = "IsSelect";
DateTime dtFromDate = Util.GetDateTimeByString(txtDateFrom.Text);
DateTime dtToDate = Util.GetDateTimeByString(ddlDateTo.SelectedValue);
oResult = (Result)salesDAL.LoadRegistrationDetailsData(ddlSpType.SelectedValue, dtFromDate, dtToDate, strSaleStatementTransNo, oConfig.DivisionID, oConfig.BankCodeID);
if (oResult.Status)
{
dtDataTable = (DataTable)oResult.Return;
dtDataTable.Columns.Add(dtColIsSelect);
if (dtDataTable.Rows.Count > 0)
{
gvData.DataSource = dtDataTable;
gvData.DataBind();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateReportDocument(SBM_BLC1.Entity.Claim.SalesStatement oSalesStatement)
{
ClaimReportDAL oCRDAL = new ClaimReportDAL();
bool isCoverLetter = false;
foreach (ListItem item in chkListForBB.Items)
{
if (item.Selected)
{
if (item.Value.Equals("With Cover Letter"))
{
isCoverLetter = true;
}
else
{
}
}
}
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
int iReportFormat = 0;
Result oResult = new Result();
Result oResult1 = new Result();
Result oResult2 = new Result();
SalesStatementDAL sDAL = new SalesStatementDAL();
Result oResultFormat = sDAL.GetSaleStatementReportFormat(ddlSpType.SelectedValue);
if (oResultFormat.Status)
{
iReportFormat = (int)oResultFormat.Return;
}
if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.SP))
{
oResult1 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.BSPSalesDetails, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.BSPSalesCoverLetter, oConfig.BranchID);
}
}
else if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.DollarBond))
{
oResult2 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.DPBSalesDetails2, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.DPBSalesCoverLetter, oConfig.BranchID);
}
}
else if (iReportFormat.Equals((int)SBM_BLV1.baseCommon.enmSalesReportFormat.WDB))
{
oResult1 = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.WEDBSalesDetais, oConfig.BranchID);
if (isCoverLetter)
{
oResult = oCRDAL.SalesStatementReportDocument(oSalesStatement, GetRegistrationDetail(), (int)Constants.ReportType.WEDBSalesCoverLetter, oConfig.BranchID);
}
}
Session["ExportType"] = ddlExportType.SelectedValue;
if (oResult.Status) //cover letter
{
Session[Constants.SES_RPT_DATA] = oResult.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport2(1));
}
if (oResult1.Status)
{
Session[Constants.SES_RPT_DATA_2] = oResult1.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW_2, Util.OpenReport2(2));
//Session[Constants.SES_RPT_DATA] = oResult1.Return as ReportDocument;
//Page.RegisterStartupScript(Constants.REPORT_WINDOW, Util.OpenReport());
}
if (oResult2.Status)
{
Session[Constants.SES_RPT_DATA_2] = oResult2.Return as ReportDocument;
Page.RegisterStartupScript(Constants.REPORT_WINDOW_2, Util.OpenReport2(2));
}
}
}