public bool incrementarStock(Stockcs stock, Sucursal sucursal, string schema)
{
bool retorno = false;
NpgsqlConnection conexion = null;
NpgsqlCommand cmd = null;
NpgsqlTransaction tran = null;
try
{
conexion = Conexion.getInstance().ConexionDB();
cmd = new NpgsqlCommand("logueo.spincrementarstock", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_sucursal", sucursal.id);
cmd.Parameters.AddWithValue("parm_idarticulo", stock.articulo.id);
cmd.Parameters.AddWithValue("parm_cantidad", stock.cantidad);
cmd.Parameters.AddWithValue("parm_schema", schema);
conexion.Open();
tran = conexion.BeginTransaction();
cmd.ExecuteNonQuery();
retorno = true;
}
catch (Exception e)
{
tran.Rollback();
retorno = false;
}
tran.Commit();
conexion.Close();
return(retorno);
}
public bool decrementarStock(Stockcs stock, Sucursal sucursal, string schema, NpgsqlConnection conexion)
{
bool retorno = false;
bool hayStock = checkStockDisponible(stock, sucursal, schema, conexion);
if (hayStock)
{
// si hay stock disponible lo reservo
NpgsqlCommand cmd = null;
try
{
cmd = new NpgsqlCommand("logueo.spdecrementarstock", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_sucursal", sucursal.id);
cmd.Parameters.AddWithValue("parm_idarticulo", stock.articulo.id);
cmd.Parameters.AddWithValue("parm_cantidad", stock.cantidad);
cmd.Parameters.AddWithValue("parm_schema", schema);
cmd.ExecuteNonQuery();
retorno = true;
}
catch (Exception e)
{
retorno = false;
}
}
else
{
retorno = hayStock;
}
return(retorno);
}
public bool checkStockDisponible(Stockcs stock, Sucursal sucursal, string schema)
{
bool retorno = false;
NpgsqlConnection conexion = null;
NpgsqlCommand cmd = null;
NpgsqlTransaction tran = null;
try
{
conexion = Conexion.getInstance().ConexionDB();
cmd = new NpgsqlCommand("logueo.spcheckstockdisponible", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_idsucursal", sucursal.id);
cmd.Parameters.AddWithValue("parm_idarticulo", stock.articulo.id);
cmd.Parameters.AddWithValue("parm_cantidad", stock.cantidad);
cmd.Parameters.AddWithValue("parm_schema", schema);
conexion.Open();
Object retornoSQL = cmd.ExecuteScalar();
retorno = Convert.ToBoolean(retornoSQL);
}
catch (Exception e)
{
throw (e);
}
tran.Commit();
conexion.Close();
return(retorno);
}
public List <Stockcs> listaStock2(int id_sucursal, string schema)
{
NpgsqlConnection conexion = null;
NpgsqlCommand cmd = null;
List <Stockcs> listaStock = new List <Stockcs>();
NpgsqlTransaction tran = null;
NpgsqlDataReader dr = null;
try
{
conexion = Conexion.getInstance().ConexionDB();
cmd = new NpgsqlCommand("logueo.spgetstock2", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_idsucursal", id_sucursal);
cmd.Parameters.AddWithValue("parm_schema", schema);
conexion.Open();
tran = conexion.BeginTransaction();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Stockcs stock = new Stockcs();
stock.id = Convert.ToInt32(dr["ID"].ToString());
stock.cantidad_neta = Convert.ToInt32(dr["CANTIDAD_NETA"].ToString());
stock.in_out = dr["IN_OUT"].ToString();
stock.cantidad = Convert.ToInt32(dr["CANTIDAD"].ToString());
stock.fecha = Convert.ToDateTime(dr["FECHA"].ToString());
stock.es_activo = Convert.ToBoolean(dr["ESACTIVO"].ToString());
Modelo modelo = new Modelo();
modelo.id = Convert.ToInt32(dr["IDMODELO"].ToString());
modelo.nombre = dr["ARTICULO"].ToString();
Color color = new Color();
color.id = Convert.ToInt32(dr["IDCOLOR"].ToString());
color.nombre = dr["COLOR"].ToString();
Talle talle = new Talle();
talle.id = Convert.ToInt32(dr["IDTALLE"].ToString());
talle.nombre = dr["TALLE"].ToString();
Articulo articulo = new Articulo();
articulo.id = Convert.ToInt32(dr["IDARTICULO"].ToString());
articulo.modelo = modelo;
articulo.color = color;
articulo.talle = talle;
stock.articulo = articulo;
listaStock.Add(stock);
}
dr.Close();
}
catch (Exception)
{
tran.Rollback();
listaStock = null;
}
tran.Commit();
conexion.Close();
return(listaStock);
}
public bool registrarStockPerdido(Stockcs stock, Sucursal sucursal, string descripcion, string schema)
{
try
{
return(StockDAO.getInstance().registrarStockPerdido(stock, sucursal, descripcion, schema));
}
catch (Exception e)
{
throw e;
}
}
public bool incrementarStock(Stockcs stock, Sucursal sucursal, string schema)
{
try
{
return(StockDAO.getInstance().incrementarStock(stock, sucursal, schema));
}
catch (Exception e)
{
throw e;
}
}
public bool nuevoStock(Stockcs stock, string schema, NpgsqlConnection conexion)
{
try
{
return(StockDAO.getInstance().nuevoStock(stock, schema, conexion));
}
catch (Exception e)
{
throw e;
}
}
public bool transferenciaStock(Stockcs stock, Sucursal sucursalSalida, Sucursal sucursalEntrada, string schema)
{
try
{
return(StockDAO.getInstance().transferenciaStock(stock, sucursalSalida, sucursalEntrada, schema));
}
catch (Exception e)
{
throw e;
}
}
public bool cambioStock(Stockcs stockEntrada, Stockcs stockSalida, Sucursal sucursal, string schema)
{
try
{
return(StockDAO.getInstance().cambioStock(stockEntrada, stockSalida, sucursal, schema));
}
catch (Exception e)
{
throw e;
}
}
public string nuevoArticulo(Articulo articulo, Stockcs stock, string schema)
{
try
{
return(ArticuloDAO.getInstance().nuevoArticulo(articulo, stock, schema));
}
catch (Exception e)
{
throw e;
}
}
public string nuevoArticulo(Articulo articulo, Stockcs stock, string schema)
{
string retorno = null;
List <Articulo> listArticulos = listaArticulos(schema);
bool existe = validarObjetoExistente(listArticulos, articulo.modelo.nombre, articulo.color.nombre, articulo.talle.nombre);
if (existe)
{
retorno = "El articulo ya existe";
return(retorno);
}
NpgsqlConnection conexion = null;
NpgsqlCommand cmd = null;
NpgsqlTransaction tran = null;
try
{
conexion = Conexion.getInstance().ConexionDB();
cmd = new NpgsqlCommand("logueo.spnuevoarticulo", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_idmodelo", articulo.modelo.id);
cmd.Parameters.AddWithValue("parm_idtalle", articulo.talle.id);
cmd.Parameters.AddWithValue("parm_idcolor", articulo.color.id);
cmd.Parameters.AddWithValue("parm_preciomay", articulo.precio_may);
cmd.Parameters.AddWithValue("parm_preciomin", articulo.precio_min);
cmd.Parameters.AddWithValue("parm_codbarra", articulo.cod_barra);
cmd.Parameters.AddWithValue("parm_schema", schema);
conexion.Open();
tran = conexion.BeginTransaction();
Object id_articulo = cmd.ExecuteScalar();
articulo.id = Convert.ToInt32(id_articulo);
if (!StockDAO.getInstance().nuevoStock(stock, schema, conexion))
{
tran.Rollback();
return("Error al crear stock");
}
}
catch (Exception e)
{
tran.Rollback();
}
finally
{
}
tran.Commit();
conexion.Close();
retorno = "Nuevo articulo añadido correctamente";
return(retorno);
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
Modelo modelo = new Modelo();
modelo.nombre = ddlModelo.SelectedItem.Text.ToString();
modelo.id = Convert.ToInt32(ddlModelo.SelectedItem.Value.ToString());
Talle talle = new Talle();
talle.id = Convert.ToInt32(ddlTalle.SelectedItem.Value.ToString());
talle.nombre = ddlTalle.SelectedItem.Text.ToString();
Color color = new Color();
color.id = Convert.ToInt32(ddlColor.SelectedItem.Value.ToString());
color.nombre = ddlColor.SelectedItem.Text.ToString();
Articulo articulo = new Articulo();
articulo.precio_may = Convert.ToInt32(txtPreciomay.Text.Trim());
articulo.precio_min = Convert.ToInt32(txtPreciomin.Text.Trim());
articulo.modelo = modelo;
articulo.talle = talle;
articulo.color = color;
articulo.cod_barra = "";
Sucursal sucursal = new Sucursal();
sucursal.id = Convert.ToInt32(Session["userSucursal"].ToString());
Stockcs stock = new Stockcs();
stock.articulo = articulo;
stock.cantidad = Convert.ToInt32(txtStock.Text.Trim());
stock.sucursal = sucursal;
string retorno = ArticuloLN.getInstance().nuevoArticulo(articulo, stock, Session["schema"].ToString());
txtPreciomay.Text = "";
txtPreciomin.Text = "";
Response.Write(@"<script language='javascript'>alert('" + retorno + " .');</script>");
}
public bool nuevoStock(Stockcs stock, string schema, NpgsqlConnection conexion)
{
NpgsqlCommand cmd = null;
try
{
cmd = new NpgsqlCommand("logueo.spnuevostock", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_cantidad", stock.cantidad);
cmd.Parameters.AddWithValue("parm_fecha", stock.fecha);
cmd.Parameters.AddWithValue("parm_idarticulo", stock.articulo.id);
cmd.Parameters.AddWithValue("parm_idsucursal", stock.sucursal.id);
cmd.Parameters.AddWithValue("parm_schema", schema);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool transferenciaStock(Stockcs stock, Sucursal sucursalSalida, Sucursal sucursalEntrada, string schema)
{
bool retorno = false;
NpgsqlConnection conexion = null;
NpgsqlTransaction tran = null;
try
{
conexion = Conexion.getInstance().ConexionDB();
conexion.Open();
tran = conexion.BeginTransaction();
bool decremento = decrementarStock(stock, sucursalSalida, schema, conexion);
if (decremento)
{
bool incremento = incrementarStock(stock, sucursalEntrada, schema, conexion);
if (incremento)
{
retorno = true;
}
else
{
tran.Rollback();
}
}
else
{
tran.Rollback();
}
}
catch (Exception)
{
tran.Rollback();
conexion.Close();
return(retorno);
}
tran.Commit();
conexion.Close();
return(retorno);
}
public bool incrementarStock(Stockcs stock, Sucursal sucursal, string schema, NpgsqlConnection conexion)
{
bool retorno = false;
NpgsqlCommand cmd = null;
try
{
cmd = new NpgsqlCommand("logueo.spincrementarstock", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("parm_sucursal", sucursal.id);
cmd.Parameters.AddWithValue("parm_idarticulo", stock.articulo.id);
cmd.Parameters.AddWithValue("parm_cantidad", stock.cantidad);
cmd.Parameters.AddWithValue("parm_schema", schema);
cmd.ExecuteNonQuery();
retorno = true;
}
catch (Exception e)
{
retorno = false;
}
return(retorno);
}
