private DataTable getReport()
{
CheckOutRequestBusiness reqBusiness = new CheckOutRequestBusiness();
DataTable dt = new DataTable();
DataTable fields = new DataTable();
fields.Columns.Add(new DataColumn("FieldId", typeof(int)));
foreach (Telerik.Web.UI.RadComboBoxItem item in drpFild.Items)
{
if (item.Checked)
{
var row = fields.NewRow();
row["FieldId"] = Convert.ToInt32(item.Value);
fields.Rows.Add(row);
}
}
DataTable danesh = new DataTable();
danesh.Columns.Add(new DataColumn("FieldId", typeof(int)));
foreach (Telerik.Web.UI.RadComboBoxItem item in drpUniversity.Items)
{
if (item.Checked)
{
var row = danesh.NewRow();
row["FieldId"] = Convert.ToInt32(item.Value);
danesh.Rows.Add(row);
}
}
DataTable vahedList = new DataTable();
vahedList.Columns.Add(new DataColumn("FieldId", typeof(int)));
foreach (Telerik.Web.UI.RadComboBoxItem item in drpVahed.Items)
{
if (item.Checked)
{
var row = vahedList.NewRow();
row["FieldId"] = Convert.ToInt32(item.Value);
vahedList.Rows.Add(row);
}
}
var madrakTypeid = Convert.ToInt32(drpMadrak.SelectedItem.Value);
int idCaseStatus = Convert.ToInt32(drpStatusCase.SelectedValue.ToString());
int idMadrakStatus = Convert.ToInt32(drpStatusMadrak.SelectedValue.ToString());
if (rdvoroodKartabl.Checked == true)
{
string sodoorstartDate = txtFromKartabl.Text.ToString().formatDateString();
string sodoorEndDate = txtToKartabl.Text.ToString().formatDateString();
dt = reqBusiness.GetListOfCaseInKarTabl(vahedList, sodoorstartDate, sodoorEndDate, fields, danesh, idCaseStatus, idMadrakStatus, madrakTypeid);
grd_Info.Visible = true;
ExcleExportBtn.Visible = true;
RegPcal1();
}
else if (rdSodoor.Checked == true)
{
string sodoorstartDate = TxtFromSodoor.Text.ToString().formatDateString();
string sodoorEndDate = txtToSodoor.Text.ToString().formatDateString();
dt = reqBusiness.GetListOfMadarekByDateSodoor(vahedList, sodoorstartDate, sodoorEndDate, fields, danesh, idCaseStatus, idMadrakStatus, madrakTypeid);
grd_Info.Visible = true;
ExcleExportBtn.Visible = true;
RegPcal2();
}
else if (rdVoroodMadrak.Checked == true)
{
string sodoorstartDate = txtFromVoroodMadrak.Text.ToString().formatDateString();
string sodoorEndDate = txtToDateVoroodMadrak.Text.ToString().formatDateString();
dt = reqBusiness.GetListOfMadrakVoroodUni(vahedList, sodoorstartDate, sodoorEndDate, fields, danesh, idCaseStatus, idMadrakStatus, madrakTypeid);
grd_Info.Visible = true;
ExcleExportBtn.Visible = true;
RegPcal3();
}
else if (rdExitMadrak.Checked == true)
{
string sodoorstartDate = txtFromDateExit.Text.ToString().formatDateString();
string sodoorEndDate = txtToDateExit.Text.ToString().formatDateString();
dt = reqBusiness.GetListOfExitCaseFromKartabl(vahedList, sodoorstartDate, sodoorEndDate, fields, danesh, idCaseStatus, idMadrakStatus, madrakTypeid);
grd_Info.Visible = true;
ExcleExportBtn.Visible = true;
RegPcal4();
}
else
{
var msg = "لطفا یکی از گزینه ها را انتخاب کنید";
RadWindowManager1.RadAlert(msg, 300, 100, "پیام سیستم", "");
}
return(dt);
}