protected void btn_ShowReport_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
img_ExportToExcel2.Visible = false;
img_ExportToExcel3.Visible = false;
img_ExportToExcel4.Visible = false;
img_ExportToExcel5.Visible = false;
img_ExportToExcel6.Visible = false;
if (rdb_ListSabegheByTerm.Checked == true)
{
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (ddl_Departman.SelectedValue == null)
{
ddl_Departman.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
string AzTerm = txt_FromTerm.Text;
string TaTerm = txt_ToTerm.Text;
dtResault = FRB.GetTeachingExperienceProf(txt_CodeOstad.Text, int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), AzTerm, TaTerm);
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی یافت نشد ", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportListOfSelectedCoursesTeachersByTerm1.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@idostad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@Tatterm"].ParameterValue = TaTerm;
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@idgroup"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@idnahveh"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProfByTerm]"].Parameters["@Aztterm"].ParameterValue = AzTerm;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
else if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0")
{
RadWindowManager1.RadAlert("لطفا ترم مورد نظر را انتخاب بفرمایید", 0, 100, "پیام", "");
}
else
{
if (rdb_EblaghAsatid.Checked == true)
{
//if (rdb_EblaghBarAsasGroup.Checked == true)
//{
// order = 1;
//}
//if (rdb_EblaghBarAsasName.Checked == true)
//{
// order = 2;
//}
order = 1;
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (ddl_Departman.SelectedValue == null)
{
ddl_Departman.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
dtResault = FRB.GetNotificationProf(txt_CodeOstad.Text, ddl_Term.SelectedValue, int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), order);
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی یافت نشد ", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel2.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportNotificationProfByGroup.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idostad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@tterm"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idgroup"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idnahveh"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@order"].ParameterValue = order;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
else if (rdb_EblaghExam.Checked == true)
{
//if (rdb_EblaghBarAsasGroup.Checked == true)
//{
// order = 1;
//}
//if (rdb_EblaghBarAsasName.Checked == true)
//{
// order = 2;
//}
order = 1;
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (ddl_Departman.SelectedValue == null)
{
ddl_Departman.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
dtResault = FRB.GetNotificationProf(txt_CodeOstad.Text, ddl_Term.SelectedValue, int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), order);
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی یافت نشد ", 0, 100, "پیام", "");
}
else if (chk_koli.Checked == true)
{
img_ExportToExcel3.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportNotificationReportAll.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idostad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@tterm"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idgroup"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idnahveh"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@order"].ParameterValue = order;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
else
{
img_ExportToExcel4.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportNotificationProfessors.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idostad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@tterm"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idgroup"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@idnahveh"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_NotificationProfessors]"].Parameters["@order"].ParameterValue = order;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
else if (rdb_TedadVahed.Checked == true)
{
//if (rdb_EblaghBarAsasGroup.Checked == true)
//{
// order = 1;
//}
//if (rdb_EblaghBarAsasName.Checked == true)
//{
// order = 2;
//}
order = 1;
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (ddl_Departman.SelectedValue == null)
{
ddl_Departman.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
dtResault = FRB.GetListOfSelectedCoursesTeachers(txt_CodeOstad.Text, ddl_Term.SelectedValue, int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی یافت نشد ", 0, 100, "پیام", "");
}
else
{
//Report ...
img_ExportToExcel5.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportListOfSelectedCoursesTeachers.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@idostad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@iddanesh"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@idgroup"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@idnahveh"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
//rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExprerienceProf]"].Parameters["@order"].ParameterValue = order;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
else if (rdb_ListSabegheByTerm.Checked == true)
{
}
else if (rdb_ListSavabeghRuz.Checked == true)
{
if (txt_ListSavabeghRuz.Text == string.Empty)
{
txt_ListSavabeghRuz.Text = "0";
}
string Number = txt_ListSavabeghRuz.Text;
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (ddl_Departman.SelectedValue == null)
{
ddl_Departman.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
dtResault = FRB.TeachingExperienceMoreThanADay(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), int.Parse(txt_ListSavabeghRuz.Text));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel6.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportTeachingExperienceMoreThanADay.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExperienceMoreThanADay]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExperienceMoreThanADay]"].Parameters["@Number"].ParameterValue = int.Parse(Number);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExperienceMoreThanADay]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_Departman.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExperienceMoreThanADay]"].Parameters["@Cooperation"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_TeachingExperienceMoreThanADay]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
}
}