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