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