public override bool Buscar(int IdBuscado)
{
DbConexion conexion = new DbConexion();
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
bool retornar = true;
try
{
dt = conexion.ObtenerDatos("SELECT * FROM Solicitudes WHERE IdSolicitud=" + IdBuscado);
if (dt.Rows.Count > 0)
{
this.IdSolicitud = (int)dt.Rows[0]["IdSolicitud"];
this.Fecha = dt.Rows[0]["Fecha"].ToString();
this.Razon = dt.Rows[0]["Razon"].ToString();
this.Total = Convert.ToSingle(dt.Rows[0]["Total"]);
dt2 = conexion.ObtenerDatos("SELECT * FROM SolicitudesDetalle WHERE IdSolicitud=" + IdBuscado);
foreach (DataRow item in dt2.Rows)
{
this.InsertarMaterial(IdBuscado, (int)item["IdMaterial"], (int)item["Cantidad"], (float)item["Precio"]);
}
}
return(dt.Rows.Count > 0);
}
catch (Exception)
{
retornar = false;
}
return(retornar);
}
public override bool Buscar(int IdBuscar)
{
DbConexion cone = new DbConexion();
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
bool Retornar = false;
try
{
dt = cone.ObtenerDatos("Select * from Ventas where ventaId = " + IdBuscar);
if (dt.Rows.Count > 0)
{
this.VetaId = (int)dt.Rows[0]["VentaId"];
this.Monto = Convert.ToSingle(dt.Rows[0]["Monto"]);
this.Fecha = dt.Rows[0]["Fecha"].ToString();
dt2 = cone.ObtenerDatos(String.Format("Select * from VentasDetalle where VentaId = {0}", IdBuscar));
foreach (DataRow row in dt2.Rows)
{
AgregarArticulos((int)row["ArticuloId"], (int)row["Cantidad"], Convert.ToSingle(row["Precio"]));
}
}
return(dt.Rows.Count > 0);
}catch (Exception)
{
Retornar = false;
}
return(Retornar);
}
public override bool Buscar(int IdBuscar)
{
DataTable dt = new DataTable();
DataTable dtDetalle = new DataTable();
DbConexion cone = new DbConexion();
try
{
dt = cone.ObtenerDatos(String.Format("Select * from Material where MaterialId=)" + IdBuscar));
this.MaterialId = (int)dt.Rows[0]["MaterialId"];
this.Razon = dt.Rows[0]["Razon"].ToString();
dtDetalle = cone.ObtenerDatos(String.Format("Select * from MaterialDetalle where MaterialId+", IdBuscar));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dtDetalle.Rows)
{
AgregarMateriales(row[0].ToString(), (int)row[0]);
}
}
}catch (Exception ex)
{
throw ex;
}
return(dt.Rows.Count > 0);
}
public void AbrirTest()
{
DbConexion sesultado = new DbConexion("localhost", "root", "toor", "bdvt");
bool esperado = true;
bool resultado = sesultado.Abrir();
Assert.AreEqual(esperado, resultado);
}
public override DataTable Listado(string Campos, string Condicion, string Orden)
{
DbConexion conexion = new DbConexion();
string ordenar = "";
if (!Orden.Equals(""))
{
ordenar = " orden by " + Orden;
}
return(conexion.ObtenerDatos(("SELECT " + Campos + " FROM Solicitudes WHERE " + Condicion + ordenar)));
}
public override DataTable Listar(string Campo, string Condicion, string Orden)
{
throw new NotImplementedException();
DbConexion cone = new DbConexion();
string OrdenFinal = "";
if (!Orden.Equals(""))
{
OrdenFinal = "Orden by" + Orden;
}
return(cone.ObtenerDatos("Select " + Campo + "from MaterialesDetalle where " + Condicion + Orden));
}
public override bool Editar()
{
DbConexion conexion = new DbConexion();
bool retorno = false;
try
{
retorno = conexion.Ejecutar(String.Format("UPDATE Materiales SET Descripcion='{0}', Precio={1} WHERE IdMaterial={2}", this.Descripcion, this.Precio, this.IdMaterial));
}
catch (Exception ex) { throw ex; }
return(retorno);
}
public override DataTable Listar(string Campo, string Condicion, string Orden)
{
DataTable dt = new DataTable();
DbConexion cone = new DbConexion();
string OrdenFinal = "";
if (!Orden.Equals(""))
{
OrdenFinal = "Order by " + Orden;
}
return(cone.ObtenerDatos(String.Format("Select " + Campo + " from Ventas as v inner join VentasDetalle d on v.ventasId = d.VentasId " + Condicion + " " + OrdenFinal)));
}
public DataTable Listar(string Campo, string Condicion, string Orden)
{
DataTable dt = new DataTable();
DbConexion cone = new DbConexion();
string OrdenFinal = "";
if (!Orden.Equals(""))
{
OrdenFinal = "Order by " + Orden;
}
return(dt = cone.ObtenerDatos(String.Format("Select * from Articulos ")));
}
public override bool Eliminar()
{
bool Retornar = false;
DbConexion cone = new DbConexion();
try
{
Retornar = cone.Ejecutar(String.Format("Delete from VentasDetalle where VentaId = {0}; " + "Delete from Ventas where VentaId = {0}", this.VetaId));
}catch (Exception ex)
{
throw ex;
}
return(Retornar);
}
public override bool Insertar()
{
DbConexion conexion = new DbConexion();
int retorno = 0;
try
{
conexion.ObtenerValor(String.Format("INSERT INTO Materiales (Descripcion, Precio) VALUES ('{0}',{1})", this.Descripcion, this.Precio));
}
catch (Exception ex)
{
throw ex;
}
return(retorno > 0);
}
public bool AfectarExistencia()
{
DbConexion cone = new DbConexion();
bool Retornar = false;
try
{
foreach (Articulos ar in this.Lista)
{
Retornar = cone.Ejecutar(String.Format("Update Articulos set Existencia={0} where ArticuloId = {1}", ar.Existencia - ar.Cantidad, ar.ArticuloId));
}
}
catch (Exception)
{
}
return(Retornar);
}
public override bool Eliminar()
{
DbConexion conexion = new DbConexion();
bool retorno = false;
try
{
retorno = conexion.Ejecutar(String.Format("DELETE FROM Materiales WHERE IdMaterial={0}", this.IdMaterial));
//if (retorno)
// conexion.Ejecutar(String.Format("DELETE FROM Materiales WHERE IdMaterial={0}", this.IdMaterial));
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
public override bool Eliminar()
{
DbConexion conexion = new DbConexion();
bool retorno = false;
try
{
retorno = conexion.Ejecutar(String.Format("DELETE FROM SolicitudesDetalle WHERE IdSolicitud={0}", this.IdSolicitud));
if (retorno)
{
conexion.Ejecutar(String.Format("DELETE FROM Solicitudes WHERE IdSolicitud={0}", this.IdSolicitud));
}
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
public void ObtenerDatosArticulo(int Articulo)
{
DbConexion cone = new DbConexion();
DataTable dt = new DataTable();
try
{
dt = cone.ObtenerDatos(String.Format("Select * from Articulos where ArticuloId ={0}", Articulo));
if (dt.Rows.Count > 0)
{
this.ArticuloId = (int)dt.Rows[0]["ArticuloId"];
this.Precio = Convert.ToSingle(dt.Rows[0]["Precio"]);
this.Existencia = (int)dt.Rows[0]["Existencia"];
}
}catch (Exception ex)
{
throw ex;
}
}
public override bool Editar()
{
DbConexion conexion = new DbConexion();
bool retorno = false;
try
{
retorno = conexion.Ejecutar(string.Format("UPDATE Solicitudes SET Fecha='{0}', Total={1} ,Razon ='{2}' WHERE IdSolicitud={3}", this.Fecha, this.Total, this.Razon, this.IdSolicitud));
if (retorno)
{
conexion.Ejecutar(String.Format("DELETE FROM SolicitudesDetalle WHERE IdSolicitud={0}", this.IdSolicitud));
foreach (SolicitudesDetalle item in this.Detalle)
{
conexion.Ejecutar(string.Format("Insert Into SolicitudesDetalle (IdSolicitud,Cantidad,Precio) VALUES ({0},{1},{2})", IdSolicitud, item.Cantidad, item.Precio));
}
}
}
catch (Exception ex) { throw ex; }
return(retorno);
}
public override bool Eliminar()
{
int retornar = 0;
DbConexion cone = new DbConexion();
try
{
retornar = Convert.ToInt16(cone.Ejecutar(String.Format("delete from Material where MaterialId =" + this.MaterialId)));
if (retornar > 0)
{
cone.Ejecutar(String.Format("delete from MaterialDetalle where MaterialId =" + this.MaterialId));
}
}catch (Exception ex)
{
throw ex;
}
return(retornar > 0);
}
public override bool Buscar(int IdBuscado)
{
DbConexion conexion = new DbConexion();
DataTable dt = new DataTable();
bool retornar = true;
try
{
dt = conexion.ObtenerDatos("SELECT * FROM Materiales WHERE IdMaterial=" + IdBuscado);
if (dt.Rows.Count > 0)
{
this.IdMaterial = (int)dt.Rows[0]["IdMaterial"];
this.Descripcion = dt.Rows[0]["Descripcion"].ToString();
this.Precio = Convert.ToSingle(dt.Rows[0]["Precio"]);
}
}catch (Exception)
{
retornar = false;
}
return(retornar);
}
public override bool Insertar()
{
DbConexion cone = new DbConexion();
int Retornar = 0;
DataTable dt = new DataTable();
try
{
Retornar = Convert.ToInt32(cone.Ejecutar(String.Format("Insert Into Material(Razon) Values('{0}') Select @@IDENTITY", this.Razon)));
if (Retornar > 0)
{
foreach (MaterialesDetalle item in Detalle)
{
cone.Ejecutar(String.Format("Insert Into MaterialDetalle(Material,Cantidad,MaterialId) Values('{0}','{1}',{2})", item.Material, item.Cantidad, Retornar));
}
}
}catch (Exception ex)
{
throw ex;
}
return(Retornar > 0);
}
public string PrecioDetalle(string material)
{
string retorno = "";
DbConexion conexion = new DbConexion();
DataTable dt = new DataTable();
bool retornar = true;
try
{
dt = conexion.ObtenerDatos("SELECT * FROM Materiales WHERE Descripcion =" + material);
if (dt.Rows.Count > 0)
{
this.IdMaterial = (int)dt.Rows[0]["IdMaterial"];
this.Descripcion = dt.Rows[0]["Descripcion"].ToString();
this.Precio = Convert.ToSingle(dt.Rows[0]["Precio"]);
}
}
catch (Exception)
{
retornar = false;
}
return(retorno);
}
public override bool Insertar()
{
DbConexion cone = new DbConexion();
int retorno = 0;
object Identity;
try
{
Identity = cone.ObtenerValor(string.Format("INSERT INTO Solicitudes (Fecha, Razon,Total) VALUES ('{0}','{1}',{2}) SELECT @@Identity", this.Fecha, this.Razon, this.Total));
int.TryParse(Identity.ToString(), out retorno);
if (retorno > 0)
{
foreach (SolicitudesDetalle item in this.Detalle)
{
cone.Ejecutar(string.Format("Insert Into SolicitudesDetalle(IdSolicitud,Cantidad,Precio) VALUES ({0},{1},{2})", retorno, retorno, item.Cantidad, item.Precio));
}
}
return(retorno > 0);
}
catch (Exception ex)
{
throw ex;
}
}
public override bool Actualizar()
{
bool Retornar = false;
DbConexion cone = new DbConexion();
try
{
Retornar = cone.Ejecutar(String.Format("Update Ventas set Fecha='{0}',Monto={1} where VentaId={2}", this.Fecha, this.Monto, this.VetaId));
if (Retornar)
{
cone.Ejecutar("Delete from VentasDetalle where VentaId =" + this.VetaId);
foreach (VentasDetalle item in this.Detalle)
{
cone.Ejecutar(String.Format("Insert into VentasDetalle(VentaId,ArticuloId,Cantidad,Precio) Values({0},{1},{2},{3})", this.VetaId, item.ArticuloId, item.Cantidad, item.Precio));
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Retornar);
}
public override bool Insertar()
{
int Retornar = 0;
object Identity = null;
DbConexion cone = new DbConexion();
try
{
Identity = cone.ObtenerValor(String.Format("Insert into Ventas(Fecha,Monto) Values('{0}',{1}) SELECT @@Identity", this.Fecha, this.Monto));
int.TryParse(Identity.ToString(), out Retornar);
if (Retornar > 0)
{
foreach (VentasDetalle item in this.Detalle)
{
cone.Ejecutar(String.Format("Insert into VentasDetalle(VentaId,ArticuloId,Cantidad,Precio) Values({0},{1},{2},{3})", Retornar, item.ArticuloId, item.Cantidad, item.Precio));
}
}
}catch (Exception ex)
{
throw ex;
}
return(Retornar > 0);
}
