private void BtnTransfer_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
crIPoTransferReport objrpt = new crIPoTransferReport();
frmIPOReportViewer viewer = new frmIPOReportViewer();
dt = bal.GetIpoTransferReport(CmbTransaction.Text, dtpformdate.Value, dtpTodate.Value);
//dt = bal.GetIpoTransferReport(dtpformdate.Value, dtpTodate.Value);
objrpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtTransferName"]).Text = CmbTransaction.Text;
//Date
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtfromdate"]).Text = dtpformdate.Value.ToShortDateString();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txttodate"]).Text = dtpTodate.Value.ToShortDateString();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtReportTitle"]).Text = "Daily Ipo Transfer Report";
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objrpt;
viewer.Show();
}
private void btnsingleReport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string StatusName = Convert.ToString(cmbStatusName.Text);
string CompanyName = Convert.ToString(CmbCompanyName.SelectedValue);
int branchId = (int)cmbBranchName.SelectedValue;
dt = objBAL.IPOSingleApplicationReport(dtpstartdate.Value, dtpenddate.Value, StatusName, CompanyName, branchId);
crIPOSingleApplicationReport objrpt = new crIPOSingleApplicationReport();
frmIPOReportViewer viewer = new frmIPOReportViewer();
if (dt.Rows.Count > 0)
{
objrpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Single Application Status";
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objrpt;
viewer.Show();
}
else
{
MessageBox.Show("Data not found", "" + MessageBoxIcon.Error);
}
}
private void PrintWithSignature()
{
DataTable dt = new DataTable();
crIpoApplicationForPublicIssue objrpt = new crIpoApplicationForPublicIssue();
frmIPOReportViewer viewer = new frmIPOReportViewer();
if (CmbCompanyCode.SelectedItem.Equals("Company Name"))
{
dt = objBAL.GetPublicApplicationIssue("", CmbCustCode.Text);
}
else if (CmbCompanyCode.SelectedItem.Equals("Cust Code"))
{
dt = objBAL.GetPublicApplicationIssue(CmbCustCode.Text, "");
}
else if (CmbCompanyCode.SelectedItem.Equals("Code and Company"))
{
dt = objBAL.GetPublicApplicationIssue(CmbCustCode.Text, CmbCompany.Text);
}
objrpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Application for public issue";
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objrpt;
viewer.Show();
}
private void BtnReportShow_Click(object sender, EventArgs e)
{
int SessionId = 0;
string TransacitonTypeName = "";
if (cmbSessionName.Items.Count > 0)
{
SessionId = (int)cmbSessionName.SelectedValue;
}
if (CmbTransactionTypename.Items.Count > 0)
{
TransacitonTypeName = CmbTransactionTypename.Text;
}
DataTable dt = new DataTable();
crIPOTotalMoneyTransactionAfterResult objrpt = new crIPOTotalMoneyTransactionAfterResult();
frmIPOReportViewer viewer = new frmIPOReportViewer();
dt = bal.TotalTransactionstatusAfterResults(TransacitonTypeName, SessionId, dtpFormdae.Value, dtpEndDate.Value);
objrpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "Total Transaction List With out TRTA after IPO result";
viewer.crystalReportViewer1.ReportSource = objrpt;
viewer.Show();
}
private void btnDailyReport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
CrIpoDailyReport crRpt = new CrIpoDailyReport();
crIPODepositSummaryInfo crSummary = new crIPODepositSummaryInfo();
frmIPOReportViewer viewer = new frmIPOReportViewer();
if (cmbMoneyTransacitonType.Text == "ALL")
{
MoneyTransactionTypeName = "";
}
else
{
MoneyTransactionTypeName = cmbMoneyTransacitonType.Text;
}
if (CmbtransactionStatus.Text == "ALL")
{
StatusName = "";
}
else
{
StatusName = Convert.ToString(CmbtransactionStatus.SelectedValue);
}
if (rdbDailyIPOFullReport.Checked)
{
if (ChkCompanySelection.Checked)
{
dt = bal.GetDailyTransactionReport(null, null, MoneyTransactionTypeName, StatusName, Convert.ToString(CmbsessionName.SelectedValue));
}
else
{
dt = bal.GetDailyTransactionReport(dtpFormdate.Value.Date, dtpTodate.Value.Date, MoneyTransactionTypeName, StatusName, "");
}
crRpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)crRpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)crRpt.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = crRpt;
}
else
{
dt = bal.GetIPODepositSummaryInfo(Convert.ToString(CmbsessionName.SelectedValue));
crSummary.SetDataSource(dt);
viewer.crystalReportViewer1.ReportSource = crSummary;
}
viewer.Show();
}
public void ShowCustMoneyLedgerReport()
{
_branchId = GlobalVariableBO._branchId;
_fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
_toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
_custCode = txtCustCode.Text;
IPOCustomerSummeryLedgerBAL moneyLedgerReportBal = new IPOCustomerSummeryLedgerBAL();
DataTable dtCustmoneyLedger = new DataTable();
DataTable dtCustBasicInfo = new DataTable();
DataTable dtopenClose = new DataTable();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
crIPOCustomerSummery crCustMoneyledger = new crIPOCustomerSummery();
frmIPOReportViewer viewer = new frmIPOReportViewer();
dtCustmoneyLedger = moneyLedgerReportBal.GetIPOCustSummeryLedger(_custCode, _fromDate, _toDate);
dtCustBasicInfo = moneyLedgerReportBal.GetIpoCustSummaryBasicInfo(_custCode);
dtopenClose = moneyLedgerReportBal.IpoOpenCloseWithdrawDepost(_custCode, _fromDate, _toDate);
crCustMoneyledger.SetDataSource(dtCustmoneyLedger);
if (dtopenClose.Rows.Count > 0)
{
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtopeningBalance"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Open_Balance"]);
//((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtCloseBalance"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Close_Balance"]);
((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtDepost"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["total_Deposit"]);
((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtWithdraw"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Toatal_Withdraw"]);
}
if (dtCustBasicInfo.Rows.Count > 0)
{
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text =
dtCustBasicInfo.Rows[0]["Cust_Name"].ToString();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text =
dtCustBasicInfo.Rows[0]["Cust_Code"].ToString();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtboid"]).Text =
dtCustBasicInfo.Rows[0]["BO_ID"].ToString();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text =
"Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " +
dtToDate.Value.ToString("dd-MMM-yyyy");
//((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
// "IPO Customer Money Ledger";
}
GetCommonInfo();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = crCustMoneyledger;
viewer.Show();
}
private void GetNewPaymentReview()
{
try
{
IPOPaymentReviewBAL paymentBAL = new IPOPaymentReviewBAL();
DataTable dtPaymentReview = new DataTable();
crIPONewPaymentReview crPayment = new crIPONewPaymentReview();
frmIPOReportViewer paymentViewer = new frmIPOReportViewer();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
int issorted = 0;
int isAccountsView = 0;
if (chbOder.Checked)
{
issorted = 1;
}
else
{
issorted = 0;
}
int selected_BranchID = Convert.ToInt32(cmb_Branch_Name.SelectedValue);
dtPaymentReview = paymentBAL.GnerateIPOPaymentReview(dtpFromDate.Value, dtpToDate.Value, issorted, selected_BranchID);
//_filterdColumnName = dtPaymentReview.Columns[1].ToString();
//RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.New_Payment_Review);
//dtPaymentReview = obj.GetRecordLevelFilteredData();
crPayment.SetDataSource(dtPaymentReview);
GetCommonInfo();
///// Load Company Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchName + "," + _branchAddress + ",Phone: " + _branchContactNumber;
////Load Date
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = dtpFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtpToDate.Value.ToString("dd-MMM-yyyy");
paymentViewer.crystalReportViewer1.DisplayGroupTree = false;
paymentViewer.crystalReportViewer1.ReportSource = crPayment;
paymentViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ShowCustMoneyLedgerReport()
{
_branchId = GlobalVariableBO._branchId;
_fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
_toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
_custCode = txtCustCode.Text;
IPOReportBAL moneyLedgerReportBal = new IPOReportBAL();
DataTable dtCustmoneyLedger = new DataTable();
DataTable dtCustBasicInfo = new DataTable();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
crIPOCustMoneyLedger crCustMoneyledger = new crIPOCustMoneyLedger();
frmIPOReportViewer viewer = new frmIPOReportViewer();
dtCustmoneyLedger = moneyLedgerReportBal.GetIPOCustMoneyLedger(_custCode, _fromDate, _toDate);
dtCustBasicInfo = moneyLedgerReportBal.GetIpoCustBasicInfo(_custCode);
crCustMoneyledger.SetDataSource(dtCustmoneyLedger);
if (dtCustBasicInfo.Rows.Count > 0)
{
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text =
dtCustBasicInfo.Rows[0]["Cust_Name"].ToString();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text =
dtCustBasicInfo.Rows[0]["Cust_Code"].ToString();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["Text6"]).Text =
"Balance Before " + dtFromDate.Value.ToString("dd-MMM-yy") + " :";
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text =
"Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " +
dtToDate.Value.ToString("dd-MMM-yyyy");
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Customer Money Ledger";
}
GetCommonInfo();
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = crCustMoneyledger;
viewer.Show();
}
private void NRB()
{
IPOReportBAL bal = new IPOReportBAL();
DataTable dt = new DataTable();
dt = bal.GetNRBSuccessfulUnsuccessful(cmbStatusName.Text, Cmbcompanyname.Text, CmbCustomerCode.Text);
crNrbSuccessfulUnsuccessful nrb = new crNrbSuccessfulUnsuccessful();
frmIPOReportViewer viewer = new frmIPOReportViewer();
nrb.SetDataSource(dt);
//GetCommonInfo();
//((TextObject)nrb.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
// _CommpanyName;
/////// Load Branch Name
//((TextObject)nrb.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
// "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = nrb;
viewer.Show();
}
private void loadShareBalanceReport()
{
IPOReportBAL bal = new IPOReportBAL();
crIPOCustomerSummaryBalanceLedger objrpt = new crIPOCustomerSummaryBalanceLedger();
frmIPOReportViewer viewer = new frmIPOReportViewer();
DataTable dt = new DataTable();
_fromDate = dtFromDate.Value.Date;
_toDate = dtToDate.Value.Date;
dt = bal.GetAllCustomerIPOBalance(_fromDate.Date, _toDate.Date);
objrpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = _branchAddress;
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["txtReportName"]).Text = "All Account Balance Summary Information";
//((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["Todate"]).Text = _toDate.Date.ToString();
((TextObject)objrpt.ReportDefinition.Sections[2].ReportObjects["FromDate"]).Text = _fromDate.Date.ToString();
viewer.crystalReportViewer1.ReportSource = objrpt;
viewer.Show();
}
private void GetNRBPaymentReview()
{
IPOReportBAL bal = new IPOReportBAL();
DataTable dtPaymentReview_NRB = new DataTable();
crIPONRBPayementReview crPayment = new crIPONRBPayementReview();
frmIPOReportViewer paymentViewer = new frmIPOReportViewer();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
int selected_BranchID = Convert.ToInt32(cmb_Branch_Name.SelectedValue);
dtPaymentReview_NRB = bal.GETIPONRBPaymentReview(selected_BranchID, dtpFromDate.Value, dtpToDate.Value);
crPayment.SetDataSource(dtPaymentReview_NRB);
GetCommonInfo();
///// Load Company Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchName + "," + _branchAddress + ",Phone: " + _branchContactNumber;
////Load Date
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = dtpFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtpToDate.Value.ToString("dd-MMM-yyyy");
paymentViewer.crystalReportViewer1.ReportSource = crPayment;
paymentViewer.Show();
}
private void RB()
{
DataTable dt = new DataTable();
dt = objBAL.IPOSuccessfulUnsuccessfulApplication(cmbStatusName.Text, Cmbcompanyname.Text, CmbCustomerCode.Text);
crIPOSuccessfulUnsuccessful objRPT = new crIPOSuccessfulUnsuccessful();
crIPOApproavedUniapproaved objRPTapp = new crIPOApproavedUniapproaved();
frmIPOReportViewer viewer = new frmIPOReportViewer();
if (cmbStatusName.Text == "Successfull" || cmbStatusName.Text == "Unsuccessfull")
{
objRPT.SetDataSource(dt);
if (cmbStatusName.Text == "Successfull")
{
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Successfull Status";
}
else if (cmbStatusName.Text == "Unsuccessfull")
{
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Unsuccessfull Status";
}
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
else if (cmbStatusName.Text == "All")
{
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO All Kind of Status";
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
else if (cmbStatusName.Text == "Approved")
{
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Approved Status";
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
else if (cmbStatusName.Text == "Pending")
{
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Pending Status";
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
else if (cmbStatusName.Text == "Rejected")
{
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Rejected Status";
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
else if (cmbStatusName.Text == "Check")
{
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text =
"IPO Rejected Status";
GetCommonInfo();
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
///// Load Branch Name
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text =
"Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
viewer.crystalReportViewer1.ReportSource = objRPT;
viewer.Show();
}
}
