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