protected void Button3_Click(object sender, EventArgs e) { try { if (Convert.ToInt32(TextBox2.Text) <= cant) { string idTienda = Session["IDtienda"].ToString(); datos.exportarStock(Convert.ToInt32(TextBox2.Text), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(codigop), Convert.ToInt32(separar[0]), Convert.ToInt32(idStock)); SqlDataSource9.InsertParameters["ID_Existencia"].DefaultValue = idStock.ToString(); SqlDataSource9.InsertParameters["ID_Empleado"].DefaultValue = Session["IdEmpleado"].ToString(); SqlDataSource9.InsertParameters["tiendaAtienda"].DefaultValue = Session["Tienda"] + "a " + DropDownList1.SelectedItem; SqlDataSource9.InsertParameters["fecha"].DefaultValue = DateTime.Today.ToString("dd/MM/yyyy"); SqlDataSource9.Insert(); Label5.Text = "Transaccion realizada con exitos."; } else { Response.Write("<script>alert('La cantidad ingresada supera la cantidad que existe en el stock!')</script>"); Button1_ModalPopupExtender.Show(); } } catch { Response.Write("<script>alert('Error, ingrese un valor!')</script>"); } }
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { if (e.NewSelectedIndex != -1) { int Venueid = Convert.ToInt32(GridView1.DataKeys[e.NewSelectedIndex].Value); SqlDataSource2.SelectParameters["VenueID"].DefaultValue = Venueid.ToString(); VenDetail.DataBind(); Button1_ModalPopupExtender.Show(); } }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = GridView2.SelectedRow; idMarcapro = row.Cells[5].Text; separar = idMarcapro.Split(','); SqlDataSource9.SelectParameters["IDprod"].DefaultValue = row.Cells[0].Text; SqlDataSource9.SelectParameters["ID_Tienda"].DefaultValue = DropDownList1.SelectedValue; SqlDataSource9.SelectParameters["idMarcaP"].DefaultValue = separar[0].ToString(); SqlDataSource9.DataSourceMode = SqlDataSourceMode.DataReader; SqlDataReader total; total = (SqlDataReader)SqlDataSource9.Select(DataSourceSelectArguments.Empty); if (total.Read()) { siExiste = Convert.ToInt32(total["total"]); } // siExiste = datos.SiExisteStock(Convert.ToInt32(DropDownList1.SelectedValue),Convert.ToInt32(row.Cells[0].Text), Convert.ToInt32(separar[0])); if (siExiste == 1) { codigop = row.Cells[0].Text; cant = Convert.ToInt32(row.Cells[8].Text); idStock = row.Cells[12].Text; Label1.Text = row.Cells[8].Text + " de productos en la tienda: " + Session["Tienda"].ToString(); Label2.Text = DropDownList1.SelectedItem.ToString(); Button1_ModalPopupExtender.Show(); } if (siExiste == 0) { codigop = row.Cells[0].Text; precioCompra = Convert.ToDecimal(row.Cells[6].Text); precioVentass = Convert.ToDecimal(row.Cells[7].Text); cant = Convert.ToInt32(row.Cells[8].Text); idStock = row.Cells[12].Text; Label3.Text = row.Cells[8].Text + " de productos en la tienda: " + Session["Tienda"].ToString(); Label4.Text = DropDownList1.SelectedItem.ToString(); DropDownList6.SelectedIndex = DropDownList6.Items.IndexOf(DropDownList6.Items.FindByText(row.Cells[9].Text)); Button10_ModalPopupExtender.Show(); } else if (siExiste > 1) { Response.Write("<script>alert('Existe mas de 1 del mismo producto, año y misma tienda. Borre uno,')</script>"); } }
protected void Button2_Click(object sender, EventArgs e) { if (Convert.ToInt32(TextBox3.Text) <= cant) { datos.InsertarStock(0, Convert.ToInt32(StockMi), ubicacionStock, precioCompra, precioVentass, Convert.ToInt32(codigop), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(separar[0]), 1, Convert.ToInt32(DropDownList6.SelectedValue)); datos.exportarStock(Convert.ToInt32(TextBox3.Text), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(codigop), Convert.ToInt32(separar[0]), Convert.ToInt32(idStock)); SqlDataSource9.InsertParameters["ID_Existencia"].DefaultValue = idStock.ToString(); SqlDataSource9.InsertParameters["ID_Empleado"].DefaultValue = Session["IdEmpleado"].ToString(); SqlDataSource9.InsertParameters["tiendaAtienda"].DefaultValue = Session["Tienda"].ToString().Trim() + "a " + DropDownList1.SelectedItem.ToString().Trim(); SqlDataSource9.InsertParameters["fecha"].DefaultValue = DateTime.Today.ToString("dd/MM/yyyy"); SqlDataSource9.Insert(); Response.Redirect("Exportacion.aspx"); } else { Response.Write("<script>alert('La cantidad ingresada supera la cantidad que existe en el stock!')</script>"); Button1_ModalPopupExtender.Show(); } }
protected void LinkButton1_Click(object sender, EventArgs e) { LinkButton lb = sender as LinkButton; string id = lb.Text; lblValue.Text = id; string constr = "Data Source=.\\sqlexpress;Initial Catalog=scott;Integrated Security=True"; string sql = "SELECT dname, loc FROM dept WHERE deptno = @id"; SqlConnection connection = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@id", id); cmd.CommandType = CommandType.Text; connection.Open(); SqlDataReader dr = cmd.ExecuteReader(); GridView2.DataSource = dr; GridView2.DataBind(); connection.Close(); Button1_ModalPopupExtender.Show(); }
protected void btnRegistro_Click(object sender, EventArgs e) { try { util = new csUtilidades(); LogicaUsuario lgusuario = new LogicaUsuario(); //if (lgusuario.validarCorreo(txtCorreo.Text)) //{ String pass = util.CrearPassword(6); String pass2 = util.Encriptar(pass); csUsuario user = new csUsuario(0, txtNom1.Text, txtNom2.Text, txtApe1.Text, txtApe2.Text, txtCorreo.Text, "user.png", txtDir.Text, "1997/01/15", txtTelefono.Text, int.Parse(txtNumDoc.Text), int.Parse(dlTipoDoc.SelectedValue.ToString()), int.Parse(dlCiudad.SelectedValue.ToString()), pass2); Boolean resultado = lgusuario.CrearUsuario(user, dlTipoUsuario.SelectedValue.ToString()); if (resultado) { EnviarCorreo(pass, txtCorreo.Text); limpiarRegistro(); Button1_ModalPopupExtender.Show(); } else { ltMensaje.Text = @"<div class='alert alert-danger'> <strong>No se registro el usuario</strong> Su contraseña sera enviada a su correo electronio. </div>"; } //} //else //{ // HyperLink3_ModalPopupExtender.Show(); // lbRepuesta.Text = "Correo ya existe"; //} } catch (Exception ex) { ex.ToString(); } }
protected void VenDetail_ItemDeleted(object sender, DetailsViewDeletedEventArgs e) { GridView1.DataBind(); GridView1.SelectRow(-1); Button1_ModalPopupExtender.Hide(); }