protected void btnpreview_OnClick(object sender, EventArgs e)
{
txtiddisplay.Visible = true;
if (string.IsNullOrWhiteSpace(txtsearch.Text.ToString()))
{
//Encodings.MsgBox("! Criteria is Empty !", this.Page, this);
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true);
}
else
{
Session["STIN"] = txtsearch.Text.ToString();
var stringstin = Session["STIN"].ToString();
string strquery = String.Format("SELECT * FROM ViewCertificateInformation WHERE MerchantCode='{0}' AND PayerUtin= '{1}'", sessions.MerchantCode.ToString(), stringstin.ToString());
if (Encodings.IsValidUser(strquery))
{
Response.Write("<script>");
Response.Write("window.open('ViewCertificate.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_Click(object sender, EventArgs e)
{
if ((ddlto.SelectedValue.ToString() == "0") || (ddlyear.SelectedValue.ToString() == "0"))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Criteria is Empty !', 'error');", true);
}
else if (Convert.ToInt32(ddlto.SelectedValue.ToString()) < Convert.ToInt32(ddlyear.SelectedValue.ToString()))
{
//Response.Write("<script>alert('" + " Year To Can not be less than Year from" + "')</script>");
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Year To Can not be less than Year from!', 'error');", true);
}
else
{
txtiddisplay.Visible = true;
Session["yearFrom"] = ddlyear.SelectedValue.ToString();
Session["yearTo"] = ddlto.SelectedValue.ToString();
if (Encodings.IsValidUser(String.Format("SELECT COUNT( DISTINCT TccNo) Reccount, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 1 THEN TccNo END) AS DA, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 2 THEN TccNo END) AS PA, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 3 THEN TccNo END) AS PN, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 4 THEN TccNo END) AS ST, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 5 THEN TccNo END ) AS NR, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 6 THEN TccNo END ) AS UE, COUNT(DISTINCT CASE WHEN IncomeSourceClassifyId = 7 THEN TccNo END) AS DU FROM dbo.ViewTccDetails WHERE YEAR(IssuedDate) BETWEEN {0} AND {1} AND AssessmentYear = YEAR(IssuedDate) - 1 ", ddlyear.SelectedValue, ddlto.SelectedValue)))
{
Response.Write("<script>");
Response.Write("window.open('ViewCummulativeSummary.aspx' ,'_blank')");
Response.Write("</script>");
}
else
{
//Response.Write("<script>alert('" + " No record for the Selected Year " + "')</script>");
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', ' No Record Found for the Selected Year !', 'info');", true);
}
}
}
protected void btnpreview_Click(object sender, EventArgs e)
{
Session["yearFrom"] = ddlyear.SelectedValue.ToString();
Session["yearTo"] = ddlto.SelectedValue.ToString();
if (Convert.ToInt32(ddlto.SelectedValue.ToString()) < Convert.ToInt32(ddlyear.SelectedValue.ToString()))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! Year To Can not be less than Year from !', 'error');", true);
}
else
{
txtiddisplay.Visible = true;
if (Encodings.IsValidUser(String.Format("SELECT a.AssessmentYear, COUNT(DISTINCT a.AssessmentNo) AS Reccount, SUM(a.TaxPayable) TotalPayable, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.AssessmentNo END ) AS DA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.AssessmentNo END) AS PA, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.AssessmentNo END ) AS PN,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.AssessmentNo END ) AS ST, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.AssessmentNo END ) AS NR, COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.AssessmentNo END) AS UE,COUNT(DISTINCT CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.AssessmentNo END) AS DU, COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 1 THEN a.TaxPayable END), 0) DAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 2 THEN a.TaxPayable END),0) PAAmount,COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 3 THEN a.TaxPayable END ), 0) PNAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 4 THEN a.TaxPayable END ),0 ) STAmount, COALESCE(SUM(CASE WHEN a.IncomeSourceClassifyId = 5 THEN a.TaxPayable END),0) NRAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 6 THEN a.TaxPayable END),0) UEAmount,COALESCE(SUM( CASE WHEN a.IncomeSourceClassifyId = 7 THEN a.TaxPayable END),0) DUAmount FROM ViewAssessmentInfor a WHERE a.AssessmentYear BETWEEN {0} AND {1} GROUP BY AssessmentYear ORDER BY AssessmentYear ASC", ddlyear.SelectedValue, ddlto.SelectedValue)))
{
Response.Write("<script>");
Response.Write("window.open('ViewAssessmentYearSummary.aspx' ,'_blank')");
Response.Write("</script>");
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! No record for the Selected Year !', 'error');", true);
}
}
}
protected void btnpreview_OnClick(object sender, EventArgs e)
{
txtiddisplay.Visible = true;
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["Startdate"] = txtstartdate.Text.ToString();
Session["Enddate"] = txtenddate.Text.ToString();
Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString());
Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.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 RegTypeCode, COUNT(RegTypeCode) Rec_Count, CASE WHEN RegTypeCode = 'AG' THEN 'Tax Agents' WHEN RegTypeCode = 'DA' THEN 'Self-Employed' WHEN RegTypeCode = 'PA' THEN 'Employed' ELSE 'Adoch' END Category FROM dbo.vwPayerInfo WHERE PayerName IS NOT NULL AND MerchantCode='{0}' AND Datecreated BETWEEN '{1}' AND '{2}' GROUP BY RegTypeCode HAVING COUNT(RegTypeCode) > 0 ORDER BY Category asc",
sessions.MerchantCode.ToString(), startdate, enddate)))
{
Response.Write("<script>");
Response.Write("window.open('VwSummary.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[] agencylist, DateTime startdate, DateTime enddate)
{
string retvalue = String.Empty;
string strvalue = String.Empty; int j = 0;
int h = agencylist.Count();
for (int i = 0; i < agencylist.Length; i++)
{
strvalue += String.Format("'{0}'", agencylist[i]);
if (j + 1 < h)
{
strvalue += ",";
++j;
}
}
HttpContext.Current.Session["Agencylist"] = strvalue;
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);
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 strrevenue = HttpContext.Current.Session["Agencylist"].ToString();//Session["Agencylist"].ToString();
if (Encodings.IsValidUser(String.Format(
"SELECT PayerID, TaxAgentUtin, TaxAgentName, address, PaymentRefNumber, Amount, RevenueOfficeID, RevenueOfficeName, RevenueCode, PaymentDate,AgencyName,BankName FROM vwRemittance WHERE PaymentDate BETWEEN '{0}' AND '{1}' AND TaxAgentUtin IN ({2}) ORDER BY TaxAgentName ASC",
strat, end, strrevenue)))
{
retvalue = "1";
}
else
{
retvalue = "0";
}
return(JsonConvert.SerializeObject(retvalue));
}
public static string PostPreview(DateTime startdate, DateTime enddate,
string[] agencyid)
{
string strvalue = String.Empty; int j = 0; string retvalue = String.Empty;
int h = agencyid.Count();
for (int i = 0; i < agencyid.Length; i++)
{
strvalue += String.Format("'{0}'", agencyid[i]);
if (j + 1 < h)
{
strvalue += ",";
++j;
}
}
HttpContext.Current.Session["Agencylist"] = strvalue;
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);
var strrevenue = HttpContext.Current.Session["Agencylist"].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");
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",
strat, end, strrevenue)))
{
retvalue = "1";
}
else
{
retvalue = "0";
}
return(JsonConvert.SerializeObject(retvalue));
}
protected void btnpreview_Click(object sender, EventArgs e)
{
//Session["yearFrom"] = ddlyear.SelectedValue.ToString();
//Session["yearTo"] = ddlto.SelectedValue.ToString();
if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString()))
{
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
{
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());
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");
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
string strquery = String.Format("SELECT * FROM ViewAssessmentInfor a WHERE a.AssessmentDate BETWEEN '{0}' AND '{1}' order by GrossIncome desc", startdate, enddate);
if (Encodings.IsValidUser(strquery))
{
Response.Write("<script>");
Response.Write("window.open('ViewAssessmentdetials.aspx' ,'_blank')");
Response.Write("</script>");
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! No record for the Selected Year !', 'error');", true);
}
}
}
public static string PostPreview(DateTime startdate, DateTime enddate, Int32[] officeid)
{
int j = 0; string retvalue = String.Empty; string strvalue = String.Empty;
int h = officeid.Count();
for (int i = 0; i < officeid.Length; i++)
{
strvalue += String.Format("'{0}'", officeid[i]);
if (j + 1 < h)
{
strvalue += ",";
++j;
}
}
HttpContext.Current.Session["Agencylist"] = strvalue;
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);
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 strrevenue = HttpContext.Current.Session["Agencylist"].ToString();
if (Encodings.IsValidUser(String.Format(
"SELECT BusinessTypeID, BusinessTypeName, SUM(Amount) AS Amount FROM dbo.vwBusinessSectors WHERE PaymentDate BETWEEN '{0}' AND '{1}' AND BusinessTypeID IN ({2}) GROUP BY BusinessTypeID, BusinessTypeName ORDER BY BusinessTypeName ASC",
strat, end, strrevenue)))
{
retvalue = "1";
}
else
{
retvalue = "0";
}
return(JsonConvert.SerializeObject(retvalue));
}
protected void btnpreview_OnClick(object sender, EventArgs e)
{
//Encodings.MsgBox("You Need to Enable your Browser Pop-Up at the Top Right Corner to View the report", this.Page, this);
txtiddisplay.Visible = true;
if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString()))
{
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
{
Session["Startdate"] = txtstartdate.Text.ToString();
Session["Enddate"] = txtenddate.Text.ToString();
Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString());
Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.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 * FROM ViewTaxAgent WHERE MerchantCode='{0}' AND Datecreated BETWEEN '{1}' AND '{2}' ORDER BY OrganizationName ASC",
sessions.MerchantCode.ToString(), startdate, enddate)))
{
Response.Write("<script>");
Response.Write("window.open('ViewAgent.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;
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
{
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 RevenueOfficeID, RevenueOfficeName, SUM(Amount) Amount FROM ViewNormalizedPayment WHERE RevenueOfficeID IS NOT NULL AND PaymentDate BETWEEN '{0}' AND '{1}' GROUP BY RevenueOfficeID, RevenueOfficeName ORDER BY RevenueOfficeName ASC", startdate, enddate);
if (Encodings.IsValidUser(strquery))
{
Response.Write("<script>");
Response.Write("window.open('ViewNormalized.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)
{
SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet();
txtiddisplay.Visible = true;
//test if the date is empty
if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString()))
{
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
{
Session["Startdate"] = txtstartdate.Text.ToString();
Session["Enddate"] = txtenddate.Text.ToString();
Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString());
Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.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 * FROM ViewPaye WHERE MerchantCode='{0}' AND Datecreated BETWEEN '{1}' AND '{2}' ORDER BY OrganizationName ASC", sessions.MerchantCode.ToString(), startdate, enddate)))
{
Response.Write("<script>");
Response.Write("window.open('ViewPay.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 !', 'error');", true);
}
}
}
protected void btnpreview_OnClick(object sender, EventArgs e)
{
txtiddisplay.Visible = true;
if (string.IsNullOrWhiteSpace(txtstartdate.Text.ToString()) || string.IsNullOrWhiteSpace(txtenddate.Text.ToString()))
{
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()))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Report!', '! End Date Greater Than Start Date !', 'error');", true);
}
else
{
Session["Startdate"] = txtstartdate.Text.ToString();
Session["Enddate"] = txtenddate.Text.ToString();
Session["startdate1"] = Convert.ToDateTime(txtstartdate.Text.ToString());
Session["Enddate1"] = Convert.ToDateTime(txtenddate.Text.ToString());
//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 (Encodings.IsValidUser(String.Format("SELECT MerchantCode,PayerUtin,PayerID,PayerName,PaymentAmount,Amount,PaymentDate, RequestedBy,ReceiptDate, ApprovedBy, ApprovedDate,RequestName, ApproveName,PayerType, PayerTypeName FROM dbo.vwPaymentNormalisations WHERE PaymentDate BETWEEN '{0}' AND '{1}' AND MerchantCode= '{2}'",
startdate, enddate, sessions.MerchantCode.ToString())))
{
Response.Write("<script>");
Response.Write("window.open('ViewNormalisation.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);
}
}
}
}
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));
}
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)
{
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_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);
}
}
}