private void SetOperationsGroupValues(OperationsGroup group)
{
_borderCalendar.Visibility = Visibility.Hidden;
_calDate.SelectedDate = DateTime.Now;
_group = group;
ResetEditableControls();
_tbNewDescription.Text = _group.Description;
_labDate.Content = _group.Date.ToString(Properties.strings.dateFormat);
if (_group.Frequency != null)
{
_cbFrequent.SelectedItem = _observableFrequencies.First(f => f.Text == _group.Frequency.Text);
}
if (_group.Importance != null)
{
_cbImportance.SelectedItem = _observableImportances.First(f => f.Text == _group.Importance.Text);
}
foreach (var tag in _group.Tags)
{
if (!tag.IsMarkForDeletion && !tag.IsDirty)
{
SetTagLabel(tag.Tag);
}
}
UserEditableControlsVisibility(Visibility.Visible);
}
private void ShowResult(FileStorageProvider provider, string resultMessage, OperationsGroup operationsGroup = null)
{
switch (provider)
{
case FileStorageProvider.Local:
pnlResultLocal.Visible = true;
pnlErrorLocal.Visible = false;
litResultsLocal.Text = resultMessage;
if (operationsGroup != null)
{
litResultsLocal.Text += operationsGroup.ToString();
}
break;
case FileStorageProvider.AzureStorageBlobs:
pnlResultAzure.Visible = true;
pnlErrorAzure.Visible = false;
litResultsAzure.Text = resultMessage;
if (operationsGroup != null)
{
litResultsAzure.Text += operationsGroup.ToString();
}
break;
}
}
static string CalculateOperations(string input, OperationsGroup group)
{
string pattern = "";
if (group == OperationsGroup.MultiplyAndDivide)
{
pattern = @"((\d+[.,]\d+)|\d+)[*/]((\d+[.,]\d+)|\d+)";
}
if (group == OperationsGroup.PlusAndMinus)
{
pattern = @"((\d+[.,]\d+)|\d+)[+-]((\d+[.,]\d+)|\d+)";
}
var expression = new Regex(pattern);
while (expression.IsMatch(input))
{
var match = expression.Match(input);
string result = CalculateOperation(match.Value);
input = expression.Replace(input, result, 1);
}
return(input);
}
public static void UpdateOperationsGroupComplex(OperationsGroup group)
{
UpdateOperationGroup(group);
for (int i = group.Tags.Count - 1; i > -1; i--)
{
RelTag tag = group.Tags[i];
if (tag.IsMarkForDeletion && !tag.IsDirty)
{
DeleteRelation(tag, group);
continue;
}
if (tag.IsDirty)
{
InsertRelation(tag, group);
}
}
foreach (var operation in group.Operations)
{
operation.SetFrequency(group.Frequency);
operation.SetImportance(group.Importance);
UpdateOperationTags(operation, group.Tags);
UpdateOperationComplex(operation);
}
}
private void SetRelatedAttributes(OperationsGroup group)
{
_labFrequence.Content = group.Frequency;
_labImportance.Content = group.Importance;
foreach (var item in group.Tags)
{
_labTags.Content += item.Tag + "; ";
}
}
private static int InsertRelation(RelTag tag, OperationsGroup group)
{
if (tag.IsDirty)
{
var newId = OperationsGroupRelationAdapter.Insert(OperationsGroupRelationMapper.ConvertToDALEntity(tag, group));
tag.UpdateId(newId);
tag.IsDirty = false;
}
return(tag.Id.Value);
}
public AddGroupsView(OperationsGroup group)
{
InitializeComponent();
ViewsMemory.AddedParameter += AddedParameterEvent;
Background = Brushes.Azure;
LoadAttributes();
_group = group;
SetEditableControls();
SetOperationsGroupValues(_group);
EditMode(true);
}
public AddGroupsView()
{
InitializeComponent();
ViewsMemory.AddedParameter += AddedParameterEvent;
Background = Brushes.Azure;
LoadAttributes();
_group = new OperationsGroup(null, Service.User, "", null, null, DateTime.Now);
SetEditableControls();
SetOperationsGroupValues(_group);
EditMode(false);
}
private void BtnManualAccept_Click(object sender, RoutedEventArgs e)
{
_group.SetImportance(_cbImportance.SelectedItem as Importance);
_group.SetFrequence(_cbFrequent.SelectedItem as Frequency);
_group.SetDate(DateTime.ParseExact(_labDate.Content.ToString(), Properties.strings.dateFormat, System.Globalization.CultureInfo.InvariantCulture));
UpdateOperationsGroupTags();
_group.SetDescription(_tbNewDescription.Text);
try
{
Service.UpdateOperationsGroupComplex(_group);
ViewsMemory.AddedGroup?.Invoke(_group);
ResetEditableControls();
SetEditableControls();
var group = new OperationsGroup(null, Service.User, "", null, null, DateTime.Now);
SetOperationsGroupValues(group);
}
catch (Exception ex)
{
var dialog = new MessageBox(Properties.strings.messageBoxStatement, ex.Message);
dialog.ShowDialog();
}
}
private void AddedGroupEvent(OperationsGroup added)
{
_observableGroups.Add(added);
}
private static int UpdateOperationGroup(OperationsGroup group)
{
return(UpdateBusinessEntity(group, OperationsGroupAdapter, OperationsGroupMapper.ConvertToDALEntity));
}
private static void DeleteRelation(RelTag tag, OperationsGroup group)
{
group.RemoveTag(tag);
OperationsGroupRelationAdapter.Delete(OperationsGroupRelationMapper.ConvertToDALEntity(tag, group));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
var stopwatch = new Stopwatch();
FileStorageProvider provider = FileStorageProvider.Local;
System.Web.UI.WebControls.FileUpload fileUploadControl = fuCsvFileLocal;
var tracker = new OperationsGroup();
if (((Button)sender).ID.Equals("btnSubmitAzure"))
{
provider = FileStorageProvider.AzureStorageBlobs;
fileUploadControl = fuCsvFileAzure;
}
if (fileUploadControl.PostedFile != null)
{
if (fileUploadControl.PostedFile.ContentLength > 0)
{
var memoryStream = StreamUtility.CopyToMemoryStream(fileUploadControl.PostedFile.InputStream);
stopwatch.Start();
var scanResult = virusScanner.ScanStream(StreamUtility.CopyToMemoryStream(memoryStream));
stopwatch.Stop();
tracker.Add("Virus Scan", stopwatch.ElapsedMilliseconds);
if (scanResult.IsSafe)
{
stopwatch.Restart();
var parseErrors = CsvFile.Validate(StreamUtility.CopyToMemoryStream(memoryStream));
stopwatch.Stop();
tracker.Add("CSV Validation", stopwatch.ElapsedMilliseconds);
if (parseErrors.Count > 0)
{
ShowError(provider, "Errors found in file: <br />" + string.Join("<br />", parseErrors));
}
else
{
try
{
stopwatch.Restart();
switch (provider)
{
case FileStorageProvider.AzureStorageBlobs:
azureFileStorage.SavePostedFile(fileUploadControl.PostedFile.FileName, StreamUtility.CopyToMemoryStream(memoryStream));
break;
case FileStorageProvider.Local:
localFileStorage.SavePostedFile(fileUploadControl.PostedFile.FileName, StreamUtility.CopyToMemoryStream(memoryStream));
break;
}
stopwatch.Stop();
tracker.Add("Storage", stopwatch.ElapsedMilliseconds);
ShowResult(provider, "The file has been uploaded.", tracker);
UpdateFileList();
}
catch (Exception ex)
{
ShowError(provider, ex.Message);
}
}
}
else
{
ShowError(provider, $"Virus scan found issues: {scanResult.Message}");
}
}
else
{
ShowError(provider, "Empty file uploaded.");
}
}
else
{
ShowResult(provider, "Please select a file to upload.");
}
}
public DalOperationsGroupTag ConvertToDALEntity(RelTag businessEntity1, OperationsGroup businessEntity2)
{
var result = new DalOperationsGroupTag(businessEntity1.Id, businessEntity2.Id, businessEntity1.Tag.Id);
return(result);
}
public IEnumerable <DalOperationsGroupTag> ConvertToDALEntitiesCollection(IEnumerable <RelTag> dataEntities1, OperationsGroup dataEntity2)
{
var result = new List <DalOperationsGroupTag>();
for (var i = 0; i < dataEntities1.Count(); ++i)
{
result.Add(ConvertToDALEntity(dataEntities1.ElementAt(i), dataEntity2));
}
return(result);
}
private OperationsGroup getOperationGroup(string id)
{
OperationsGroup result = null;
try
{
using (var repository = new MainRepository(new AppContext("PostgresConnection")))
{
GroupEntity group = repository.Groups.Get(id);
if (group != null)
{
var operations = repository.Operations.selectOperationsByGroup(group.Name);
List<Operation> list = new List<Operation>();
foreach (var op in operations)
list.Add(new Operation(op.Name, op.Name.Split('/')[1], op.GroupId, op.Description, op.isPayrollCalculationRelated));
result = new OperationsGroup(group.Description, group.Name, group.Icon, list);
}
else
{
throw validateException(App_LocalResoures.Errors.inexistentGroup);
}
}
}
catch (Exception e)
{
throw validateException(e);
}
return result;
}
