public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptEmployeeList rpt = new rptEmployeeList();
rpt.Site = this.Site;
return(rpt);
}
private void btnok_Click(object sender, EventArgs e)
{
if (cmbempcategory.Text != "")
{
string select = cmbempcategory.SelectedItem.ToString();
string str;
if (select == "All Employee")
{
//str = "select convert(varchar, EmpNo),EmpName,FathersName,Gender,Address,convert(varchar,doj,103)DOJ,convert(varchar,dob,103)DOB,IsActive,tbl_EmployeeType .Detail Employee_Type, designation Designation,salaryrate Salary,rsa Spl_All,pf PF,lic Lic,loan Loan,splinctv Spl_Inc,pfnumber PF_No,aleave A_Leave,balleave Bal_Leave,el El,elbal ElBal,enclleave EnCashLeave,contactno Contact_No,da DA,daamt,pfamt,hra HRA,ESIC,ESICAmt from tbl_employeeinfo,tbl_EmployeeType where tbl_EmployeeInfo .EmpTypeId =tbl_EmployeeType .EmpTypeId ";
//str = str + " SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school ";
//ds = Connection.GetDataSet(str);
str = "SELECT tbl_EmployeeInfo.EmpNo, tbl_EmployeeInfo.EmpName, tbl_EmployeeInfo.FathersName, tbl_EmployeeInfo.Address, tbl_EmployeeInfo.DOJ, tbl_EmployeeInfo.DOB, tbl_EmployeeInfo.Gender, tbl_EmployeeInfo.salaryrate, tbl_EmployeeInfo.pf, tbl_EmployeeInfo.lic, tbl_EmployeeInfo.loan, tbl_EmployeeInfo.designation, tbl_EmployeeInfo.photo, tbl_EmployeeInfo.rsa, tbl_EmployeeInfo.pfnumber, tbl_EmployeeInfo.splinctv, tbl_EmployeeInfo.HRA, tbl_EmployeeInfo.contactno, tbl_EmployeeInfo.DAAmt, tbl_EmployeeInfo.PFAmt, tbl_EmployeeInfo.ESICAmt, tbl_EmployeeInfo.AccountNo, tbl_EmployeeInfo.BankName, tbl_EmployeeInfo.DA, tbl_EmployeeInfo.ESIC, tbl_EmployeeType.Detail FROM tbl_EmployeeInfo INNER JOIN tbl_EmployeeType ON tbl_EmployeeInfo.EmpTypeId = tbl_EmployeeType.EmpTypeId ";
str = str + " SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school ";
ds = Connection.GetDataSet(str);
}
else
{
//str = "select convert(varchar, EmpNo),EmpName,FathersName,Gender,Address,convert(varchar,doj,103)DOJ,convert(varchar,dob,103)DOB,IsActive,tbl_EmployeeType .Detail Employee_Type, designation Designation,salaryrate Salary,rsa Spl_All,pf PF,lic Lic,loan Loan,splinctv Spl_Inc,pfnumber PF_No,aleave A_Leave,balleave Bal_Leave,el El,elbal ElBal,enclleave EnCashLeave,contactno Contact_No,da DA,daamt,pfamt,hra HRA,ESIC,ESICAmt from tbl_employeeinfo,tbl_EmployeeType where tbl_EmployeeInfo .EmpTypeId =tbl_EmployeeType .EmpTypeId and tbl_EmployeeType.Detail='" + select + "'";
//str = str + " SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school ";
//ds = Connection.GetDataSet(str);
str = "SELECT tbl_EmployeeInfo.EmpNo, tbl_EmployeeInfo.EmpName, tbl_EmployeeInfo.FathersName, tbl_EmployeeInfo.Address, tbl_EmployeeInfo.DOJ, tbl_EmployeeInfo.DOB, tbl_EmployeeInfo.Gender, tbl_EmployeeInfo.salaryrate, tbl_EmployeeInfo.pf, tbl_EmployeeInfo.lic, tbl_EmployeeInfo.loan, tbl_EmployeeInfo.designation, tbl_EmployeeInfo.photo, tbl_EmployeeInfo.rsa, tbl_EmployeeInfo.pfnumber, tbl_EmployeeInfo.splinctv, tbl_EmployeeInfo.HRA, tbl_EmployeeInfo.contactno, tbl_EmployeeInfo.DAAmt, tbl_EmployeeInfo.PFAmt, tbl_EmployeeInfo.ESICAmt, tbl_EmployeeInfo.AccountNo, tbl_EmployeeInfo.BankName, tbl_EmployeeInfo.DA, tbl_EmployeeInfo.ESIC, tbl_EmployeeType.Detail FROM tbl_EmployeeInfo INNER JOIN tbl_EmployeeType ON tbl_EmployeeInfo.EmpTypeId = tbl_EmployeeType.EmpTypeId Where tbl_EmployeeType.Detail=N'" + select + "'";
str = str + " SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school ";
ds = Connection.GetDataSet(str);
}
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("There is no Record.");
return;
}
ds.WriteXmlSchema(@"" + Connection.GetAccessPathId() + @"Barcodes\a\EmployeeListReport.xsd");
rptEmployeeList rl = new rptEmployeeList();
rl.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
rl.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
rl.SetDataSource(ds);
ShowAllReports f = new ShowAllReports();
f.crystalReportViewer1.ReportSource = rl;
f.Show();
}
else
{
MessageBox.Show("Please Select Any One Category.");
}
}
