protected void btnpreview_OnClick(object sender, EventArgs e) { txtiddisplay.Visible = true; // Encodings.MsgBox("You Need to Enable your Browser Pop-Up at the Top Right Corner to View the report", this.Page, "Report Not Showing?"); if (string.IsNullOrEmpty(ddlAgency.SelectedValue.ToString())) { //Encodings.MsgBox("! Criteria is Empty !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true); return; } else if (string.IsNullOrEmpty(ddlRevenue.SelectedValue.ToString())) { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true); return; } else if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString())) { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Start Date is Empty !', 'error');", true); } else if (string.IsNullOrWhiteSpace(txtenddate.Text.ToString())) { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date is Empty !', 'error');", true); } else if (Convert.ToDateTime(txtenddate.Text.ToString()) < Convert.ToDateTime(txtstartdate.Text.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date Greater Than Start Date !', 'error');", true); } else { Session["Agency"] = ddlAgency.SelectedValue.ToString(); Session["Revenue"] = ddlRevenue.SelectedValue.ToString(); Session["RevenueName"] = ddlRevenue.SelectedItem.ToString(); var gb = Convert.ToDateTime(txtstartdate.Text.ToString()); Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString()); Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.ToString()); Session["Startdate"] = txtstartdate.Text.ToString(); Session["Enddate"] = txtenddate.Text.ToString(); var strrevenue = Session["Revenue"].ToString(); var startdate = Session["Startdate"].ToString(); var enddate = Session["Enddate"].ToString(); string strquery = String.Format("SELECT * FROM ViewPayment WHERE PaymentDate BETWEEN '{0}' AND '{1}' and RevenueCode ='{2}' ORDER BY PaymentDate ASC", startdate, enddate, strrevenue); if (Encodings.IsValidUser(strquery)) { Response.Write("<script>"); Response.Write("window.open('ViewPayment.aspx' ,'_blank')"); Response.Write("</script>"); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', ' No Record Found for the Selected Range !', 'info');", true); } } }
protected void btnpreview_Click(object sender, EventArgs e) { //int totalCount = gridOffence.Rows.Cast<GridViewRow>() // .Count(r => ((CheckBox)r.FindControl("CheckBox1")).Checked); if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString())) { //Encodings.MsgBox("! Criteria is Empty !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true); } else if (Convert.ToDateTime(txtenddate.Text.ToString()) < Convert.ToDateTime(txtstartdate.Text.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date Greater Than Start Date !', 'error');", true); } else { //foreach (GridViewRow row in gridOffence.Rows) //{ // CheckBox chk = (CheckBox)row.FindControl("CheckBox1"); // Label lbltin = (Label)row.FindControl("lbltin"); // if (chk != null & chk.Checked) // { // strvalue += String.Format("'{0}'", lbltin.Text); // if (j + 1 < totalCount) // { // strvalue += ","; // ++j; // } // } //} txtiddisplay.Visible = true; Session["Startdate"] = txtstartdate.Text.ToString(); Session["Enddate"] = txtenddate.Text.ToString(); Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString()); Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.ToString()); Session["Agencylist"] = strvalue; var strrevenue = Session["Agencylist"].ToString(); var startdate = Session["Startdate"].ToString(); var enddate = Session["Enddate"].ToString(); var end = Convert.ToDateTime(Session["Enddate1"].ToString()).ToString("dd/MM/yyyy"); var strat = Convert.ToDateTime(Session["startdate1"].ToString()).ToString("dd/MM/yyyy"); if (string.IsNullOrWhiteSpace(strvalue.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Agency List Empty !', 'error');", true); return; } else { if (Encodings.IsValidUser(String.Format( "SELECT AgencyName,AgencyCode,SUM(Amount) Amount,DATEPART(YEAR,PaymentDate) Year FROM vwCollectionRaw WHERE PaymentDate BETWEEN '{0}' AND '{1}' AND AgencyCode IN ({2}) GROUP BY AgencyName,AgencyCode,DATEPART(YEAR,PaymentDate) ORDER BY AgencyName ASC", startdate, enddate, strrevenue))) { Response.Write("<script>"); Response.Write("window.open('ViewYear.aspx' ,'_blank')"); Response.Write("</script>"); } else { //Encodings.MsgBox("! No Record Found for the Selected Range !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', ' No Record Found for the Selected Range !', 'info');", true); } } } }
protected void btnpreview_OnClick(object sender, EventArgs e) { txtiddisplay.Visible = true; string strvalue = String.Empty; int j = 0; if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString())) { //Encodings.MsgBox("! Criteria is Empty !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true); return; } if (Convert.ToDateTime(txtenddate.Text.ToString()) < Convert.ToDateTime(txtstartdate.Text.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date Greater Than Start Date !', 'error');", true); return; } if (string.IsNullOrEmpty(ddlRevenue.SelectedValue.ToString())) { return; } if (string.IsNullOrEmpty(txtno.Text.ToString())) { return; } Session["nos"] = txtno.Text.ToString(); Session["Startdate"] = txtstartdate.Text.ToString(); Session["Enddate"] = txtenddate.Text.ToString(); Session["Revenuecode"] = ddlRevenue.SelectedValue.ToString(); Session["RevenueName"] = ddlRevenue.SelectedItem.ToString(); Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString()); Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.ToString()); //int totalCount = gridOffence.Rows.Cast<GridViewRow>() // .Count(r => ((CheckBox)r.FindControl("Chkid")).Checked); //int totalCount = gridOffence.Rows.Cast<GridViewRow>() // .Count(r => ((CheckBox)r.FindControl("CheckBox1")).Checked); //foreach (GridViewRow row in gridOffence.Rows) //{ // CheckBox chk = (CheckBox)row.FindControl("CheckBox1"); // Label lbltin = (Label)row.FindControl("lbloffice"); // if (chk != null & chk.Checked) // { // strvalue += String.Format("'{0}'", lbltin.Text); //if (j + 1 < totalCount) //{ // strvalue += ","; // ++j; //} // } //} if (string.IsNullOrWhiteSpace(strvalue.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Revenue Office Empty !', 'error');", true); return; } else { Session["RevenueofficeID"] = strvalue; var strrevenue = Session["Revenuecode"].ToString(); var startdate = Session["Startdate"].ToString(); var enddate = Session["Enddate"].ToString(); var end = Convert.ToDateTime(Session["Enddate1"].ToString()).ToString("dd/MM/yyyy"); var strat = Convert.ToDateTime(Session["startdate1"].ToString()).ToString("dd/MM/yyyy"); var strrevenueofficeid = Session["RevenueofficeID"].ToString(); int nos = Convert.ToInt32(Session["nos"].ToString()); string strquery = String.Format( "SELECT DISTINCT TOP {0} TaxAgentUtin,TaxAgentName,SUM(Amount) Amount,RevenueOfficeID,RevenueOfficeName,RevenueCode,RevenueName,DATEPART(MONTH, PaymentDate) AS MONTH,DATEPART(YEAR, PaymentDate) AS YEAR,CONVERT(VARCHAR, DATEPART(MONTH, PaymentDate)) + '/' + CONVERT(VARCHAR, DATEPART(YEAR, PaymentDate)) AS Period FROM vwCollectionRanking WHERE PaymentDate BETWEEN '{1}' AND '{2}' AND RevenueCode ='{3}' AND RevenueOfficeID IN ({4}) GROUP BY TaxAgentUtin, TaxAgentName, RevenueOfficeID,RevenueOfficeName,RevenueCode, RevenueName,DATEPART(MONTH, PaymentDate), DATEPART(YEAR, PaymentDate) ORDER BY TaxAgentName ASC", nos, startdate, enddate, strrevenue, strrevenueofficeid); if (Encodings.IsValidUser(strquery)) { Response.Write("<script>"); Response.Write("window.open('ViewCollectionRanking.aspx' ,'_blank')"); Response.Write("</script>"); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', ' No Record Found for the Selected Range !', 'info');", true); } } }
protected void btnpreview_OnClick(object sender, EventArgs e) { int totalCount = gridOffence.Rows.Cast <GridViewRow>() .Count(r => ((CheckBox)r.FindControl("CheckBox1")).Checked); if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString())) { //Encodings.MsgBox("! Criteria is Empty !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true); } else if (Convert.ToDateTime(txtenddate.Text.ToString()) < Convert.ToDateTime(txtstartdate.Text.ToString())) { //Encodings.MsgBox("End Date Greater Than Start Date !", this.Page, this); this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date Greater Than Start Date !', 'error');", true); } else if (ddlRevenue.Items.Count == 0) { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Select Revenue Type !', 'error');", true); } else { var str = ddlRevenue.SelectedItem.ToString(); foreach (GridViewRow row in gridOffence.Rows) { CheckBox chk = (CheckBox)row.FindControl("CheckBox1"); Label lbltin = (Label)row.FindControl("lbltin"); if (chk != null & chk.Checked) { strvalue += String.Format("{0}", lbltin.Text); if (j + 1 < totalCount) { strvalue += ","; ++j; } } } txtiddisplay.Visible = true; Session["RevenueTypecode"] = ddlRevenue.Text.ToString(); Session["RevenueTypeName"] = ddlRevenue.SelectedItem.ToString(); Session["Startdate"] = txtstartdate.Text.ToString(); Session["Enddate"] = txtenddate.Text.ToString(); Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString()); Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.ToString()); Session["RevenueOfficeID"] = strvalue; var strrevenue = Session["RevenueOfficeID"].ToString(); var strrevennuetypecode = Session["RevenueTypecode"].ToString(); var startdate = Session["Startdate"].ToString(); var enddate = Session["Enddate"].ToString(); var end = Convert.ToDateTime(Session["Enddate1"].ToString()).ToString("dd/MM/yyyy"); var strat = Convert.ToDateTime(Session["startdate1"].ToString()).ToString("dd/MM/yyyy"); if (Encodings.IsValidUser(String.Format( "SELECT OrganizationName,TaxAgentTIN,RevenueOfficeID,RevenueOfficeName, Months, SUM(Amount) Amount FROM vwTrend WHERE PaymentDate BETWEEN '{0}' AND '{1}' AND RevenueOfficeID IN ({2}) AND RevenueCode= '{3}' GROUP BY OrganizationName, TaxAgentTIN, RevenueOfficeID,RevenueOfficeName, Months ORDER BY OrganizationName ASC", startdate, enddate, strrevenue, strrevennuetypecode))) { Response.Write("<script>"); Response.Write("window.open('ViewTrend.aspx' ,'_blank')"); Response.Write("</script>"); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', ' No Record Found for the Selected Range !', 'info');", true); } } }
public static string PostPreview(string Revenuetype, Int32 nums, DateTime startdate, DateTime enddate, Int32[] reveuneofficeid, string RevenueName) { string strvalue = String.Empty; int j = 0; string retvalue = String.Empty; int h = reveuneofficeid.Count(); for (int i = 0; i < reveuneofficeid.Length; i++) { strvalue += String.Format("'{0}'", reveuneofficeid[i]); if (j + 1 < h) { strvalue += ","; ++j; } } HttpContext.Current.Session["nos"] = nums; HttpContext.Current.Session["RevenueofficeID"] = strvalue; HttpContext.Current.Session["Revenuecode"] = Revenuetype; HttpContext.Current.Session["Startdate"] = Convert.ToDateTime(startdate); HttpContext.Current.Session["startdate1"] = Convert.ToDateTime(startdate); HttpContext.Current.Session["Enddate"] = Convert.ToDateTime(enddate); HttpContext.Current.Session["Enddate1"] = Convert.ToDateTime(enddate); HttpContext.Current.Session["RevenueName"] = RevenueName; var strrevenue = HttpContext.Current.Session["Revenuecode"].ToString(); var startdat = string.Format("{0:yyyy-MM-dd}", HttpContext.Current.Session["Startdate"].ToString()); var enddat = string.Format("{0:yyyy-MM-dd}", HttpContext.Current.Session["Enddate"].ToString()); var end = Convert.ToDateTime(HttpContext.Current.Session["Enddate1"].ToString()).ToString("yyyy/MM/dd"); var strat = Convert.ToDateTime(HttpContext.Current.Session["startdate1"].ToString()).ToString("yyyy/MM/dd"); var strrevenueofficeid = HttpContext.Current.Session["RevenueofficeID"].ToString(); int nos = Convert.ToInt32(HttpContext.Current.Session["nos"].ToString()); string strquery = String.Format( "SELECT DISTINCT TOP {0} TaxAgentUtin,TaxAgentName,SUM(Amount) Amount,RevenueOfficeID,RevenueOfficeName,RevenueCode,RevenueName,DATEPART(MONTH, PaymentDate) AS MONTH,DATEPART(YEAR, PaymentDate) AS YEAR,CONVERT(VARCHAR, DATEPART(MONTH, PaymentDate)) + '/' + CONVERT(VARCHAR, DATEPART(YEAR, PaymentDate)) AS Period FROM vwCollectionRanking WHERE PaymentDate BETWEEN '{1}' AND '{2}' AND RevenueCode ='{3}' AND RevenueOfficeID IN ({4}) GROUP BY TaxAgentUtin, TaxAgentName, RevenueOfficeID,RevenueOfficeName,RevenueCode, RevenueName,DATEPART(MONTH, PaymentDate), DATEPART(YEAR, PaymentDate) ORDER BY TaxAgentName ASC", nos, strat, end, strrevenue, strrevenueofficeid); if (Encodings.IsValidUser(strquery)) { retvalue = "1"; } else { retvalue = "0"; } return(JsonConvert.SerializeObject(retvalue)); }