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 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); }
private void FileScan(int action) { this.FileScanBusy = true; var setting = Setting.CurrentSetting; foreach (var path in setting.Paths.FindAll(p => p.IsActive == true)) { Parallel.ForEach(GetFiles(path.Path), (file, a) => { if (!IsIgnore(file)) { var status = LogHelper.AddFile(file); if (status && action == 0) { var log = new ChangesLog() { FilePath = file, WatcherPath = "FileScan", AddTime = DateTime.Now, Action = "FileScan", AddedToSync = 0 }; LogHelper.AddChangeLog(log); } } }); } this.FileScanBusy = false; }
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 void LogUpdate(DateTime time, object newObject, object oldObject) { if (newObject == null | oldObject == null) { throw new InvalidOperationException("One of the object's state cannot be null for update logging"); } int? ObjectID = 0; bool LogChangedState = false; IsObjectWasChanged(newObject, oldObject, ref ObjectID, ref LogChangedState); IsCollectionWasChanged(newObject, oldObject, ref LogChangedState); if (LogChangedState) { LogsBase baseLog = new LogsBase(); baseLog.Operation = "UPDATE"; baseLog.LogLevel = "Information"; baseLog.Time = time; ldb.LogsBases.Add(baseLog); ldb.SaveChanges(); ChangesLog changesLog = new ChangesLog(); changesLog.BaseLogID = baseLog.LogID; changesLog.ObjectID = ObjectID ?? 0; changesLog.ObjectType = newObject.GetType().Name; var json = new JavaScriptSerializer().Serialize(newObject); //var deserializedObj = new JavaScriptSerializer().Deserialize(json, typeof(Entrant)); changesLog.State = json; ldb.ChangesLogs.Add(changesLog); ldb.SaveChanges(); } }
private async void AddProductButton_OnClick(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(_viewModel.History.error) && _viewModel.History.Quantity > 0 && !string.IsNullOrWhiteSpace(_viewModel.History.Quantity.ToString())) { _viewModel.Product.Quantity += _viewModel.History.Quantity; productBusiness.Update(_viewModel.Product); OnAddInventoryClicked(); _viewModel.History.User = LogInfo.LoggedUser; _viewModel.History.Product = _viewModel.Product; _viewModel.History.Provider = _viewModel.Product.Provider; _viewModel.History.TransactionType = "Aumento de Inventario"; ChangesLog changesLog = new ChangesLog() { Date = DateTime.Now, Description = "Se anadio Inventario", Module = "Producto", User = LogInfo.LoggedUser }; changesLogBusiness.Create(changesLog); historyBusiness.Create(_viewModel.History); } else { NtTextBlock.Text = "Los cambios no han sido registrados, favor de ingresar los datos correspondientes"; } }
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 static void AddChangeLog(ChangesLog log) { var isexist = mongo.GetData <ChangesLog>("ChangesLog", l => l.FilePath == log.FilePath && l.AddedToSync == 0); if (isexist.Count() == 0) { mongo.AddOne <ChangesLog>("ChangesLog", log); } }
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 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 void LogDelete(DateTime time, object obj) { int?ObjectID = 0; // Copy all information in new not-wrapped object // So it can be serialized Type initialType = ObjectContext.GetObjectType(obj.GetType()); object initialObject = Activator.CreateInstance(initialType); List <FieldInfo> properiesInfo = initialType.GetRuntimeFields().ToList(); foreach (FieldInfo fieldInfo in properiesInfo) { fieldInfo.SetValue(initialObject, fieldInfo.GetValue(obj)); if (fieldInfo.Name.Contains(initialType.Name + "ID")) { ObjectID = (fieldInfo.GetValue(obj) as int?) ?? 0; } } LogsBase baseLog = new LogsBase(); baseLog.Operation = "Delete"; baseLog.LogLevel = "Information"; baseLog.Time = time; ldb.LogsBases.Add(baseLog); ldb.SaveChanges(); ChangesLog changesLog = new ChangesLog(); changesLog.BaseLogID = baseLog.LogID; changesLog.ObjectID = ObjectID ?? 0; changesLog.ObjectType = initialType.Name; var json = new JavaScriptSerializer().Serialize(initialObject); changesLog.State = json; ldb.ChangesLogs.Add(changesLog); ldb.SaveChanges(); }
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); }
private void Watcher_Created(object sender, FileSystemEventArgs e) { if (IsIgnore(e.FullPath)) { return; } FileAttributes attr = File.GetAttributes(e.FullPath); if (!attr.HasFlag(FileAttributes.Directory)) { var log = new ChangesLog() { FilePath = e.FullPath, WatcherPath = ((FileSystemWatcher)sender).Path, AddTime = DateTime.Now, Action = e.ChangeType.ToString(), AddedToSync = 0 }; LogHelper.AddChangeLog(log); LogHelper.AddFile(e.FullPath); } }
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); }
private void AddProductButton_OnClick(object sender, RoutedEventArgs e) { if (_viewModel.Product.Provider != null && string.IsNullOrWhiteSpace(_viewModel.Product.error)) { Notification.Text = ""; if (_viewModel.Product.Id != 0) { productBusiness.Update(_viewModel.Product); ChangesLog changesLog = new ChangesLog() { Date = DateTime.Now, Description = "Actualizacion de Producto", Module = "Producto", User = LogInfo.LoggedUser }; changesLogBusiness.Create(changesLog); } else { productBusiness.Create(_viewModel.Product); ChangesLog changesLog = new ChangesLog() { Date = DateTime.Now, Description = "Creacion de nuevo Producto", Module = "Producto", User = LogInfo.LoggedUser }; changesLogBusiness.Create(changesLog); } OnAddProductClicked(); } else { Notification.Text = "Producto no ha sido registrado, favor de ingresar los datos correspondientes"; } }