protected void Page_Load(object sender, EventArgs e)
{
//Establish the database connection
using (SqlConnection Connect = new SqlConnection("data source=.;database=assignment;integrated security= SSPI"))
{
SqlDataAdapter SDA = new SqlDataAdapter("Select * from students", Connect); //to retrive the data from database- student created
SqlDataAdapter SDA1 = new SqlDataAdapter("Select * from Employee", Connect); //to retrive the data from database- student created
SqlDataAdapter SDA2 = new SqlDataAdapter("Select * from CricketTeam", Connect); //to retrive the data from database- student created
SqlDataAdapter SDA3 = new SqlDataAdapter("Select * from IRS", Connect); //to retrive the data from database- student created
SqlDataAdapter SDA4 = new SqlDataAdapter("Select * from Bank_EmployeeDetails", Connect); //to retrive the data from database- student created
DataSet ds = new DataSet(); //to convert the data into the grid.
DataSet ds1 = new DataSet(); //to convert the data into the grid.
DataSet ds2 = new DataSet(); //to convert the data into the grid.
DataSet ds3 = new DataSet(); //to convert the data into the grid.
DataSet ds4 = new DataSet(); //to convert the data into the grid.
SDA.Fill(ds);
SDA1.Fill(ds1);
SDA2.Fill(ds2);
SDA3.Fill(ds3);
SDA4.Fill(ds4);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
DataGrid2.DataSource = ds1;
DataGrid2.DataBind();
DataGrid3.DataSource = ds2;
DataGrid3.DataBind();
DataGrid4.DataSource = ds3;
DataGrid4.DataBind();
DataGrid5.DataSource = ds4;
DataGrid5.DataBind();
}
}
protected void Grid_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
DataGrid4.CurrentPageIndex = e.NewPageIndex;
if (!this.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.titre WHERE titre.codeuser="******"urole"] + " AND titre.numzone='C22' UNION SELECT * FROM database.detail WHERE detail.codeuser="******"urole"] + " AND detail.numzone='C22' "))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
DataGrid4.DataSource = dt;
DataGrid4.DataBind();
}
}
}
}
}
}
protected void BindGrid4()
{
if (!this.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.activite WHERE activite.iduser='******' AND activite.nature='Jeux'"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
DataGrid4.DataSource = dt;
DataGrid4.DataBind();
}
}
}
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedItem.Text == "Food")
{
MultiView1.SetActiveView(View2);
cmd.CommandText = "select *from food_tb";
DataGrid1.DataSource = db.getdata(cmd);
DataGrid1.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "Hotel")
{
MultiView1.SetActiveView(View3);
cmd.CommandText = "select *from Hotel_tb";
DataGrid2.DataSource = db.getdata(cmd);
DataGrid2.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "Place")
{
MultiView1.SetActiveView(View4);
cmd.CommandText = "select *from Place_tb";
DataGrid3.DataSource = db.getdata(cmd);
DataGrid3.DataBind();
}
else if (DropDownList1.SelectedItem.Text == "Others")
{
MultiView1.SetActiveView(View5);
cmd.CommandText = "select *from Image_tb";
DataGrid4.DataSource = db.getdata(cmd);
DataGrid4.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection connect = new SqlConnection("server=DESKTOP-NOQ9PCB\\MSSQLSERVER01;database=DxcTraining; integrated security=true"))
{
SqlDataAdapter sda = new SqlDataAdapter("select * from student1", connect);
DataSet ds = new DataSet();
sda.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
SqlDataAdapter sda1 = new SqlDataAdapter("select * from Employee2", connect);
DataSet ds1 = new DataSet();
sda1.Fill(ds1);
DataGrid2.DataSource = ds1;
DataGrid2.DataBind();
SqlDataAdapter sda2 = new SqlDataAdapter("select * from IndianCricketTeam", connect);
DataSet ds2 = new DataSet();
sda2.Fill(ds2);
DataGrid3.DataSource = ds2;
DataGrid3.DataBind();
SqlDataAdapter sda3 = new SqlDataAdapter("select * from IndianRailwaySystem1 ", connect);
DataSet ds3 = new DataSet();
sda3.Fill(ds3);
DataGrid4.DataSource = ds3;
DataGrid4.DataBind();
SqlDataAdapter sda4 = new SqlDataAdapter("select * from BankTable", connect);
DataSet ds4 = new DataSet();
sda4.Fill(ds4);
DataGrid5.DataSource = ds4;
DataGrid5.DataBind();
}
}
private void getdata(string sql)
{
DataSet result = new DataSet();
result = new Class1().hsggetdata(sql);
if (result != null)
{
if (result.Tables[0].Rows.Count > 0)
{
DataGrid4.DataSource = result.Tables[0];
DataGrid4.DataBind();
}
else
{
DataGrid4.DataSource = null;
DataGrid4.DataBind();
}
}
}
protected void BindData()
{
if (!this.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.titre WHERE titre.codeuser='******' AND titre.numzone='C22' UNION SELECT * FROM database.detail WHERE detail.codeuser='******' AND detail.numzone='C22' "))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
DataGrid4.DataSource = dt;
DataGrid4.DataBind();
}
}
}
}
}
}
protected void Cargar_Tabla_Rtns(object sender, EventArgs e)
{
if (numdig.Text != "" && Convert.ToInt32(dig.Text) != Convert.ToInt32(numdig.Text))
{
dig.Text = numdig.Text;
dig.Visible = true;
dt = new DataTable();
dt.Columns.Add(new DataColumn("Nombre", typeof(string)));
dt.Columns.Add(new DataColumn("Nit", typeof(string)));
for (int i = 0; i < Convert.ToInt32(numdig.Text); i++)
{
DataRow fila = dt.NewRow();
dt.Rows.Add(fila);
}
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
DataGrid1.Visible = true;
}
if (numpat.Text != "" && Convert.ToInt32(pat.Text) != Convert.ToInt32(numpat.Text))
{
pat.Text = numpat.Text;
pat.Visible = true;
numeropat = Convert.ToInt32(numpat.Text);
dt = new DataTable();
dt.Columns.Add(new DataColumn("Nombre", typeof(string)));
dt.Columns.Add(new DataColumn("Nit", typeof(string)));
for (int i = 0; i < Convert.ToInt32(numpat.Text); i++)
{
DataRow fila = dt.NewRow();
dt.Rows.Add(fila);
}
DataGrid2.DataSource = dt;
DataGrid2.DataBind();
DataGrid2.Visible = true;
}
if (numcont.Text != "" && Convert.ToInt32(cont.Text) != Convert.ToInt32(numcont.Text))
{
cont.Text = numcont.Text;
cont.Visible = true;
numerocont = Convert.ToInt32(numcont.Text);
dt = new DataTable();
dt.Columns.Add(new DataColumn("Nombre", typeof(string)));
dt.Columns.Add(new DataColumn("Nit", typeof(string)));
for (int i = 0; i < Convert.ToInt32(numcont.Text); i++)
{
DataRow fila = dt.NewRow();
dt.Rows.Add(fila);
}
DataGrid3.DataSource = dt;
DataGrid3.DataBind();
DataGrid3.Visible = true;
}
if (numcor.Text != "" && Convert.ToInt32(cor.Text) != Convert.ToInt32(numcor.Text))
{
cor.Text = numcor.Text;
cor.Visible = true;
numerocor = Convert.ToInt32(numcor.Text);
dt = new DataTable();
dt.Columns.Add(new DataColumn("Nombre", typeof(string)));
dt.Columns.Add(new DataColumn("Nit", typeof(string)));
for (int i = 0; i < Convert.ToInt32(numcor.Text); i++)
{
DataRow fila = dt.NewRow();
dt.Rows.Add(fila);
}
DataGrid4.DataSource = dt;
DataGrid4.DataBind();
DataGrid4.Visible = true;
}
}
protected void LoadInitData(string prefInventario, string numInventario)
{
string sql = String.Format(
"SELECT mrol.prinf_codigo AS Rol, \n" +
" MNI.mnit_nit AS Nit, \n" +
" MNI.mnit_nombres concat ' ' concat COALESCE(MNI.mnit_nombre2,' ') concat ' ' concat MNI.mnit_apellidos concat ' ' concat COALESCE(MNI.mnit_apellido2,' ') AS Nombre \n" +
"FROM mrolinventariofisico mrol \n" +
" LEFT JOIN mnit MNI ON mrol.mnit_nit = MNI.mnit_nit \n" +
"WHERE pdoc_codigo = '{0}' \n" +
"AND minf_numeroinf = {1}"
, prefInventario
, numInventario);
DataSet ds = new DataSet();
DataTable dtGerente = new DataTable();
DataTable dtAuditor = new DataTable();
DataTable dtDigitadores = new DataTable();
DataTable dtPatinadores = new DataTable();
DataTable dtCoordinadores = new DataTable();
DataTable dtContadores = new DataTable();
dtGerente.Columns.Add(new DataColumn("Rol", typeof(string)));
dtGerente.Columns.Add(new DataColumn("Nit", typeof(string)));
dtGerente.Columns.Add(new DataColumn("Nombre", typeof(string)));
dtAuditor.Columns.Add(new DataColumn("Rol", typeof(string)));
dtAuditor.Columns.Add(new DataColumn("Nit", typeof(string)));
dtAuditor.Columns.Add(new DataColumn("Nombre", typeof(string)));
dtDigitadores.Columns.Add(new DataColumn("Rol", typeof(string)));
dtDigitadores.Columns.Add(new DataColumn("Nit", typeof(string)));
dtDigitadores.Columns.Add(new DataColumn("Nombre", typeof(string)));
dtPatinadores.Columns.Add(new DataColumn("Rol", typeof(string)));
dtPatinadores.Columns.Add(new DataColumn("Nit", typeof(string)));
dtPatinadores.Columns.Add(new DataColumn("Nombre", typeof(string)));
dtCoordinadores.Columns.Add(new DataColumn("Rol", typeof(string)));
dtCoordinadores.Columns.Add(new DataColumn("Nit", typeof(string)));
dtCoordinadores.Columns.Add(new DataColumn("Nombre", typeof(string)));
dtContadores.Columns.Add(new DataColumn("Rol", typeof(string)));
dtContadores.Columns.Add(new DataColumn("Nit", typeof(string)));
dtContadores.Columns.Add(new DataColumn("Nombre", typeof(string)));
ds = DBFunctions.Request(ds, IncludeSchema.NO, sql);
foreach (DataRow dr in ds.Tables[0].Select("ROL=1"))
{
dtGerente.Rows.Add(dr.ItemArray);
}
foreach (DataRow dr in ds.Tables[0].Select("ROL=2"))
{
dtAuditor.Rows.Add(dr.ItemArray);
}
foreach (DataRow dr in ds.Tables[0].Select("ROL=3"))
{
dtDigitadores.Rows.Add(dr.ItemArray);
}
foreach (DataRow dr in ds.Tables[0].Select("ROL=4"))
{
dtPatinadores.Rows.Add(dr.ItemArray);
}
foreach (DataRow dr in ds.Tables[0].Select("ROL=5"))
{
dtCoordinadores.Rows.Add(dr.ItemArray);
}
foreach (DataRow dr in ds.Tables[0].Select("ROL=6"))
{
dtContadores.Rows.Add(dr.ItemArray);
}
if (dtGerente.Rows.Count > 0)
{
DataRow drGerente = dtGerente.Rows[0];
TextBox1.Text = drGerente["NOMBRE"].ToString();
TextBox1a.Value = drGerente["NIT"].ToString();
}
if (dtAuditor.Rows.Count > 0)
{
DataRow drAuditor = dtAuditor.Rows[0];
TextBox2.Text = drAuditor["NOMBRE"].ToString();
TextBox2a.Value = drAuditor["NIT"].ToString();
}
DataGrid1.DataSource = dtDigitadores;
DataGrid2.DataSource = dtPatinadores;
DataGrid3.DataSource = dtCoordinadores;
DataGrid4.DataSource = dtContadores;
DataGrid1.Visible = dtDigitadores.Rows.Count > 0;
DataGrid2.Visible = dtPatinadores.Rows.Count > 0;
DataGrid3.Visible = dtCoordinadores.Rows.Count > 0;
DataGrid4.Visible = dtContadores.Rows.Count > 0;
DataGrid1.DataBind();
DataGrid2.DataBind();
DataGrid3.DataBind();
DataGrid4.DataBind();
dig.Text = numdig.Text = dtDigitadores.Rows.Count.ToString();
pat.Text = numpat.Text = dtPatinadores.Rows.Count.ToString();
cont.Text = numcont.Text = dtCoordinadores.Rows.Count.ToString();
cor.Text = numcor.Text = dtContadores.Rows.Count.ToString();
}
