using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Newdelhibarassocia.dhadmin
{
    public partial class billcancel : System.Web.UI.Page
    {
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;


        Class1 obj = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                HealthNewsdata();
            }
        }
        public void HealthNewsdata()
        {
            string qrajneeti = "select top 50 * from newdelhibar_bill where Status='Cancel'  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
               
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }



        protected void Unnamed_Click(object sender, EventArgs e)
        {
            if (Request.QueryString["id"] != null)
            {


                if (inputtype.Value == "12345678n")
                {
                    string query = "update  newdelhibar_bill  set Status='Cancel',Remarks='" + TextBox1.Text + "' where Billno='" + Request.QueryString["id"].ToString() + "'";
                    SqlCommand com = new SqlCommand(query, connect);
                    connect.Open();
                    com.ExecuteNonQuery();
                    connect.Close();

                    string query1 = "update newdelhibar_rowbill set Status='Cancel' where Billno='" + Request.QueryString["id"].ToString() + "'";
                    SqlCommand coms = new SqlCommand(query1, connect);
                    connect.Open();
                    coms.ExecuteNonQuery();
                    connect.Close();

                    RegisterStartupScript("12", "<script>alert('Deleted')</script>");
                }
                else
                {

                    RegisterStartupScript("12", "<script>alert('wrong password')</script>");
                }
            }
        }
    }
}