private void btnPrint_Click(object sender, EventArgs e)
{
try
{
bool Rights = ClsModuleName.ChechRights(ClsLogin.LoginId, this.Tag, ClsModuleName.Rights.U_Print.ToString());
if (Rights == false)
{
return;
}
string SS = "Select * From vw_LoanSanction Where Id = " + LoanSanctionId + "";
DataTable Dt = ObjData.GetDataTable(SS);
if (Dt.Rows.Count > 0)
{
clsNumberToWord ObjNumber = new clsNumberToWord();
DialogResult Dr = MessageBox.Show("Print on Letter Head", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (Dr == DialogResult.No)
{
#region With Out Letter
Forms.Printing.LoanApplicationWithoutLetter Rpt = new Finance_Management_System.Forms.Printing.LoanApplicationWithoutLetter();
string EMI = Dt.Rows[0]["EMI"].ToString();
string EMIWords = ObjNumber.changeCurrencyToWords(EMI);
string PLoanAmount = Dt.Rows[0]["PLoanAmount"].ToString();
string PLoanAmountWords = ObjNumber.changeCurrencyToWords(PLoanAmount);
Dt.Rows[0]["EMIWords"] = "Rs. " + EMIWords;
Dt.Rows[0]["PLoanAmountWords"] = "Rs. " + PLoanAmountWords;
Rpt.SetDataSource(Dt);
CrystalDecisions.CrystalReports.Engine.TextObject txtS1;
txtS1 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt1"];
txtS1.Text = clsGeneral.Slogan1;
CrystalDecisions.CrystalReports.Engine.TextObject txtS2;
txtS2 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt2"];
txtS2.Text = clsGeneral.Slogan2;
CrystalDecisions.CrystalReports.Engine.TextObject txtS3;
txtS3 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt3"];
txtS3.Text = clsGeneral.Slogan3;
CrystalDecisions.CrystalReports.Engine.TextObject txtS4;
txtS4 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt4"];
txtS4.Text = clsGeneral.Slogan4;
CrystalDecisions.CrystalReports.Engine.TextObject txtS5;
txtS5 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt5"];
txtS5.Text = clsGeneral.Slogan5;
Rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
//Rpt.PrintToPrinter(1, true, 0, 0);
Frm_Preview F = new Frm_Preview(Rpt, Dt);
F.Show();
#endregion
}
else
{
#region With Letter
Forms.Printing.LoanApplicationWithLetter Rpt = new Finance_Management_System.Forms.Printing.LoanApplicationWithLetter();
string EMI = Dt.Rows[0]["EMI"].ToString();
string EMIWords = ObjNumber.changeCurrencyToWords(EMI);
string PLoanAmount = Dt.Rows[0]["PLoanAmount"].ToString();
string PLoanAmountWords = ObjNumber.changeCurrencyToWords(PLoanAmount);
Dt.Rows[0]["EMIWords"] = "Rs. " + EMIWords;
Dt.Rows[0]["PLoanAmountWords"] = "Rs. " + PLoanAmountWords;
Rpt.SetDataSource(Dt);
CrystalDecisions.CrystalReports.Engine.TextObject txtS1;
txtS1 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt1"];
txtS1.Text = clsGeneral.Slogan1;
CrystalDecisions.CrystalReports.Engine.TextObject txtS2;
txtS2 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt2"];
txtS2.Text = clsGeneral.Slogan2;
CrystalDecisions.CrystalReports.Engine.TextObject txtS3;
txtS3 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt3"];
txtS3.Text = clsGeneral.Slogan3;
CrystalDecisions.CrystalReports.Engine.TextObject txtS4;
txtS4 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt4"];
txtS4.Text = clsGeneral.Slogan4;
CrystalDecisions.CrystalReports.Engine.TextObject txtS5;
txtS5 = (CrystalDecisions.CrystalReports.Engine.TextObject)Rpt.Section3.ReportObjects["txt5"];
txtS5.Text = clsGeneral.Slogan5;
Rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
//Rpt.PrintToPrinter(1, true, 0, 0);
Frm_Preview F = new Frm_Preview(Rpt, Dt);
F.Show();
#endregion
}
}
}
catch (Exception Erp)
{
clsGeneral.ShowErrMsg(Erp.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
bool Rights = ClsModuleName.ChechRights(ClsLogin.LoginId, this.Tag, ClsModuleName.Rights.U_Print.ToString());
if (Rights == false)
{
return;
}
string SS = "Select * From vw_LoanSanction Where Id = " + LoanSanctionId + "";
DataTable Dt = ObjData.GetDataTable(SS);
if (Dt.Rows.Count > 0)
{
Forms.Printing.Shapatra Rpt = new Finance_Management_System.Forms.Printing.Shapatra();
Rpt.SetDataSource(Dt);
Rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
// Rpt.PrintToPrinter(1, true, 0, 0);
Frm_Preview F = new Frm_Preview(Rpt, Dt);
F.Show();
}
}
catch (Exception Erp)
{
clsGeneral.ShowErrMsg(Erp.Message);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
bool Rights = ClsModuleName.ChechRights(ClsLogin.LoginId, this.Tag, ClsModuleName.Rights.U_Print.ToString());
if (Rights == false)
{
return;
}
if (CashId > 0)
{
string SS = "Select * From vw_LoanSanction Where Id = " + txtName.ValueGet("") + "";
DataTable Dt = ObjData.GetDataTable(SS);
if (Dt.Rows.Count > 0)
{
if (ObjData.GetLoanbalance(txtName.ValueGet("")) > 0)
{
clsGeneral.ShowMessage("Loan balance is not Clearded");
return;
}
Forms.Printing.NOC Rpt = new Finance_Management_System.Forms.Printing.NOC();
Rpt.SetDataSource(Dt);
Rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
// Rpt.PrintToPrinter(1, true, 0, 0);
Frm_Preview F = new Frm_Preview(Rpt, Dt);
F.Show();
}
}
}