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();
}