public DocumentTypeInfo SelectByCode(string Code) { try { using (var item = new IGDDemoEntities()) { var documentType = item.DocumentTypes.FirstOrDefault(d => d.Code == Code); if (documentType == null) { return(null); } DocumentTypeInfo documentTypeInfo = new DocumentTypeInfo { Id = documentType.Id, Title = documentType.Title, Code = documentType.Code }; return(documentTypeInfo); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public List <DocumentTypeInfo> SelectAll() { try { using (var item = new IGDDemoEntities()) { var documentTypes = item.DocumentTypes.ToList(); if (documentTypes == null) { return(null); } List <DocumentTypeInfo> documentTypesList = documentTypes.Select(document => new DocumentTypeInfo { Id = document.Id, Title = document.Title, Code = document.Code }).ToList(); return(documentTypesList); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DocumentTypeInfo SelectById(int documentTypeId) { try { using (var item = new IGDDemoEntities()) { var documentType = item.DocumentTypes.Find(documentTypeId); if (documentType == null) { return(null); } DocumentTypeInfo documentTypeInfo = new DocumentTypeInfo { Id = documentType.Id, Title = documentType.Title, Code = documentType.Code }; return(documentTypeInfo); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Update(DocumentTypeInfo documentTypeInfo) { try { using (var scope = new TransactionScope()) { using (var item = new IGDDemoEntities()) { // Un tercer parámetro del FirstOrDefault recibe un predicado que es una función que me devuelve un valor. var documentTypeData = item.DocumentTypes.FirstOrDefault(d => d.Id == documentTypeInfo.Id); if (documentTypeData != null) { documentTypeData.Title = documentTypeInfo.Title; documentTypeData.Code = documentTypeInfo.Code; item.Entry(documentTypeData).State = System.Data.Entity.EntityState.Modified; item.Entry(documentTypeData).CurrentValues.SetValues(documentTypeData); item.SaveChanges(); scope.Complete(); return(true); } scope.Dispose(); return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Delete(int documentTypeId) { try { using (var scope = new TransactionScope()) { using (var item = new IGDDemoEntities()) { var documentTypeData = item.DocumentTypes.FirstOrDefault(d => d.Id == documentTypeId); if (documentTypeData != null) { item.Entry(documentTypeData).State = System.Data.Entity.EntityState.Deleted; item.SaveChanges(); scope.Complete(); return(true); } scope.Dispose(); return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Insert(DocumentTypeInfo documentType) { try { using (var scope = new TransactionScope()) { using (var item = new IGDDemoEntities()) { DocumentTypes igdDocumentTypes = new DocumentTypes() { Title = documentType.Title, Code = documentType.Code }; item.DocumentTypes.Add(igdDocumentTypes); if (item.SaveChanges().Equals(1)) { scope.Complete(); return(true); } scope.Dispose(); return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Insert(ClientInfo client) { try { using (var scope = new TransactionScope()) { using (var item = new IGDDemoEntities()) { var personData = item.People.FirstOrDefault(p => p.DocumentTypeId == client.DocumentTypeId && p.DocumentNumber == client.DocumentNumber); if (personData == null) { People person = new People() { DocumentTypeId = client.DocumentTypeId, DocumentNumber = client.DocumentNumber, FirstName = client.FirstName, SecondName = client.SecondName }; item.People.Add(person); if (!item.SaveChanges().Equals(1)) { return(false); } personData = item.People.FirstOrDefault(p => p.DocumentTypeId == client.DocumentTypeId && p.DocumentNumber == client.DocumentNumber); } Clients igdClient = new Clients() { Readed = client.Readed, Phone = client.Phone, LastReading = client.LastReading, Deliveries = new List <Deliveries>(), PersonId = personData.Id, Anniversary = client.Anniversary, Email = client.Email, Address = client.Address }; item.Clients.Add(igdClient); if (item.SaveChanges().Equals(1)) { scope.Complete(); return(true); } scope.Dispose(); return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Update(ClientInfo client) { try { using (var scope = new TransactionScope()) { using (var item = new IGDDemoEntities()) { var clientData = item.Clients.FirstOrDefault(c => c.Id == client.Id); if (clientData != null) { var personData = item.People.FirstOrDefault(p => p.Id == clientData.PersonId); personData.DocumentTypeId = client.DocumentTypeId; personData.DocumentNumber = client.DocumentNumber; personData.FirstName = client.FirstName; personData.SecondName = client.SecondName; item.Entry(personData).State = System.Data.Entity.EntityState.Modified; item.Entry(personData).CurrentValues.SetValues(personData); item.SaveChanges(); clientData.Readed = client.Readed; clientData.Phone = client.Phone; clientData.LastReading = client.LastReading; clientData.Anniversary = client.Anniversary; clientData.Email = client.Email; clientData.Address = client.Address; item.Entry(clientData).State = System.Data.Entity.EntityState.Modified; item.Entry(clientData).CurrentValues.SetValues(clientData); item.SaveChanges(); scope.Complete(); return(true); } scope.Dispose(); return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public ClientInfo SelectByDocument(int documentTypeId, string documentNumber) { try { using (var item = new IGDDemoEntities()) { var person = item.People.FirstOrDefault(p => p.DocumentTypeId == documentTypeId && p.DocumentNumber == documentNumber); if (person == null) { return(null); } var client = item.Clients.FirstOrDefault(c => c.PersonId == person.DocumentTypeId); if (client == null) { return(null); } ClientInfo clientInfo = new ClientInfo { Id = client.Id, DocumentTypeId = item.People.FirstOrDefault(p => p.Id == client.PersonId).DocumentTypeId, DocumentNumber = item.People.FirstOrDefault(p => p.Id == client.PersonId).DocumentNumber, FirstName = item.People.FirstOrDefault(p => p.Id == client.PersonId).FirstName, SecondName = item.People.FirstOrDefault(p => p.Id == client.PersonId).SecondName, Phone = client.Phone, Readed = client.Readed, Anniversary = client.Anniversary.Value, Email = client.Email, Address = client.Address, LastReading = client.LastReading }; return(clientInfo); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public List <ClientInfo> SelectAll() { try { using (var item = new IGDDemoEntities()) { var clients = item.Clients.ToList(); if (clients == null) { return(null); } List <ClientInfo> clientsList = clients.Select(client => new ClientInfo { Id = client.Id, DocumentTypeId = item.People.FirstOrDefault(p => p.Id == client.PersonId).DocumentTypeId, DocumentNumber = item.People.FirstOrDefault(p => p.Id == client.PersonId).DocumentNumber, FirstName = item.People.FirstOrDefault(p => p.Id == client.PersonId).FirstName, SecondName = item.People.FirstOrDefault(p => p.Id == client.PersonId).SecondName, Phone = client.Phone, Readed = client.Readed, Anniversary = client.Anniversary.Value, Email = client.Email, Address = client.Address, LastReading = client.LastReading }).ToList(); return(clientsList); } } catch (Exception ex) { throw new Exception(ex.Message); } }