public void BindCrist()
{
if (txtfromDate.Text != "" || txttoDate.Text != "")
{
if (txtBook.Text != "")
{
string from = txtfromDate.Text.Split('/')[1] + "/" + txtfromDate.Text.Split('/')[0] + "/" + txtfromDate.Text.Split('/')[2];
string To = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
string BookCode = txtBook.Text.Split(':')[0].Trim();
string bookCode2 = "null";
// bookname = txtBook.Text.Split(':')[2].Trim();
fdate = Convert.ToDateTime(from);
tdate = Convert.ToDateTime(To);
if (fdate > tdate)
{
MessageBox("From Date is Greater than ToDate");
txtfromDate.Focus();
}
else
{
DataTable dt = new DataTable();
dt = Specimen.Get_SpecimenDetailsForInvoice_Bookwise(bookCode2, BookCode, Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0];
ReportDocument CR = new ReportDocument();
CR.Load(Server.MapPath("Report/BookWiseReport.rpt"));
cryBookwise.SeparatePages = false;
CR.SetDataSource(dt);
cryBookwise.ReportSource = CR;
}
}
else
{
string from = txtfromDate.Text.Split('/')[1] + "/" + txtfromDate.Text.Split('/')[0] + "/" + txtfromDate.Text.Split('/')[2];
string To = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
string BookCode = "null";
//txtBook.Text.Split(':')[0].Trim();
string bookCode2 = "null";
// bookname = txtBook.Text.Split(':')[2].Trim();
fdate = Convert.ToDateTime(from);
tdate = Convert.ToDateTime(To);
if (fdate > tdate)
{
MessageBox("From Date is Greater than ToDate");
txtfromDate.Focus();
}
else
{
DataTable dt = new DataTable();
dt = Specimen.Get_SpecimenDetailsForInvoice_Bookwise(bookCode2, BookCode, Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0];
ReportDocument CR = new ReportDocument();
CR.Load(Server.MapPath("Report/BookWiseReport.rpt"));
cryBookwise.SeparatePages = false;
CR.SetDataSource(dt);
cryBookwise.ReportSource = CR;
}
}
}
}
