//BdEntities bd = new BdEntities(); public BindingList<ClientDto> ListarClientes() { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.clients select new ClientDto { id_Client = n.id_Client, Nom = n.Nom, Cognom1 = n.Cognom1, Adreça = n.Adreça, CodiPostal = n.CodiPostal, Poblacio = n.Poblacio, Provincia = n.Provincia, Telefon = n.Telefon, Fax = n.Fax, E_mail = n.E_mail }).ToList(); BindingList<ClientDto> Result = new BindingList<ClientDto>(Query); return Result; } } catch (Exception) { throw; } }
public BindingList<FacturaDto> ListarFacturas() { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.factura select new FacturaDto { n_Factura = n.n_Factura, id_Client = n.id_Client, Data = n.Data, Descompte = n.Descompte, IVA = n.IVA }).ToList(); BindingList<FacturaDto> Result = new BindingList<FacturaDto>(Query); return Result; } } catch (Exception) { throw; } }
public void ActualizarFacturas(ref OperationResult pobjOperationResult, List<FacturaDto> Temp_Insertar, List<FacturaDto> Temp_Modificar, List<FacturaDto> Temp_Eliminar) { try { using (BdEntities dbContext = new BdEntities()) { #region Insertar foreach (FacturaDto _Factura in Temp_Insertar) { factura Entidad = new factura(); Entidad.Data = _Factura.Data; Entidad.n_Factura = _Factura.n_Factura; Entidad.id_Client = _Factura.id_Client; Entidad.IVA = _Factura.IVA; Entidad.Descompte = _Factura.Descompte; dbContext.factura.Add(Entidad); } #endregion #region Modificar foreach (FacturaDto _Factura in Temp_Modificar) { factura Entidad = (from n in dbContext.factura where n.id_Client == _Factura.id_Client select n).FirstOrDefault(); Entidad.Data = _Factura.Data; Entidad.n_Factura = _Factura.n_Factura; Entidad.id_Client = _Factura.id_Client; Entidad.IVA = _Factura.IVA; Entidad.Descompte = _Factura.Descompte; dbContext.Entry(Entidad).CurrentValues.SetValues(Entidad); } #endregion #region Eliminar foreach (FacturaDto _Factura in Temp_Eliminar) { factura Entidad = (from n in dbContext.factura where n.id_Client == _Factura.id_Client select n).FirstOrDefault(); dbContext.factura.Remove(Entidad); } #endregion dbContext.SaveChanges(); pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; pobjOperationResult.AdditionalInformation = "FacturaBL.ActualizarFacturas()"; return; } }
public void ActualizarFactures_detall(ref OperationResult pobjOperationResult, List<Factures_detallDto> Temp_Insertar, List<Factures_detallDto> Temp_Modificar, List<Factures_detallDto> Temp_Eliminar) { try { using (BdEntities dbContext = new BdEntities()) { #region Insertar foreach (Factures_detallDto _Factures_detall in Temp_Insertar) { factures_detall Entidad = new factures_detall(); Entidad.id_Producte = _Factures_detall.id_Producte; Entidad.n_Factura = _Factures_detall.n_Factura; Entidad.Quantitat = _Factures_detall.Quantitat; dbContext.factures_detall.Add(Entidad); } #endregion #region Modificar foreach (Factures_detallDto _Factures_detall in Temp_Modificar) { factures_detall Entidad = (from n in dbContext.factures_detall where n.id_Producte == _Factures_detall.id_Producte select n).FirstOrDefault(); Entidad.id_Producte = _Factures_detall.id_Producte; Entidad.n_Factura = _Factures_detall.n_Factura; Entidad.Quantitat = _Factures_detall.Quantitat; dbContext.Entry(Entidad).CurrentValues.SetValues(Entidad); } #endregion #region Eliminar foreach (Factures_detallDto _Factures_detall in Temp_Eliminar) { factures_detall Entidad = (from n in dbContext.factures_detall where n.id_Producte == _Factures_detall.id_Producte select n).FirstOrDefault(); dbContext.factures_detall.Remove(Entidad); } #endregion dbContext.SaveChanges(); pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; pobjOperationResult.AdditionalInformation = "Factures_detallBL.ActualizarFactures_detall()"; return; } }
public void ActualizarProductes(ref OperationResult pobjOperationResult, List<ProductesDto> Temp_Insertar, List<ProductesDto> Temp_Modificar, List<ProductesDto> Temp_Eliminar) { try { using (BdEntities dbContext = new BdEntities()) { #region Insertar foreach (ProductesDto _Productes in Temp_Insertar) { productes Entidad = new productes(); Entidad.idProducte = _Productes.idProducte; Entidad.Preu = _Productes.Preu; Entidad.Producte = _Productes.Producte; dbContext.productes.Add(Entidad); } #endregion #region Modificar foreach (ProductesDto _Productes in Temp_Modificar) { productes Entidad = (from n in dbContext.productes where n.idProducte == _Productes.idProducte select n).FirstOrDefault(); Entidad.idProducte = _Productes.idProducte; Entidad.Preu = _Productes.Preu; Entidad.Producte = _Productes.Producte; dbContext.Entry(Entidad).CurrentValues.SetValues(Entidad); } #endregion #region Eliminar foreach (ProductesDto _Productes in Temp_Eliminar) { productes Entidad = (from n in dbContext.productes where n.idProducte == _Productes.idProducte select n).FirstOrDefault(); dbContext.productes.Remove(Entidad); } #endregion dbContext.SaveChanges(); pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; pobjOperationResult.AdditionalInformation = "ProductesBL.ActualizarProductes()"; return; } }
public BindingList<Factures_detallDto> ListarFacturas_detall() { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.factures_detall select new Factures_detallDto { n_Factura = n.n_Factura, id_Producte = n.id_Producte, Quantitat = n.Quantitat }).ToList(); BindingList<Factures_detallDto> Result = new BindingList<Factures_detallDto>(Query); return Result; } } catch (Exception) { throw; } }
public BindingList<ProductesDto> ListarProductes() { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.productes select new ProductesDto { idProducte = n.idProducte, Producte = n.Producte, Preu = n.Preu }).ToList(); BindingList<ProductesDto> Result = new BindingList<ProductesDto>(Query); return Result; } } catch (Exception) { throw; } }
public void MeterXML(ref OperationResult pobjOperationResult) { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.factures_detall select new Factures_detallDto { n_Factura = n.n_Factura, id_Producte = n.id_Producte, Quantitat = n.Quantitat }).ToList(); if (Query.Count > 0) { var xEle = new XElement("Factures_detall", from emp in Query select new XElement("Factura_detall", new XElement("n_Factura", emp.n_Factura), new XElement("id_Producte", emp.id_Producte), new XElement("Quantitat", emp.Quantitat) )); xEle.Save("Factures_detall.xml"); } pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; return; } }
public void MeterXML(ref OperationResult pobjOperationResult) { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.factura select new FacturaDto { n_Factura = n.n_Factura, id_Client = n.id_Client, Data = n.Data, Descompte = n.Descompte, IVA = n.IVA }).ToList(); if (Query.Count > 0) { var xEle = new XElement("Factures", from emp in Query select new XElement("Factura", new XElement("n_Factura", emp.n_Factura), new XElement("Id_Client", emp.id_Client), new XElement("Data", emp.Data), new XElement("Descompte", emp.Descompte), new XElement("Iva", emp.IVA) )); xEle.Save("Factures.xml"); } pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; return; } }
public void MeterXML(ref OperationResult pobjOperationResult) { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.productes select new ProductesDto { idProducte = n.idProducte, Producte = n.Producte, Preu = n.Preu }).ToList(); if (Query.Count > 0) { var xEle = new XElement("Productes", from emp in Query select new XElement("Producte", new XElement("idProducte", emp.idProducte), new XElement("Producte", emp.Producte), new XElement("Preu", emp.Preu) )); xEle.Save("Productes.xml"); } pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; return; } }
public void ActualizarClientes(ref OperationResult pobjOperationResult, List<ClientDto> Temp_Insertar, List<ClientDto> Temp_Modificar, List<ClientDto> Temp_Eliminar) { try { using (BdEntities dbContext = new BdEntities()) { #region Insertar foreach (ClientDto _Clients in Temp_Insertar) { clients Entidad = new clients(); Entidad.Nom = _Clients.Nom; Entidad.Cognom1 = _Clients.Cognom1; Entidad.id_Client = _Clients.id_Client; Entidad.Adreça = _Clients.Adreça; Entidad.CodiPostal = _Clients.CodiPostal; Entidad.Poblacio = _Clients.Poblacio; Entidad.Provincia = _Clients.Provincia; Entidad.Telefon = _Clients.Telefon; Entidad.Fax = _Clients.Fax; Entidad.E_mail = _Clients.E_mail; dbContext.clients.Add(Entidad); } #endregion #region Modificar foreach (ClientDto _Clients in Temp_Modificar) { clients Entidad = (from n in dbContext.clients where n.id_Client == _Clients.id_Client select n).FirstOrDefault(); Entidad.Nom = _Clients.Nom; Entidad.Cognom1 = _Clients.Cognom1; Entidad.id_Client = _Clients.id_Client; Entidad.Adreça = _Clients.Adreça; Entidad.CodiPostal = _Clients.CodiPostal; Entidad.Poblacio = _Clients.Poblacio; Entidad.Provincia = _Clients.Provincia; Entidad.Telefon = _Clients.Telefon; Entidad.Fax = _Clients.Fax; Entidad.E_mail = _Clients.E_mail; dbContext.Entry(Entidad).CurrentValues.SetValues(Entidad); } #endregion #region Eliminar foreach (ClientDto _Clients in Temp_Eliminar) { clients Entidad = (from n in dbContext.clients where n.id_Client == _Clients.id_Client select n).FirstOrDefault(); dbContext.clients.Remove(Entidad); } #endregion dbContext.SaveChanges(); pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; pobjOperationResult.AdditionalInformation = "ClientBL.ActualizarClientes()"; return; } }
public void MeterXML(ref OperationResult pobjOperationResult) { try { using (BdEntities dbContext = new BdEntities()) { var Query = (from n in dbContext.clients select new ClientDto { id_Client = n.id_Client, Nom = n.Nom, Cognom1 = n.Cognom1, Adreça = n.Adreça, CodiPostal = n.CodiPostal, Poblacio = n.Poblacio, Provincia = n.Provincia, Telefon = n.Telefon, Fax = n.Fax, E_mail = n.E_mail }).ToList(); if (Query.Count > 0) { var xEle = new XElement("Clientes", from emp in Query select new XElement("Cliente", new XElement("id_Client", emp.id_Client), new XElement("Nom", emp.Nom), new XElement("Cognom1", emp.Cognom1), new XElement("Adreça", emp.Adreça), new XElement("CodiPostal", emp.CodiPostal), new XElement("Poblacio", emp.Poblacio), new XElement("Provincia", emp.Provincia), new XElement("Telefon", emp.Telefon), new XElement("Fax", emp.Fax), new XElement("E_mail", emp.E_mail) )); xEle.Save("Clientes.xml"); } pobjOperationResult.Succes = 1; } } catch (Exception ex) { pobjOperationResult.Succes = 0; pobjOperationResult.ErrorMensaje = ex.Message; pobjOperationResult.InnerException = ex.InnerException != null ? ex.InnerException.Message : string.Empty; return; } }