protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Current Specific ILC Status");
string ILCID = ilcDDL.SelectedValue.ToString();
Session["ILCID"] = ILCID;
rprt.Load(Server.MapPath("~/rptCurrentSpecificILCStatus.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin@123", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Logged_On_User", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = ILCID;
field1.CurrentValues.Add(val1);
}
protected void rptAllSchoolBTN_Click(object sender, EventArgs e)
{
string filename = "All School Report";
TrackReportGeneration.Add(filename);
Response.Redirect("AllSchoolDetails.aspx");
}
protected void rptDivWiseTodaysILCStatus_Click(object sender, EventArgs e)
{
string filename = "Division Wise ILC Status Report";
TrackReportGeneration.Add(filename);
Response.Redirect("DivWiseILCStatusForToday.aspx");
}
protected void rptDateWiseILCStatusBTN_Click(object sender, EventArgs e)
{
string filename = "Specific ILC Information Report";
TrackReportGeneration.Add(filename);
Response.Redirect("DateWiseILCStatus.aspx");
}
protected void rptSpecificSchoolBTN_Click(object sender, EventArgs e)
{
string filename = "Specific ILC Information Report";
TrackReportGeneration.Add(filename);
Response.Redirect("SpecificSchoolDetails.aspx");
}
protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Current Specific ILC Status");
if (userType == "2")
{
string ILCID = Session["ein"].ToString();
rprt.Load(Server.MapPath("~/rptCurrentSpecificILCStatus.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Logged_On_User", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = ILCID;
field1.CurrentValues.Add(val1);
}
else
{
string schoolName = ilcNameDDL.SelectedValue.ToString();
string ILCID = "";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlDataReader dr;
SqlCommand cmd;
con.Open();
string query = "SELECT * FROM Location WHERE ILCEng = '" + schoolName + "'";
cmd = new SqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
ILCID = dr[0].ToString();
}
Session["ILCID"] = ILCID;
con.Close();
rprt.Load(Server.MapPath("~/rptCurrentSpecificILCStatus.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Logged_On_User", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = ILCID;
field1.CurrentValues.Add(val1);
}
}
protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Details Report");
//Getting the input values from front-end
string ILCID = ilcDDL.SelectedValue.ToString();
string fromDate = datePickerFrom.Text;
string toDate = datePickerTo.Text;
Session["ILCID"] = ILCID;
rprt.Load(Server.MapPath("~/rptDateWiseDetailUser.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin@123", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Logged_On_User_Details", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vDateFrom", fromDate);
cmdRpt.Parameters.AddWithValue("@vDateTo", toDate);
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].ExtendedProperties.Count != 0)
{
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = fromDate;
field1.CurrentValues.Add(val1);
ParameterField field2 = this.crv.ParameterFieldInfo[1];
ParameterDiscreteValue val2 = new ParameterDiscreteValue();
val2.Value = toDate;
field2.CurrentValues.Add(val2);
ParameterField field3 = this.crv.ParameterFieldInfo[2];
ParameterDiscreteValue val3 = new ParameterDiscreteValue();
val3.Value = ILCID;
field3.CurrentValues.Add(val3);
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "SomeKey", "alert('Nothing to show');", true);
}
}
protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("District wise ILC Status");
string districtName = ilcDistrictDDL.SelectedValue.ToString();
string districtID = "";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlDataReader dr;
SqlCommand cmd;
con.Open();
string query = "SELECT DistCode FROM tblDistrict WHERE DistName = '" + districtName + "'";
cmd = new SqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
districtID = dr[0].ToString();
}
Session["districtID"] = districtID;
con.Close();
rprt.Load(Server.MapPath("~/rptDistrictWiseTodaysILCReport.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Server_Active_Status_District", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vDistCode", districtID);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = districtID;
field1.CurrentValues.Add(val1);
}
protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Division wise wise ILC Status");
string divisionName = ilcDivisionDDL.SelectedValue.ToString();
rprt.Load(Server.MapPath("~/rptDivisionWiseTodaysILCReport.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_ILC_Server_Active_Status_Division", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vDivCode", divisionName);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = divisionName;
field1.CurrentValues.Add(val1);
}
protected void rptCurrentILCStatusBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Current ILC Status of All School");
Response.Redirect("CurrentILCStatus.aspx");
}
protected void rptILCRanking_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("ILC Ranking");
Response.Redirect("ILCRanking.aspx");
}
protected void CurrentAllILCStatus_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Current All ILC Status");
Response.Redirect("CurrentAllILCStatus.aspx");
}
protected void dateWiseILCStatusDetailsBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Date Wise Detailed ILC Status");
Response.Redirect("DateWiseDetailUserReport.aspx");
}
protected void rptBTN_Click(object sender, EventArgs e)
{
TrackReportGeneration.Add("Date Wise ILC Status");
if (userType == "ILC-Admin")
{
string fromDate = datePickerFrom.Text;
string toDate = datePickerTo.Text;
string ILCID = Session["ein"].ToString();
rprt.Load(Server.MapPath("~/rptDateWiseILCStatus.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin@123", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_Date_Wise_ILC_Status", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
cmdRpt.Parameters.AddWithValue("@vDateFrom", fromDate);
cmdRpt.Parameters.AddWithValue("@vDateTo", toDate);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = ILCID;
field1.CurrentValues.Add(val1);
ParameterField field2 = this.crv.ParameterFieldInfo[1];
ParameterDiscreteValue val2 = new ParameterDiscreteValue();
val2.Value = fromDate;
field2.CurrentValues.Add(val2);
ParameterField field3 = this.crv.ParameterFieldInfo[2];
ParameterDiscreteValue val3 = new ParameterDiscreteValue();
val3.Value = toDate;
field3.CurrentValues.Add(val3);
}
else
{
//Getting the input values from front-end
string schoolName = ilcNameDDL.SelectedValue.ToString();
string fromDate = datePickerFrom.Text;
string toDate = datePickerTo.Text;
string ILCID = "";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlDataReader dr;
SqlCommand cmd;
con.Open();
string query = "SELECT * FROM Location WHERE ILCEng = '" + schoolName + "'";
cmd = new SqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
ILCID = dr[6].ToString();
}
Session["ILCID"] = ILCID;
con.Close();
rprt.Load(Server.MapPath("~/rptDateWiseILCStatus.rpt"));
rprt.SetDatabaseLogon("sa", "sqladmin@123", "103.234.26.37", "SESIP", true);
SqlConnection conRpt = new SqlConnection(ConfigurationManager.ConnectionStrings["ILCDBConnectionString"].ToString());
SqlCommand cmdRpt = new SqlCommand("SP_Date_Wise_ILC_Status", conRpt);
cmdRpt.CommandType = CommandType.StoredProcedure;
cmdRpt.Parameters.AddWithValue("@vILCID", ILCID);
cmdRpt.Parameters.AddWithValue("@vDateFrom", fromDate);
cmdRpt.Parameters.AddWithValue("@vDateTo", toDate);
SqlDataAdapter sda = new SqlDataAdapter(cmdRpt);
DataSet ds = new DataSet();
sda.Fill(ds);
rprt.SetDataSource(ds);
crv.ReportSource = rprt;
ParameterField field1 = this.crv.ParameterFieldInfo[0];
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
val1.Value = ILCID;
field1.CurrentValues.Add(val1);
ParameterField field2 = this.crv.ParameterFieldInfo[1];
ParameterDiscreteValue val2 = new ParameterDiscreteValue();
val2.Value = fromDate;
field2.CurrentValues.Add(val2);
ParameterField field3 = this.crv.ParameterFieldInfo[2];
ParameterDiscreteValue val3 = new ParameterDiscreteValue();
val3.Value = toDate;
field3.CurrentValues.Add(val3);
}
}