public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportSelectiveCashierSale rpt = new CrystalReportSelectiveCashierSale();
rpt.Site = this.Site;
return(rpt);
}
private static void ByPass(CrystalReportSelectiveCashierSale ob)
{
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = ".";
crConnectionInfo.DatabaseName = "RMSDB";
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = Variable.Class1.a;
CrTables = ob.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
}
private void button1_MouseClick(object sender, MouseEventArgs e)
{
if (WorkStatus.Endworkcheck == 1 || WorkStatus.startworkcheck == 0)
{
if (comboBox1.Text.Trim() != "")
{
List <UserTable> asd = new List <UserTable>();
asd = obj.Get_SelectedCashiername((comboBox1.Text));
if (asd.Count > 0 && asd[0].IsAdmin == 0)
{
CrystalReportSelectiveCashierSale ob = new CrystalReportSelectiveCashierSale();
ByPass(ob);
ob.SetParameterValue("start", dateTimePicker1.Value);
ob.SetParameterValue("end", dateTimePicker2.Value);
ob.SetParameterValue("CID", asd[0].UserId);
ob.SetParameterValue("CNAME", (asd[0].UserName.ToString()));
ob.SetParameterValue("name", (asd[0].FullName.ToString()));
crystalReportViewer1.ReportSource = ob;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
else
{
MessageBox.Show("Cashier ID Incorect");
}
}
else
{
MessageBox.Show("Text Field Empty!");
}
}
else
{
MessageBox.Show("First End the Work To Logout");
}
}
