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