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 Button3_Click(object sender, EventArgs e)
{
//try
//{
if (TextBox1.Text.Equals(String.Empty) || DropDownList3.SelectedValue.Equals(0) || DropDownList1.SelectedValue.Equals(0))
{
Response.Write("<script>alert('Favor, de ingresar correlativo de la factura/comprobante')</script>");
}
else
{
string msj = "";
msj = datos.InsertarCompra(Convert.ToDecimal(TextBox12.Text), TextBox1.Text, Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToDateTime(TextBox2.Text), Convert.ToInt32(DropDownList3.SelectedValue));
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox VerSiCheck = (CheckBox)(row.FindControl("CheckBox1"));
if (!VerSiCheck.Checked)
{
datos.InsertarDetalleCompra(
Convert.ToInt32(row.Cells[6].Text),
Convert.ToDecimal(row.Cells[5].Text),
Convert.ToDecimal(row.Cells[7].Text),
Convert.ToInt32(row.Cells[8].Text),
Convert.ToInt32(msj),
Convert.ToDecimal(row.Cells[4].Text),
Convert.ToInt32(DropDownList1.SelectedValue)
);
}
else
{
datos.InsertDevProPro(Convert.ToInt32(row.Cells[8].Text), row.Cells[9].Text, TextBox1.Text, Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(row.Cells[6].Text), Convert.ToDecimal(row.Cells[4].Text), Convert.ToDecimal(row.Cells[5].Text), Convert.ToInt32(msj));
}
}
if (DropDownList3.SelectedItem.ToString().Trim() == "Credito")
{
SqlDataSource9.InsertParameters["ID_Compra"].DefaultValue = msj;
SqlDataSource9.Insert();
}
Response.Redirect("CompraD.aspx");
}
//}
// catch (Exception)
// {
// Response.Write("<script>alert('Error, Compra no registrada')</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 Button7_Click(object sender, EventArgs e)
{
try
{
if (TextBox7.Text != "")
{
SqlDataSource9.InsertParameters["Categoria"].DefaultValue = TextBox7.Text;
SqlDataSource9.Insert();
SqlDataSource9.SelectCommand = "SELECT ID_Categoria, Categoria FROM Categoria WHERE (Estado = 1)";
SqlDataSource9.DataBind();
borrar();
}
else
{
Response.Write("<script>alert('Error, resive los datos')</script>");
}
}
catch
{
Response.Write("<script>alert('Error, resive los datos')</script>");
}
}