protected void admin_Click(object sender, EventArgs e) { if (MUsername.Text != "") { DataView obstaja = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //ListBox1.Items.Add(obstaja[0][0].ToString()+" "+ obstaja[0][1].ToString()+" "+ obstaja[0][2].ToString()+" "+ obstaja[0][3].ToString()); if (!((obstaja[0][0].ToString()).Equals(null))) { SqlDataSource5.UpdateParameters["username"].DefaultValue = MUsername.Text; SqlDataSource5.UpdateParameters["admin"].DefaultValue = "1"; SqlDataSource5.Update(); Label1.Text = "Uporabnik " + MUsername.Text + " ima administratorske pravice."; } else { Label1.Text = "Uporabnik ne obstaja."; } } else { Label1.Text = "Prosim dopolnite polje."; } }
protected void save_button_Click(object sender, EventArgs e) { //save edited info //collect input in textbox //pass as parameters for update stored procedure SqlDataSource5.Update(); //Response.Redirect("~/User_Home.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { if (tipoGrid == 1) { int msj = 0; SqlDataSource1.UpdateParameters["ID_Venta"].DefaultValue = DropDownList1.SelectedValue; msj = SqlDataSource1.Update(); if (msj > 0) { Response.Write("<script>alert('Entrega exitosa!')</script>"); Response.Redirect("EntregaPB.aspx"); } else { Response.Write("<script>alert('Error, no se realizo cambio en la Base de datos!')</script>"); } // SqlDataSource2.SelectCommand = "SELECT DISTINCT Venta.ID_Venta, 'ID Venta' + ': '+ CAST(Venta.ID_Venta AS nvarchar) +' - '+ Cliente.Nombre + ' ' + Cliente.Apellidos AS Cliente FROM Venta INNER JOIN Estados ON Venta.ID_Venta = Estados.ID_Venta inner join Cliente on Venta.ID_Cliente = Cliente.ID_Cliente WHERE (Estados.ID_Tienda = "+ Session["IdTienda"].ToString()+") AND Estados.EstadoBodega = 1"; // SqlDataSource2.DataBind(); SqlDataSource3.SelectParameters["IdTienda"].DefaultValue = Session["IdTienda"].ToString(); SqlDataSource3.DataSourceMode = SqlDataSourceMode.DataReader; SqlDataReader totalP; totalP = (SqlDataReader)SqlDataSource3.Select(DataSourceSelectArguments.Empty); if (totalP.Read()) { Label1.Text = totalP["total"].ToString(); } } else if (tipoGrid == 2) { int msj = 0; SqlDataSource5.UpdateParameters["ID_Cotizacion"].DefaultValue = DropDownList2.SelectedValue; msj = SqlDataSource5.Update(); if (msj > 0) { Response.Write("<script>alert('Entrega exitosa!')</script>"); Response.Redirect("EntregaPB.aspx"); } else { Response.Write("<script>alert('Error, no se realizo cambio en la Base de datos!')</script>"); } SqlDataSource3.SelectParameters["IdTienda"].DefaultValue = Session["IdTienda"].ToString(); SqlDataSource3.DataSourceMode = SqlDataSourceMode.DataReader; SqlDataReader totalP; totalP = (SqlDataReader)SqlDataSource3.Select(DataSourceSelectArguments.Empty); if (totalP.Read()) { Label1.Text = totalP["total"].ToString(); } } }
protected void btnCadastrar_Click(object sender, EventArgs e) { Usuarios User = new Usuarios(); User = (Usuarios)Session["usuario"]; SqlDataSource1.SelectParameters["IDCond"].DefaultValue = Convert.ToString(User.Cond); SqlDataSource4.UpdateParameters["Nome"].DefaultValue = ddlNome.SelectedItem.Value; SqlDataSource4.UpdateParameters["Bloco"].DefaultValue = ddlBloco.SelectedItem.Value; SqlDataSource4.UpdateParameters["Apart"].DefaultValue = ddlApartamento.SelectedItem.Value; SqlDataSource5.UpdateParameters["Nome"].DefaultValue = ddlNome0.SelectedItem.Value; SqlDataSource5.UpdateParameters["Bloco"].DefaultValue = ddlBloco0.SelectedItem.Value; SqlDataSource5.UpdateParameters["Apart"].DefaultValue = ddlApartamento0.SelectedItem.Value; SqlDataSource4.Update(); SqlDataSource5.Update(); SqlDataSource6.Update(); }