using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{


    string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
    //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
    SqlCommand cmd; SqlDataReader Dr; SqlDataAdapter da;

    public bool RecordExist(string sSql)
    {

        SqlConnection connect = new SqlConnection(strCon);
        //			
        //			if ( connect.State=connect.Open()  )
        //			{
        //				connect.Close(); 
        //				connect.Open(); 
        //			}
        //			else
        //			{
        connect.Open();
        //}

        cmd = new SqlCommand(sSql);
        cmd.Connection = connect;
        cmd.ExecuteNonQuery();
        Dr = cmd.ExecuteReader();

        if (Dr.HasRows)
        {
            cmd.Connection.Close();//Ratnesh
            return true;

        }
        else
        {
            cmd.Connection.Close();//Ratnesh
            return false;

        }



    }
    //===========================================================================

    public void fillDropTwo(string sql, DropDownList drop)
    {

        //int i;
        drop.Items.Clear();
        // string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        //drop.Items.Add("-- Please Select --");  
        drop.DataSource = ds;
        drop.DataTextField = "VendorName";
        drop.DataValueField = "VendorCode";
        drop.DataBind();
        drop.Items.Insert(0, "-- Please Select --");
        drop.Items.Insert(1, "All");
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() );      
        //			}   
    }
    //----------------------------------------------------------------------------



    public void FillZoneName(string sql, DropDownList drop)
    {

        //int i;
        drop.Items.Clear();
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        //drop.Items.Add("-- Please Select --");  
        drop.DataSource = ds;
        drop.DataTextField = "ZoneName";
        drop.DataValueField = "ZoneId";
        drop.DataBind();
        drop.Items.Insert(0, "-- Select --");
        //drop.Items.Insert(1,"All"); 
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() );      
        //			}   
    }
    //----------------------------------------------------------------------------









    public void fillDropTendor(string sql, DropDownList drop)
    {

        //int i;
        drop.Items.Clear();
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        //drop.Items.Add("-- Please Select --");  
        drop.DataSource = ds;
        drop.DataTextField = "tendertitle";
        drop.DataValueField = "TenderNumber";
        drop.DataBind();
        drop.Items.Insert(0, "-- Select Tender Name --");
        //drop.Items.Insert(1,"All"); 
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() );      
        //			}   
    }
    //==========================================================================

    public void fillDropTendorLPR(string sql, DropDownList drop)
    {

        //int i;
        drop.Items.Clear();
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        //drop.Items.Add("-- Please Select --");  
        drop.DataSource = ds;
        drop.DataTextField = "tendertitle";
        drop.DataValueField = "LprNumber";
        drop.DataBind();
        drop.Items.Insert(0, "-- Select Tender Name --");
        //drop.Items.Insert(1,"All"); 
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() );      
        //			}   
    }

    //===========================================================================

    public void fillGrid(string sql, DataGrid dg)
    {

        //int i;
        //drop.Items.Clear();  
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        //drop.Items.Add("-- Please Select --");  


        dg.DataSource = ds;
        //drop.DataTextField="VendorName";
        //drop.DataValueField="VendorCode";
        dg.DataBind();

        //drop.Items.Insert(0,"-- Please Select --");  
        //drop.Items.Insert(1,"All"); 
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() );      
        //			}   
    }
    //===============================================================================

    public System.Data.DataSet ReturnDataSet(string sql)
    {
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        return (ds);
    }
    public int removedupli(DropDownList ddl, string txt)
    {
        for (int i = 0; i < ddl.Items.Count; i++)
        {
            if (txt == ddl.Items[i].Text.ToString().Trim())
            {
                return i;
            }
        }
        return 0;

    }

    public int removedupliValue(DropDownList ddl, string txt)
    {
        for (int i = 0; i < ddl.Items.Count; i++)
        {
            if (txt == ddl.Items[i].Value.ToString().Trim())
            {
                return i;
            }
        }
        return 0;

    }

    public System.Data.DataTable ReturnDataTable(string sql)
    {
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataTable ds = new DataTable();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds);

        return (ds);
    }



    public void fillDropForInactive(string sql, DropDownList drop)
    {

        int i;
        drop.Items.Clear();
        // string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        drop.Items.Add("All");
        for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
        {
            drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString());
        }
    }


    //===========================================================================
    public void fillDrop(string sql, DropDownList drop)
    {

        int i;
        drop.Items.Clear();
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        //connect.Open();
        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        drop.Items.Add("--Please Select--");
        for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
        {
            drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString());
        }
        //connect.Close();

    }
    public void fillListBox(string sql, ListBox lBox)
    {
        //int i;
        //lBox.Items.Clear();  
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        SqlCommand cmd = new SqlCommand(sql, connect);
        cmd.Connection.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            lBox.Items.Add(dr.GetString(0));
        }
        cmd.Connection.Close();
        //			DataSet ds=new DataSet() ;
        //			da=new SqlDataAdapter(sql,connect);
        //			da.Fill(ds,"r");
        //			//lBox.Items.Add("-- Please Select --");  
        //			for(i=0;i<= ds.Tables[0].Rows.Count -1 ;i++)
        //			{
        //				//lBox.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString());      
        //                lBox.Items.Add(ds.Tables[0].Rows[i].ItemArray.ToString());
        //			}   
    }
    public void fillDropDouble(string sql, DropDownList drop)
    {

        int i;
        drop.Items.Clear();
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);

        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql, connect);
        da.Fill(ds, "r");
        drop.Items.Add("-- Please Select --");
        for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
        {
            drop.Items.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString() + "           " + ds.Tables[0].Rows[i].ItemArray.GetValue(1).ToString());
        }
    }

    public int SaveRecord(string query)
    {
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection con1234 = new SqlConnection(strCon);
        con1234.Open();
        SqlCommand cmd1234 = new SqlCommand(query, con1234);
        int x = cmd1234.ExecuteNonQuery();
        con1234.Close();
        return x;
    }
    public int DeleteRecord(string sSql)
    {
        //string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
        SqlConnection connect = new SqlConnection(strCon);
        SqlConnection con = new SqlConnection(strCon);
        con.Open();

        cmd = new SqlCommand(sSql);
        cmd.Connection = con;
        int x = cmd.ExecuteNonQuery();
        con.Close();//Ratnesh
        return x;
    }
    public string returnCode(string sSql)
    {
        SqlConnection con = new SqlConnection(strCon);
        con.Open();
        cmd = new SqlCommand(sSql);
        cmd.Connection = con;
        cmd.ExecuteNonQuery();
        Dr = cmd.ExecuteReader();
        if (Dr.Read())
        {
            //if(Dr.GetValue(0)!=DBNull.Value)
            string x = Dr.GetValue(0).ToString().Trim();
            cmd.Connection.Close();//Ratnesh
            return x;

        }
        else
        {
            cmd.Connection.Close();//Ratnesh
            return "0";
        }

    }

    //string txt_txtpass; 
    //string txt_txtretype;
    public float returnData(string sSql)
    {
        SqlConnection con = new SqlConnection(strCon);
        con.Open();
        cmd = new SqlCommand(sSql);
        cmd.Connection = con;
        cmd.ExecuteNonQuery();
        Dr = cmd.ExecuteReader();
        if (Dr.Read())
        {
            //if(Dr.GetValue(0)!=DBNull.Value)

            float y = float.Parse(Dr.GetValue(0).ToString().Trim());
            cmd.Connection.Close();//Ratnesh
            return y;
            //return Dr.GetValue(0).ToString().Trim();
        }
        else
        {
            cmd.Connection.Close();//Ratnesh
            return 0;
        }

    }





    public Class1()
    {
        //
        // TODO: Add constructor logic here
        //
    }
}