public List <Cliente> getCliente(string toSearch) { try { DDBBGateway data = new DDBBGateway(); List <Cliente> aux = new List <Cliente>(); data.prepareQuery("select Id, DNI, Nombre, Apellido, Email, Direccion, Ciudad, CodigoPostal, FechaRegistro from Clientes where DNI = " + toSearch); data.sendQuery(); while (data.getReader().Read()) { aux.Add(new Cliente( (Int64)data.getReader()["Id"], (int)data.getReader()["DNI"], data.getReader()["Nombre"].ToString(), data.getReader()["Apellido"].ToString(), data.getReader()["Email"].ToString(), data.getReader()["Direccion"].ToString(), data.getReader()["Ciudad"].ToString(), data.getReader()["CodigoPostal"].ToString(), (DateTime)data.getReader()["FechaRegistro"] )); } data.closeConnection(); return(aux); } catch (Exception ex) { throw ex; } }
public bool altaCategoria(Categoria reg) { DDBBGateway ddbbData = new DDBBGateway(); try { ddbbData.prepareStatement("insert into CATEGORIAS values ('" + reg.descripcion + "');"); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() >= 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public bool bajaCategoría(Categoria reg) { DDBBGateway ddbbData = new DDBBGateway(); try { ddbbData.prepareStatement("delete from CATEGORIAS where Id = '" + reg.codigo + "' and Descripcion = '" + reg.descripcion + "';"); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public bool modificarCategoria(Categoria reg, string newDesc) { DDBBGateway ddbbData = new DDBBGateway(); try { Validator.validate(reg, newDesc); ddbbData.prepareStatement("update CATEGORIAS set Descripcion = '" + newDesc + "' where Id = '" + reg.codigo + "' and Descripcion = '" + reg.descripcion + "';"); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public List <Categoria> BuscarCategorias(string ToSearch) { DDBBGateway ddbbData = new DDBBGateway(); Categoria aux; List <Categoria> Resultados = new List <Categoria>(); ToSearch = ToSearch.ToLower(); try { ddbbData.prepareQuery("select Id, Descripcion from CATEGORIAS where Descripcion like lower('%" + ToSearch + "%');"); ddbbData.sendQuery(); while (ddbbData.getReader().Read()) { aux = new Categoria((Int32)ddbbData.getReader()["Id"], ddbbData.getReader()["Descripcion"].ToString()); Resultados.Add(aux); } return(Resultados); } catch (Exception) { throw; } finally { ddbbData.closeConnection(); } }
public List <Categoria> listarCategorias() { DDBBGateway ddbbData = new DDBBGateway(); Categoria aux; List <Categoria> resultados = new List <Categoria>(); try { ddbbData.prepareQuery("select id, Descripcion from CATEGORIAS;"); ddbbData.sendQuery(); while (ddbbData.getReader().Read()) { aux = new Categoria((Int32)ddbbData.getReader()["id"], ddbbData.getReader()["Descripcion"].ToString()); resultados.Add(aux); } return(resultados); } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public bool bajaArticulo(Articulo reg) { DDBBGateway ddbbData = new DDBBGateway(); try { ddbbData.prepareStatement("delete from ARTICULOS where Id = '" + reg.id + "' and Codigo = '" + reg.codigo + "' and Nombre = '" + reg.nombre + "';"); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public bool altaArticulo(Articulo reg) { DDBBGateway ddbbData = new DDBBGateway(); try { ddbbData.prepareStatement("insert into ARTICULOS VALUES ( @cod, @nom, @desc, @idMar, @idCat, @ima, @pre);"); ddbbData.addParameter("@cod", reg.codigo); ddbbData.addParameter("@nom", reg.nombre); ddbbData.addParameter("@desc", reg.descripcion); ddbbData.addParameter("@idMar", reg.marca.codigo); ddbbData.addParameter("@idCat", reg.categoria.codigo); ddbbData.addParameter("@ima", reg.imagen); ddbbData.addParameter("@pre", reg.precio); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public bool modificarArticulo(Articulo reg) { DDBBGateway ddbbData = new DDBBGateway(); try { ddbbData.prepareStatement("update ARTICULOS set " + "Codigo = @Cod, " + "Nombre = @Nom, " + "Descripcion = @Desc, " + "IdMarca = @IdMar, " + "IdCategoria = @IdCat, " + "Imagen = @Img, " + "Precio = @Pre " + "where Id = @IdArt;"); ddbbData.addParameter("@Cod", reg.codigo); ddbbData.addParameter("@Nom", reg.nombre); ddbbData.addParameter("@Desc", reg.descripcion); ddbbData.addParameter("@IdMar", reg.marca.codigo.ToString()); ddbbData.addParameter("@IdCat", reg.categoria.codigo.ToString()); ddbbData.addParameter("@Img", reg.imagen); ddbbData.addParameter("@Pre", reg.precio.ToString()); ddbbData.addParameter("@IdArt", reg.id.ToString()); ddbbData.sendStatement(); if (ddbbData.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } finally { ddbbData.closeConnection(); } }
public List <Articulo> BuscarArticulos(string ToSearch) { DDBBGateway ddbbData = new DDBBGateway(); List <Articulo> aux = new List <Articulo>(); try { ddbbData.prepareQuery("select A.Id, A.Codigo, A.Nombre, A.Descripcion, " + "M.Id as 'IdMarca', M.Descripcion as 'Marca', " + "C.Id as 'IdDescripcion', C.Descripcion as 'Categoria', " + "A.Imagen, A.Precio from ARTICULOS as A inner join MARCAS" + " as M on (A.IdMarca = M.Id) inner join CATEGORIAS as C on " + "( A.IdCategoria = C.Id )" + "where A.Descripcion like lower('%" + ToSearch + "%') or Nombre like lower('%" + ToSearch + "%'); "); ddbbData.sendQuery(); while (ddbbData.getReader().Read()) { aux.Add(new Articulo( (Int32)ddbbData.getReader()["Id"], ddbbData.getReader()["Codigo"].ToString(), ddbbData.getReader()["Nombre"].ToString(), ddbbData.getReader()["Descripcion"].ToString(), (Int32)ddbbData.getReader()["IdMarca"], ddbbData.getReader()["Marca"].ToString(), (Int32)ddbbData.getReader()["IdDescripcion"], ddbbData.getReader()["Categoria"].ToString(), ddbbData.getReader()["Imagen"].ToString(), (Decimal)ddbbData.getReader()["Precio"] )); } return(aux); } catch (Exception) { throw; } finally { ddbbData.closeConnection(); } }
public bool modificarCliente(Cliente aux) { try { DDBBGateway data = new DDBBGateway(); data.prepareStatement("update Clientes set Nombre = '" + aux.Nombre + "', Apellido = '" + aux.Apellido + "', Email = '" + aux.Email + "', Direccion = '" + aux.Direccion + "', Ciudad = '" + aux.Ciudad + "', CodigoPostal = '" + aux.CodigoPostal + "' where DNI = '" + aux.DNI + "'"); data.sendStatement(); data.closeConnection(); if (data.getAffectedRows() >= 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
public bool altaCliente(Cliente aux) { try { DDBBGateway data = new DDBBGateway(); data.prepareStatement("" + "INSERT INTO Clientes VALUES ('" + aux.DNI + "', '" + aux.Nombre + "', '" + aux.Apellido + "', '" + aux.Email + "', '" + aux.Direccion + "', '" + aux.Ciudad + "', '" + aux.CodigoPostal + "', '" + DateTime.Now + "')"); data.sendStatement(); data.closeConnection(); if (data.getAffectedRows() <= 0) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } }