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