public Price Create(Price entity)
{
Price response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
AFEIEntities.Prices.AddObject(entity);
AFEIEntities.SaveChanges();
response = AFEIEntities.Prices.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Nuevo Precio",
Module = "Precio",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public int Delete(int entityId)
{
int response;
try
{
using (var AFEIentities = new AFEIEntities())
{
var price = GetList().FirstOrDefault(x => x.Id == entityId);
var documentTypeToDelete = AFEIentities.Prices.Include("Products").Single(x => x.Id == entityId);
AFEIentities.Prices.DeleteObject(documentTypeToDelete);
AFEIentities.SaveChanges();
response = entityId;
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Eliminacion Precio",
Module = "Precio",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public ChangesLog Update(ChangesLog entity)
{
ChangesLog response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new ChangesLog()
{
Id = entity.Id
};
stub.Module = entity.Module;
stub.Description = entity.Description;
stub.Date = entity.Date;
stub.User = entity.User;
AFEIEntities.SaveChanges();
var changes = AFEIEntities.Clients
.Include("User");
AFEIEntities.SaveChanges();
response = AFEIEntities.ChangesLogs.Single(x => x.Id == entity.Id);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public History Create(History entity)
{
History response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
entity.User = AFEIEntities.Users.First(x => x.Id == entity.User.Id);
entity.Provider = AFEIEntities.Providers.First(x => x.Id == entity.Provider.Id);
entity.Product = AFEIEntities.Products.First(x => x.Id == entity.Product.Id);
entity.Date = DateTime.Now;
AFEIEntities.Histories.AddObject(entity);
AFEIEntities.SaveChanges();
response = AFEIEntities.Histories.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Nuevo History",
Module = "History",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public List <Price> GetList()
{
List <Price> response;
try
{
using (var AFEIentities = new AFEIEntities())
{
response = AFEIentities.Prices.Include("Products").ToList();
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public List <User> GetList()
{
List <User> response;
try
{
using (var AFEIentities = new AFEIEntities())
{
response = AFEIentities.Users.Include("ChangesLogs").Include("Histories").ToList();
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public List <History> GetList()
{
List <History> response;
try
{
using (var AFEIentities = new AFEIEntities())
{
response = AFEIentities.Histories
.Include("Product").Include("Provider").Include("User").ToList();
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public List <ChangesLog> GetList()
{
List <ChangesLog> response;
try
{
using (var AFEIentities = new AFEIEntities())
{
response = AFEIentities.ChangesLogs
.Include("User").ToList();
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public History Update(History entity)
{
History response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new History()
{
Id = entity.Id
};
stub.TransactionAmount = entity.TransactionAmount;
stub.Date = entity.Date;
stub.Justification = entity.Justification;
stub.Product = entity.Product;
stub.Provider = entity.Provider;
stub.User = entity.User;
AFEIEntities.SaveChanges();
var history = AFEIEntities.Histories
.Include("Product").Include("Provider").Include("Transaction").Include("User");
AFEIEntities.SaveChanges();
response = AFEIEntities.Histories.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Actualizacion History",
Module = "History",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public User Update(User entity)
{
User response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new User()
{
Id = entity.Id
};
stub.Firstname = entity.Firstname;
stub.Lastname = entity.Lastname;
stub.Phone = entity.Phone;
stub.Username = entity.Username;
stub.Password = entity.Password;
AFEIEntities.SaveChanges();
var user =
AFEIEntities.Providers.Include("ChangesLogs").Include("Histories").Include("Transactions");
AFEIEntities.SaveChanges();
response = AFEIEntities.Users.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Actualizacion Usuario",
Module = "Usuario",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public History Read(int entityId)
{
History response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
response = AFEIEntities.Histories
.Include("Product").Include("Provider").Include("Transaction").Include("User")
.Single(x => x.Id == entityId);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public ChangesLog Read(int entityId)
{
ChangesLog response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
response = AFEIEntities.ChangesLogs
.Include("User")
.Single(x => x.Id == entityId);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public ChangesLog Create(ChangesLog entity)
{
ChangesLog response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
entity.User = AFEIEntities.Users.FirstOrDefault(x => x.Id == entity.User.Id);
AFEIEntities.ChangesLogs.AddObject(entity);
AFEIEntities.SaveChanges();
response = AFEIEntities.ChangesLogs.Single(x => x.Id == entity.Id);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public Price Read(int entityId)
{
Price response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
response = AFEIEntities.Prices
.Include("Products")
.Single(x => x.Id == entityId);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public User Read(int entityId)
{
User response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
response = AFEIEntities.Users
.Include("ChangesLogs").Include("Histories").Include("Transactions")
.Single(x => x.Id == entityId);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public Product Update(Product entity)
{
Product response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
AFEIEntities.Products.Attach(entity);
AFEIEntities.Products.Context.ObjectStateManager.ChangeObjectState(entity, System.Data.Entity.EntityState.Modified);
AFEIEntities.SaveChanges();
return(entity);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public Price Update(Price entity)
{
Price response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new Price()
{
Id = entity.Id
};
stub.Price1 = entity.Price1;
stub.Date = entity.Date;
stub.Products = entity.Products;
AFEIEntities.SaveChanges();
var price = AFEIEntities.Prices.Include("Products");
AFEIEntities.SaveChanges();
response = AFEIEntities.Prices.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Actualizacion Precio",
Module = "Precio",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public int Delete(int entityId)
{
int response;
try
{
using (var AFEIentities = new AFEIEntities())
{
var client = GetList().FirstOrDefault(x => x.Id == entityId);
var documentTypeToDelete = AFEIentities.ChangesLogs
.Include("User").Single(x => x.Id == entityId);
AFEIentities.ChangesLogs.DeleteObject(documentTypeToDelete);
AFEIentities.SaveChanges();
response = entityId;
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public Client Update(Client entity)
{
Client response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new Client()
{
Id = entity.Id
};
//stub.FirstName = entity.FirstName;
//stub.LastName = entity.LastName;
//stub.Phone = entity.Phone;
//stub.Products = entity.Products;
AFEIEntities.Clients.Attach(stub);
AFEIEntities.Clients.ApplyCurrentValues(entity);
AFEIEntities.SaveChanges();
response = AFEIEntities.Clients.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Actualizacion Cliente",
Module = "Client",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
public Provider Update(Provider entity)
{
Provider response;
try
{
using (var AFEIEntities = new AFEIEntities())
{
var stub = new Provider()
{
Id = entity.Id
};
AFEIEntities.Providers.Attach(stub);
AFEIEntities.Providers.ApplyCurrentValues(entity);
AFEIEntities.SaveChanges();
var phase = AFEIEntities.Providers.Include("Histories").Include("Products");
AFEIEntities.SaveChanges();
response = AFEIEntities.Providers.Single(x => x.Id == entity.Id);
ChangesLog changesLog = new ChangesLog()
{
Date = DateTime.Now,
Description = "Actualizacion Proveedor",
Module = "Proveedor",
User = LogInfo.LoggedUser
};
changesLogPersistence.Create(changesLog);
}
}
catch (Exception e)
{
throw e;
}
return(response);
}
