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); } }