private static void Main(string[] args)
{
if (args.Length != 2)
{
Console.WriteLine("Incorrect command line parameters.");
}
else
{
try
{
var allLinesFromText = File.ReadAllLines(args[0]);
var allLinesFromQueries = File.ReadAllLines(args[1]);
var textParser = new TextParser(allLinesFromText);
textParser.ParseText();
var queries = new Queries(allLinesFromQueries, textParser);
queries.ProcessAllRequests();
queries.AllReplies.Print();
}
catch (FileNotFoundException exception)
{
Console.WriteLine(exception.Message);
}
}
}
private void PopulateVersionButtons(Queries.sp_GetApplicationVersionsDataTable dt)
{
if (dt.Rows.Count <= 0)
return;
Queries.sp_GetApplicationVersionsRow drow = dt.Where(i => i.Name.Contains("Windows Service")).FirstOrDefault();
lblWinVersion.Text = "Latest Version: " + drow.version;
}
/// <summary>
/// Creates a new Query Window
/// </summary>
/// <param name="queries">Queries object</param>
public QueryDialog(Queries queries)
{
_queries = queries;
InitializeComponent();
_resources.Add("Cancel", "Cancel");
_resources.Add("Instructions", "Type in an MQL query and click Run Queries");
_resources.Add("RemoveQuery", "Remove Query");
_resources.Add("RunQueries", "Run");
_resources.Add("SaveQueries", "Save");
_resources.Add("WindowTitle", "Run Queries");
Draw();
}
public event EventHandler <Query> Queries; // effectively a chain
public void PerformQuery(object sender, Query q)
{
Queries?.Invoke(sender, q);
}
public override string GetHtml()
{
var html = string.Empty;
/////////////////////
// fetch data sets
/////////////////////
// get the latest stored email entry
var emailsSnapshotResult = Queries.GetEmailsSnapshot(_date.Date);
var inbox = emailsSnapshotResult.Item2;
var inboxUnread = emailsSnapshotResult.Item3;
var sent = emailsSnapshotResult.Item4;
var received = emailsSnapshotResult.Item5;
var receivedUnread = emailsSnapshotResult.Item6;
var isToday = (_date.Date == DateTime.Now.Date);
var lastUpdatedMinsAgo = Math.Abs((DateTime.Now - emailsSnapshotResult.Item1).TotalMinutes);
// if database entry is outdated or not there, create a live API call and override entries
if (emailsSnapshotResult.Item1 == DateTime.MinValue || // no emails stored yet
(isToday && lastUpdatedMinsAgo > Settings.SaveEmailCountsInterval_InMinutes)) // request is for today and saved results are too old // could not fetch sent emails
{
// create and save a new email snapshot (inbox, sent, received)
var res = Queries.CreateEmailsSnapshot(_date.Date, false);
inbox = res.Item1;
inboxUnread = res.Item2;
sent = res.Item3;
received = res.Item4;
receivedUnread = res.Item5;
}
// error (only if no data at all)
if (sent < 0 && (received < 0 || receivedUnread < 0) && inbox < 0 && inboxUnread < 0)
{
return(VisHelper.NotEnoughData(Dict.NotEnoughData));
}
// get averages over last 2 months
var averagesSnapshot = Queries.GetEmailsSnapshotAverages(60);
/////////////////////
// HTML
/////////////////////
html += "<table>";
if (sent > Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + sent + "</strong></td><td>emails sent" + FormatAverage(sent, averagesSnapshot.Item3) + "</td></tr>";
}
if (received > Settings.NoValueDefault && receivedUnread > Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + (received - receivedUnread) + "</strong></td><td>emails received that are read" + FormatAverage((received - receivedUnread), averagesSnapshot.Item4 - averagesSnapshot.Item5) + "</td></tr>";
}
if (received > Settings.NoValueDefault && receivedUnread > Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + receivedUnread + "</strong></td><td>emails received that are unread" + FormatAverage(receivedUnread, averagesSnapshot.Item5) + "</td></tr>";
}
if (received > Settings.NoValueDefault && receivedUnread == Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + received + "</strong></td><td>emails received" + FormatAverage(received, averagesSnapshot.Item4) + "</td></tr>";
}
if (inbox > Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + inbox + "</strong></td><td>emails in your inbox" + FormatAverage(inbox, averagesSnapshot.Item1) + "</td></tr>";
}
if (inboxUnread > Settings.NoValueDefault)
{
html += "<tr><td><strong style='font-size:2.5em; color:#007acc;'>" + inboxUnread + "</strong></td><td>unread emails in your inbox" + FormatAverage(inboxUnread, averagesSnapshot.Item2) + "</td></tr>";
}
html += "</table>";
return(html);
}
public T Query <T>(Query q)
{
Queries?.Invoke(this, q);
return((T)q.Result);
}
protected virtual long DoEstimateSubscriberCount(GDID gEmitterNode)
{
var count = ForNode(gEmitterNode).LoadOneRow(Queries.CountSubscribers <Row>(gEmitterNode));
return(count[0].AsLong());
}
public FileServer(string path)
{
//Console.WriteLine("Server File not started, because path '" + path + "' does not exist");
Console.WriteLine("Server File Communication started ... ");
this.directory = path;
DirectoryInfo di = new DirectoryInfo(@"C:\CommunicationFile\archive\");
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
while (true)
{
DirectoryInfo dir = new DirectoryInfo(directory);
DirectoryInfo[] _dirs = dir.GetDirectories();
FileInfo[] _files = dir.GetFiles("*.in");
//Console.WriteLine("File1 " + _files.Length);
if (dir == null)
{
System.Threading.Thread.Sleep(100);
}
else
{
foreach (var item in _files)
{
Console.WriteLine("FileName -> " + item.Name);
//readFile = File.ReadAllText(directory + "" + item.Name);
readFile = ReadCommand(directory + "" + item.Name);
Console.WriteLine("FileRead <- " + readFile);
recv = Queries.ParseAnswer(readFile);
Console.WriteLine("File -> " + recv);
File.WriteAllText(Path.ChangeExtension(directory + "" + item.Name, ".out"), recv);
//File.WriteAllText(directory + ".out", recv);
if (File.Exists(directory + "/archive/" + item.Name))
{
File.Delete(directory + "/archive/" + item.Name);
File.Move(directory + "" + item.Name, directory + "/archive/" + item.Name);
}
else
{
File.Move(directory + "" + item.Name, directory + "/archive/" + item.Name);
}
}
}
//fileName = string.Format("{0}Command_{1}_FormClient", directory, commandNumber);
//while (!File.Exists(fileName + ".in"))
// System.Threading.Thread.Sleep(100);
//readFile = File.ReadAllText(fileName + ".in");
//Console.WriteLine("File <- " + readFile);
//recv = Queries.ParseAnswer(readFile);
//Console.WriteLine("File -> " + recv);
//File.WriteAllText(fileName + ".out", recv);
//if (File.Exists(@"C:\CommunicationFile\archive\Command_" + commandNumber + "_FormClient.in"))
//{
// File.Delete(@"C:\CommunicationFile\archive\Command_" + commandNumber + "_FormClient.in");
// File.Move(@"C:\CommunicationFile\Command_" + commandNumber + "_FormClient.in", @"C:\CommunicationFile\archive\Command_" + commandNumber + "_FormClient.in");
//}
//else
//{
// File.Move(@"C:\CommunicationFile\Command_" + commandNumber + "_FormClient.in", @"C:\CommunicationFile\archive\Command_" + commandNumber + "_FormClient.in");
//}
//commandNumber++;
}
}
public List <Loanbook_Data> GetLoanBookData()
{
var qry = Queries.Raw_Data(this._eclId, this._eclType);
Log4Net.Log.Info("Started");
var _lstRaw = DataAccess.i.GetData(qry);
Log4Net.Log.Info("Selected Raw Data from table");
Console.WriteLine($"Started after Select - {DateTime.Now}");
var bt_ead = new CalibrationInput_EAD_Behavioural_Terms_Processor();
var bt_ead_data = bt_ead.GetBehaviouralData(this._eclId, this._eclType);
var threads = _lstRaw.Rows.Count / 500;
threads = threads + 1;
var taskLst = new List <Task>();
var tskStatusLst = new List <TaskStatus> {
TaskStatus.RanToCompletion, TaskStatus.Faulted, TaskStatus.Canceled
};
for (int i = 0; i < threads; i++)
{
var sub_LoanBook = _lstRaw.AsEnumerable().Skip(i * 500).Take(500).ToList();
//var contractIds = sub_LoanBook.Select(o => o.ContractNo).ToList();
//var sub_payment_schedule = payment_schedule.Where(o => contractIds.Contains(o.ContractRefNo)).ToList();
var task = Task.Run(() =>
{
RunLoanBookReadJob(sub_LoanBook, bt_ead, bt_ead_data);
});
taskLst.Add(task);
}
Log4Net.Log.Info($"Select Loanbook data Total Task : {taskLst.Count()}");
while (0 < 1)
{
if (taskLst.All(o => tskStatusLst.Contains(o.Status)))
{
break;
}
//Do Nothing
}
Console.WriteLine($"Done with all Task {taskLst.Count} - {DateTime.Now}");
// lstRaw = lstRaw.OrderBy(o => o.CustomerNo).ThenBy(p=>p.AccountNo).ThenBy(p => p.ContractNo).ToList();
lstRaw = lstRaw.OrderBy(o => o.ContractId).ToList();
var groupedLoanBook = new List <List <Loanbook_Data> >();
threads = lstRaw.Count / 500;
threads = threads + 1;
for (int i = 0; i < threads; i++)
{
var sub_items = lstRaw.Skip(i * 500).Take(500).ToList();
if (sub_items.Count > 0)
{
groupedLoanBook.Add(sub_items);
}
}
var allAccountsGrouped = false;
try
{
while (!allAccountsGrouped)
{
allAccountsGrouped = true;
for (int i = 1; i < groupedLoanBook.Count; i++)
{
var lstfromPrev = groupedLoanBook[i - 1].LastOrDefault();
var fstfromCurr = groupedLoanBook[i].FirstOrDefault();
if (lstfromPrev.ContractId == fstfromCurr.ContractId)
{
groupedLoanBook[i - 1].Add(fstfromCurr);
groupedLoanBook[i].RemoveAt(0);
allAccountsGrouped = false;
}
}
}
}
catch (Exception ex)
{
}
taskLst = new List <Task>();
for (int i = 0; i < groupedLoanBook.Count; i++)
{
var sub_lstRaw = groupedLoanBook[i];
//var contractIds = sub_LoanBook.Select(o => o.ContractNo).ToList();
//var sub_payment_schedule = payment_schedule.Where(o => contractIds.Contains(o.ContractRefNo)).ToList();
var task = Task.Run(() =>
{
RunLoanBookDistinctFilterJob(sub_lstRaw);
});
taskLst.Add(task);
}
while (0 < 1)
{
if (taskLst.All(o => tskStatusLst.Contains(o.Status)))
{
break;
}
//Do Nothing
}
//newLoanBook = lstRaw;
//Console.WriteLine($"Done with all conversion Output C**t: {newLoanBook.Select(o=>o.ContractId).Distinct().Count()} MainList Count : {lstRaw.Select(o=>o.ContractId).Distinct().Count()} Raw Count : {_lstRaw.Rows.Count} - {DateTime.Now}");
return(newLoanBook);
}
public bool ProcessCalibration(Guid calibrationId, long affiliateId)
{
var baseAffPath = Path.Combine(Util.AppSettings.CalibrationModelPath, affiliateId.ToString());
if (!Directory.Exists(baseAffPath))
{
Directory.CreateDirectory(baseAffPath);
}
var qry = Queries.CalibrationInput_EAD_Behavioural_Terms(calibrationId);
var _dt = DataAccess.i.GetData(qry);
//DataView dv = _dt.DefaultView;
//dv.Sort = "Account_No,Contract_No,Snapshot_Date";
var dt = _dt;// dv.ToTable();
var rowCount = dt.Rows.Count + 1;
if (dt.Rows.Count == 0)
{
return(true);
}
var counter = Util.AppSettings.GetCounter(dt.Rows.Count + 48);
var path = $"{Path.Combine(Util.AppSettings.CalibrationModelPath, counter.ToString(), "EAD_Behavioural_Term.xlsx")}";
var path1 = $"{Path.Combine(baseAffPath, $"{Guid.NewGuid().ToString()}_EAD_Behavioural_Term.xlsx")}";
var path2 = $"{Path.Combine(baseAffPath)}";
Log4Net.Log.Info(path);
if (File.Exists(path1))
{
try { File.Delete(path1); } catch { };
}
Log4Net.Log.Info($"Output File Path - {path1}");
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(path)))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[2];//.FirstOrDefault();
Log4Net.Log.Info("Read Base File");
// get number of rows in the sheet
int rows = worksheet.Dimension.Rows; // 10
//for (int i = 0; i < dt.Rows.Count - 48; i++)
//{
// worksheet.InsertRow(1, 1, 2);
//}
//1 is for header
//48 is for computation done on the excel
worksheet.DeleteRow(dt.Rows.Count + 1 + 48, rows - (dt.Rows.Count + 1));
// loop through the worksheet rows
//var result_=worksheet.Cells[3, 1,34,3].Value;
package.Workbook.CalcMode = ExcelCalcMode.Automatic;
for (int i = 0; i < dt.Rows.Count; i++)// DataRow dr in dt.Rows)
{
Log4Net.Log.Info(i);
DataRow dr = dt.Rows[i];
var itm = DataAccess.i.ParseDataToObject(new EAD_Behavioural_Terms_Data(), dr);
if (string.IsNullOrEmpty(itm.Account_No) && string.IsNullOrEmpty(itm.Contract_No) && itm.Snapshot_Date == null)
{
continue;
}
worksheet.Cells[i + 2, 1].Value = itm.Customer_No ?? "";
worksheet.Cells[i + 2, 2].Value = itm.Account_No ?? "";
worksheet.Cells[i + 2, 3].Value = itm.Contract_No ?? "";
worksheet.Cells[i + 2, 4].Value = itm.Customer_Name ?? "";
if (!itm.Snapshot_Date.ToString().Contains("0001"))
{
worksheet.Cells[i + 2, 5].Value = itm.Snapshot_Date;
}
worksheet.Cells[i + 2, 6].Value = itm.Classification ?? "";
worksheet.Cells[i + 2, 7].Value = itm.Original_Balance_Lcy;
worksheet.Cells[i + 2, 8].Value = itm.Outstanding_Balance_Lcy;
worksheet.Cells[i + 2, 9].Value = itm.Outstanding_Balance_Acy;
if (!itm.Contract_Start_Date.ToString().Contains("0001"))
{
worksheet.Cells[i + 2, 10].Value = itm.Contract_Start_Date;
}
if (!itm.Contract_End_Date.ToString().Contains("0001"))
{
worksheet.Cells[i + 2, 11].Value = itm.Contract_End_Date;
}
try { worksheet.Cells[i + 2, 12].Value = Convert.ToDouble(itm.Restructure_Indicator); } catch { worksheet.Cells[i + 2, 12].Value = 0; }
worksheet.Cells[i + 2, 13].Value = itm.Restructure_Type ?? "";
worksheet.Cells[i + 2, 14].Value = itm.Restructure_Start_Date; // == null ? "" : itm.Restructure_Start_Date;
worksheet.Cells[i + 2, 15].Value = itm.Restructure_End_Date; // == null ? "" : itm.Restructure_End_Date;
}
Log4Net.Log.Info("Writing Output File");
var fi = new FileInfo(path1);
if (Directory.Exists(baseAffPath))
{
var att1 = fi.Attributes.HasFlag(FileAttributes.ReadOnly);
var attr2 = new DirectoryInfo(baseAffPath).Attributes.HasFlag(FileAttributes.ReadOnly);
var accessControlList = Directory.GetAccessControl(baseAffPath);
var accessRules = accessControlList.GetAccessRules(true, true,
typeof(System.Security.Principal.SecurityIdentifier));
foreach (FileSystemAccessRule rule in accessRules)
{
if ((FileSystemRights.Write & rule.FileSystemRights) != FileSystemRights.Write)
{
break;
}
//if (rule.AccessControlType == AccessControlType.Allow)
// //writeAllow = true;
//else if (rule.AccessControlType == AccessControlType.Deny)
// writeDeny = true;
}
}
package.SaveAs(fi);
Log4Net.Log.Info("Done Writing Output File");
}
string txtLocation = Path.GetFullPath(path1);
object _missingValue = System.Reflection.Missing.Value;
Application excel = new Application();
var theWorkbook = excel.Workbooks.Open(txtLocation,
_missingValue,
false,
_missingValue,
_missingValue,
_missingValue,
true,
_missingValue,
_missingValue,
true,
_missingValue,
_missingValue,
_missingValue);
try
{
//Sort
Worksheet calculationSheet = theWorkbook.Sheets[3];
Range sortRange = calculationSheet.Range["A2", "O" + rowCount.ToString()];
//sortRange.Sort(sortRange.Columns[9], DataOption1: XlSortDataOption.xlSortTextAsNumbers);
sortRange.Sort(sortRange.Columns[5], DataOption1: XlSortDataOption.xlSortTextAsNumbers); //Snapshot date
sortRange.Sort(sortRange.Columns[3], XlSortOrder.xlDescending, DataOption1: XlSortDataOption.xlSortTextAsNumbers); //Contract No: 3; Account No: 2;
//refresh and calculate to modify
theWorkbook.RefreshAll();
excel.Calculate();
Log4Net.Log.Info("Reading Output File");
Worksheet worksheet1 = theWorkbook.Sheets[1];
Log4Net.Log.Info("Read Sheet 1 of File");
var Assumption_NonExpired = "";
try { Assumption_NonExpired = worksheet1.Cells[10, 3].Value.ToString(); } catch { }
if (Assumption_NonExpired.ToLower().Contains("data"))
{
//Assumption_NonExpired = "0";
Assumption_NonExpired = "0";// new Random().Next(2, 25).ToString();
}
var Freq_NonExpired = "";
try { Freq_NonExpired = worksheet1.Cells[10, 4].Value.ToString(); } catch { }
var Assumption_Expired = "";
try { Assumption_Expired = worksheet1.Cells[11, 3].Value.ToString(); } catch { }
if (Assumption_Expired.ToLower().Contains("data"))
{
//Assumption_Expired = "0";
Assumption_Expired = "0";// new Random().Next(2, 45).ToString();
}
var Freq_Expired = "";
try { Freq_Expired = worksheet1.Cells[11, 4].Value.ToString(); } catch { }
theWorkbook.Save();
theWorkbook.Close(true);
excel.Quit();
//File.Delete(path1);
qry = Queries.CalibrationResult_EAD_Behavioural_Terms_Update(calibrationId, Assumption_NonExpired, Freq_NonExpired, Assumption_Expired, Freq_Expired);
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Error(ex);
theWorkbook.Save();
theWorkbook.Close(true);
excel.Quit();
}
return(true);
}
public virtual async Task DeleteFromDatabaseAsync()
{
var affectedRows = await DBFactory.GetMySqlDatabase().ExecuteNonQueryAsync(Queries.DeleteMapObject(this));
if (affectedRows != 1)
{
throw new Exception("Error occured during delete. The number of affected rows was unexpected.");
}
}
public double GetQueryCount()
{
return(Queries.Sum(l => l.QueryCount));
}
private async void LoadWriters()
{
List <Writer> writers = await _con.QueryAsync <Writer>(Queries.GetAllWriters());
lstWriter.ItemsSource = writers;
}
public void SaveSetting()
{
Common.Setting.Queries = Queries.ToArray();
Common.SetJsonObject("Setting.json", Common.Setting);
}
public override void UpdateDatabaseTables(int version)
{
Queries.UpdateDatabaseTables(version);
}
public override void CreateDatabaseTablesIfNotExist()
{
Queries.CreateWindowsActivityTable();
}
protected async Task LoadCategoryAsync(IKey categoryKey)
{
Summaries = null;
Summaries = await Queries.QueryAsync(new ListYearOutcomesForCategory(categoryKey, new YearModel(2015)));
}
public async Task GetCharacter(SocketGuildUser user)
{
await Check();
List <Hero> characters = new List <Hero>();
SqliteCommand getHero = new SqliteCommand(Queries.GetCharacter(Context.Guild.Id, user.Id), Program.sqliteConnection);
using (SqliteDataReader reader = getHero.ExecuteReader())
{
if (reader.HasRows)
{
foreach (DbDataRecord record in reader)
{
characters.Add(new Hero
{
name = Convert.ToString(record["CHAR_NAME"]),
owner = Convert.ToUInt64(record["CHAR_OWNER"]),
description = Convert.ToString(record["DESCRIPTION"])
});
}
}
else
{
await Context.Channel.SendMessageAsync(Language(21));
return;
}
}
if (characters.Count == 1)
{
EmbedBuilder builder = new EmbedBuilder();
SocketUser guy = Context.Guild.GetUser(characters[0].owner);
builder
.WithColor(Color.DarkBlue)
.WithTitle(characters[0].name)
.WithDescription(characters[0].description + Language(20) + user.Mention);
if (characters[0].image != null)
{
builder.WithImageUrl(characters[0].image);
}
await Context.Channel.SendMessageAsync("", false, builder.Build());
}
else
{
string list = "";
characters.OrderBy(x => x.name).ToList();
foreach (Hero hero in characters)
{
list += hero.name;
list += "\n";
}
EmbedBuilder builder = new EmbedBuilder();
builder
.WithDescription(list + $"\n\n{user.Mention}")
.WithColor(Color.Blue)
.WithTitle(Language(22));
await Context.Channel.SendMessageAsync("", false, builder.Build());
}
}
public virtual async Task <DataMapObject> FromDatabaseAsync()
{
// Get a fresh copy of the object from the DB.
using (var results = await DBFactory.GetMySqlDatabase().DataTableFromQueryStringAsync(Queries.SelectMapObject(this)))
{
var newObj = Activator.CreateInstance(this.GetType(), new object[] { results });
return((DataMapObject)newObj);
}
}
public async Task Mute(SocketGuildUser user, string timer, [Remainder] string reason = null)
{
if (user.IsBot)
{
await Context.Message.DeleteAsync();
return;
}
char[] a;
a = timer.ToCharArray();
char[] b = new char[a.Count() - 1];
for (int i = 0; i < b.Count(); i++)
{
b[i] = a[i];
}
char time = a.Last();
string c = new string(b);
int muteTime = Convert.ToInt32(c);
int show = muteTime;
string longitud;
switch (time)
{
case 'm': longitud = Language(50); break;
case 'h': muteTime *= 60; longitud = Language(51); break;
case 'd': muteTime *= 1440; longitud = Language(52); break;
case 'w': muteTime *= 10080; longitud = Language(53); break;
case 'y': muteTime *= 3679200; longitud = Language(54); break;
default: return;
}
await Context.Channel.SendMessageAsync("🔇 " + user.Mention + Language(55) + show + " " + longitud + "**");
var role = Context.Guild.Roles.FirstOrDefault(x => x.Name == "Muted");
SqliteCommand command = new SqliteCommand(Queries.AddMute(Context.Guild.Id, user.Id, (ulong)muteTime), Program.sqliteConnection);
await command.ExecuteNonQueryAsync();
await user.AddRoleAsync(role);
if ((Context.Channel as IGuildChannel).GetPermissionOverwrite(role) == null)
{
await Program.AddChannelRestr(Context.Guild);
}
var ls = await user.GetOrCreateDMChannelAsync();
EmbedBuilder builder = new EmbedBuilder();
if (reason == null)
{
reason = Language(56);
}
builder.WithTitle(Language(57))
.WithDescription(Language(58) + Context.Guild.Name + Language(59) + show + " " + longitud + Language(60) + reason)
.WithColor(Color.Red)
.WithThumbnailUrl("https://media.discordapp.net/attachments/603600328117583874/615150515709411357/ezgif.com-gif-maker_31.gif")
.WithCurrentTimestamp();
await ls.SendMessageAsync("", false, builder.Build());
}
static void Main(string[] args)
{
var sqlBookQuery = Queries.SetConnectionStringForBooks();
var works = sqlBookQuery.GetBooksByAuthorName("Phillip");
}
public ItemForm()
{
InitializeComponent();
queries = new Queries();
}
public void SetAdmin()
{
Queries queries = new Queries();
queries.ClearTargets();
}
public override void CreateDatabaseTablesIfNotExist()
{
Queries.CreateUserEfficiencyTables();
}
public ActivitiesView(TGFCContext _ctx, IEnumerable <Claim> _claims)
{
CurrentUser = Queries.GetUserByClaims(_ctx, _claims);
Disciplines = Queries.GetAllDisciplines(_ctx);
ActivityTypes = Queries.GetAllActivityTypes(_ctx);
}
public Query LoadQueryById2(Guid?id)
{
var q = Queries.SingleOrDefault(cc => cc.QueryId == id);
return(q);
}
public void UpdateSettings(SettingsData settingsData)
{
settingsData.WebQuerySettings = Queries.ToArray();
}
private static Dictionary <string, object> CreateQueryNames()
{
return(Queries.GetQueryNames().ToDictionaryEx(qn => QueryUtils.GetKey(qn), "queryName"));
}
/// <summary>
/// Obtient toutes les données du projet spécifié.
/// </summary>
/// <param name="projectId">L'identifiant du projet.</param>
public virtual async Task <RestitutionData> GetFullProjectDetails(int projectId) =>
await Task.Run(async() =>
{
using (var context = ContextFactory.GetNewContext(_securityContext.CurrentUser, _localizationManager))
{
IDictionary <ProcessReferentialIdentifier, bool> referentialsUsed = await _sharedScenarioActionsOperations.GetReferentialsUse(context, projectId);
Referentials referentials = await Queries.LoadAllReferentialsOfProject(context, projectId, referentialsUsed);
//await context.Videos.Where(v => v.ProjectId == projectId).ToArrayAsync();
await context.ScenarioNatures.ToArrayAsync();
await context.ScenarioStates.ToArrayAsync();
await context.ActionTypes.ToArrayAsync();
await context.ActionValues.ToArrayAsync();
Project project = await context.Projects
.Include(nameof(Project.Process))
.Include($"{nameof(Project.Process)}.{nameof(Procedure.Videos)}")
.Include($"{nameof(Project.Process)}.{nameof(Procedure.UserRoleProcesses)}")
.Include($"{nameof(Project.Process)}.{nameof(Procedure.UserRoleProcesses)}.{nameof(UserRoleProcess.User)}")
.Include($"{nameof(Project.Process)}.{nameof(Procedure.UserRoleProcesses)}.{nameof(UserRoleProcess.User)}.{nameof(User.DefaultLanguage)}")
.Include(nameof(Project.Scenarios))
.Include($"{nameof(Project.Scenarios)}.{nameof(Scenario.Actions)}")
.Include(nameof(Project.Objective))
.FirstAsync(s => s.ProjectId == projectId);
project.ScenariosCriticalPath = PrepareService.GetSummary(project, true);
// Scénarios
foreach (Scenario scenario in project.Scenarios.Where(s => s.OriginalScenarioId.HasValue))
{
// Remapper l'original
scenario.Original = project.Scenarios.Single(s => s.ScenarioId == scenario.OriginalScenarioId);
ScenarioCriticalPath matchingCriticalItem = project.ScenariosCriticalPath.FirstOrDefault(i => i.Id == scenario.ScenarioId);
if (matchingCriticalItem != null)
{
matchingCriticalItem.OriginalLabel = scenario.Original.Label;
}
}
ProjectReferential[] projectReferentials = await context.ProjectReferentials.Where(pr => pr.ProjectId == projectId).ToArrayAsync();
User user = await context.Users.FirstAsync(u => u.UserId == project.CreatedByUserId);
ModificationsUsers modificationsUsers = new ModificationsUsers
{
CreatedByFullName = (await context.Users.FirstAsync(u => u.UserId == project.ModifiedByUserId)).FullName,
LastModifiedByFullName = (await context.Users.FirstAsync(u => u.UserId == project.ModifiedByUserId)).FullName
};
Scenario[] scenarios = await context.Scenarios
.Where(s => s.ProjectId == projectId)
.ToArrayAsync();
await Queries.LoadScenariosDetails(context, scenarios, referentialsUsed);
ILookup <int, KAction> actionsToLoad = scenarios
.SelectMany(a => a.Actions)
.Where(a => a.IsReduced && a.OriginalActionId.HasValue)
.ToLookup(a => a.OriginalActionId.Value, a => a);
if (actionsToLoad.Any())
{
foreach (var duration in await _sharedScenarioActionsOperations.GetActionsBuildDurations(context, actionsToLoad.Select(g => g.Key)))
{
foreach (KAction action in actionsToLoad[duration.ActionId])
{
action.Reduced.Saving = duration.BuildDuration - action.BuildDuration;
}
}
}
ScenarioActionHierarchyHelper.MapScenariosActionsOriginals(scenarios);
return(new RestitutionData()
{
Project = project,
ProjectCreatedByUser = user,
Scenarios = scenarios,
ActionCategories = referentials.Categories,
ModificationsUsers = modificationsUsers,
ReferentialsUse = projectReferentials,
});
}
});
/// <summary>
/// Show the query window
/// </summary>
/// <param name="queries"></param>
public void ShowQueryWindow(Queries queries)
{
TraceLog.WriteLine(new StackFrame().GetMethod().Name, "I see there are " + queries.Count() + " queries here.");
var query = new QueryDialog(queries);
query.ShowDialog();
}
/// <summary>Handles errors reported via the teamspeak responses.</summary>
public Boolean performResponseHandling(Queries queryCode)
{
// Exit if we're fine.
if (mTsResponse.Id == "0")
return true;
// Handle "Always Fine" or "Always Fatal" issues.
switch (mTsResponse.Id)
{
case "-1": // Socket was open and we tried to re-establish a connection.
case "-5": // Socket was closed and we tried to send a query.
case "-6": // The query we tried to send was null.
consoleWrite("[Error] ^3Minor Error:");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return true;
case "-2": // Invalid IP Address.
case "-3": // Invalid Port.
case "-4": // Error occurred when trying to establish a connection.
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during establishing a connection to the Teamspeak 3 Server.");
consoleWrite("[Error] ^8Make sure your ^b\"Server Ip\"^n and ^b\"Query Port\"^n are correct.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
if (!mTsReconnecting && errReconnectOnError && performReconnect()) return true;
setPluginState(false);
return false;
case "-7": // Error occurred during sending the query.
case "-8": // Error occurred during receiving the response.
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during sending and receiving data to the Teamspeak 3 Server.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
if (!mTsReconnecting && errReconnectOnError && performReconnect()) break;
setPluginState(false);
return false;
case "3329": // You are temp banned from the server for flooding.
case "3331": // You are temp banned from the server for 'x' seconds.
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8You were temporarily banned from the Teamspeak 3 Server for flooding.");
consoleWrite("[Error] ^8Make sure your ^bProcon's Ip^n is in your ^bTeamspeak 3 Server's Whitelist^n.");
consoleWrite("[Error] ^8{0}: {1} ({2})", mTsResponse.Id, mTsResponse.Message, mTsResponse.ExtraMessage);
setPluginState(false);
return false;
}
// Handle "Program Position Specific" issues.
switch (queryCode)
{
// -- Perform Open Connection ---------------------------------
case Queries.OpenConnectionEstablish:
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during establishing a connection to the Teamspeak 3 Server.");
consoleWrite("[Error] ^8Make sure your ^b\"Server Ip\"^n and ^b\"Query Port\"^n are correct.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
setPluginState(false);
return false;
case Queries.OpenConnectionLogin:
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during logging into the Teamspeak 3 Server.");
consoleWrite("[Error] ^8Make sure your ^b\"Query Username\"^n and ^b\"Query Password\"^n are correct.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
setPluginState(false);
return false;
case Queries.OpenConnectionUse:
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during finding the virtual server.");
consoleWrite("[Error] ^8Make sure your ^b\"Server Port\"^n is correct.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
setPluginState(false);
return false;
case Queries.OpenConnectionStaging:
consoleWrite("[Error] ^8Fatal Error:");
consoleWrite("[Error] ^8An error occurred during finding the staging channel.");
consoleWrite("[Error] ^8Make sure your ^b\"Staging Channel Name\"^n is correct and that the channel exists in the Teamspeak 3 Server.");
consoleWrite("[Error] ^8{0}: {1}", mTsResponse.Id, mTsResponse.Message);
setPluginState(false);
return false;
case Queries.OpenConnectionNickname:
consoleWrite("[Error] ^3Minor Error:");
consoleWrite("[Error] ^3An error occurred during changing the server query nickname.");
consoleWrite("[Error] ^3Make sure your ^b\"Query Nickname\"^n is not already in use.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return true;
// -- Update Teamspeak Information ----------------------------
case Queries.TsInfoClientList:
consoleWrite("[Error] ^3Minor Error - Update Teamspeak Information:");
consoleWrite("[Error] ^3An error occurred during obtaining the Teamspeak Client List.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.TsInfoChannelList:
consoleWrite("[Error] ^3Minor Error - Update Teamspeak Information:");
consoleWrite("[Error] ^3An error occurred during obtaining the Teamspeak Channel List.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.TsInfoClientInfo:
consoleWrite("[Error] ^3Minor Error - Update Teamspeak Information:");
consoleWrite("[Error] ^3An error occurred during obtaining an Advanced Client Information.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return true;
// -- Check Client for Swapping/Removing ----------------------
case Queries.CheckSwapStaging:
consoleWrite("[Error] ^3Minor Error - Check Client for Swapping/Removing:");
consoleWrite("[Error] ^3An error occurred during moving a client to the staging channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CheckSwapTeam:
consoleWrite("[Error] ^3Minor Error - Check Client for Swapping/Removing:");
consoleWrite("[Error] ^3An error occurred during moving a client to a team channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CheckSwapSquad:
consoleWrite("[Error] ^3Minor Error - Check Client for Swapping/Removing:");
consoleWrite("[Error] ^3An error occurred during moving a client to a squad channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CheckRemove:
consoleWrite("[Error] ^3Minor Error - Check Client for Swapping/Removing:");
consoleWrite("[Error] ^3An error occurred during removing a client to the staging channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
// -- Find or Create Channels ---------------------------------
case Queries.FindTeamChannelList:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during obtaining the Teamspeak Channel List while looking for a team channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.FindSquadChannelList:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during obtaining the Teamspeak Channel List while looking for a squad channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CreateTeamChannelQuery:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during creating a team channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CreateTeamChannelInfo:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during requesting advanced information about the new team channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CreateSquadChannelQuery:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during creating a squad channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.CreateSquadChannelInfo:
consoleWrite("[Error] ^3Minor Error - Find or Create Channels:");
consoleWrite("[Error] ^3An error occurred during requesting advanced information about the new squad channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
// -- Remove Channels -----------------------------------------
case Queries.RemoveChannelsList:
consoleWrite("[Error] ^3Minor Error - Remove Channels:");
consoleWrite("[Error] ^3An error occurred during obtaining the Teamspeak Channel List.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return false;
case Queries.RemoveChannelsTeamQuery:
consoleWrite("[Error] ^3Minor Error - Remove Channels:");
consoleWrite("[Error] ^3An error occurred during removing a team channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return true;
case Queries.RemoveChannelsSquadQuery:
consoleWrite("[Error] ^3Minor Error - Remove Channels:");
consoleWrite("[Error] ^3An error occurred during removing a squad channel.");
consoleWrite("[Error] ^3{0}: {1}", mTsResponse.Id, mTsResponse.Message);
return true;
}
// Don't know what went wrong?
return true;
}
protected override void OnCreate(Bundle savedInstanceState)
{
firebaseAnalytics = FirebaseAnalytics.GetInstance(this);
base.OnCreate(savedInstanceState);
Localise.SetLayoutDirectionByCulture(this);
SetContentView(Resource.Layout.login);
SupportActionBar.Title = StringResources.login_ui_title;
SupportActionBar.SetDisplayHomeAsUpEnabled(true);
var submit = FindViewById <AppCompatButton>(Resource.Id.submit);
submit.Text = StringResources.login_ui_submit_button;
// Have to manually change hints on input layout.
var _email = FindViewById <TextInputLayout>(Resource.Id.emailTextInput);
_email.Hint = StringResources.common_ui_forms_email_label;
var _password = FindViewById <TextInputLayout>(Resource.Id.passwordTextInput);
_password.Hint = StringResources.common_ui_forms_password_label;
FindViewById <TextInputEditText>(Resource.Id.password).EditorAction += (_, e) =>
{
e.Handled = false;
if (e.ActionId == Android.Views.InputMethods.ImeAction.Done)
{
FindViewById <AppCompatButton>(Resource.Id.submit).PerformClick();
e.Handled = true;
}
};
submit.Click += async delegate
{
var imm = (Android.Views.InputMethods.InputMethodManager)GetSystemService(InputMethodService);
imm.HideSoftInputFromWindow(FindViewById <TextInputEditText>(Resource.Id.password).WindowToken, 0);
var email = FindViewById <AppCompatEditText>(Resource.Id.email);
var passw = FindViewById <AppCompatEditText>(Resource.Id.password);
if (string.IsNullOrWhiteSpace(email.Text))
{
email.Error = StringResources.common_ui_forms_email_validate_empty;
email.RequestFocus();
}
else if (string.IsNullOrWhiteSpace(passw.Text))
{
passw.Error = StringResources.common_ui_forms_password_validate_empty;
passw.RequestFocus();
}
else if (!Android.Util.Patterns.EmailAddress.Matcher(email.Text).Matches())
{
email.Error = StringResources.common_ui_forms_email_validate_invalid;
email.RequestFocus();
}
else
{
FindViewById <ProgressBar>(Resource.Id.progressBar).Visibility = ViewStates.Visible;
FindViewById <AppCompatButton>(Resource.Id.submit).Enabled = false;
LOG_EVENT_WITH_ACTION("LOGIN", "ATTEMPT");
var response = await RestClient.Login(email.Text.ToLower(), passw.Text);
if (response.Meta.Messages.Count > 0)
{
LOG_EVENT_WITH_ACTION("LOGIN", "ERROR");
RunOnUiThread(() =>
{
response.Meta.Messages.ForEach(MakeError);
FindViewById <AppCompatButton>(Resource.Id.submit).Enabled = true;
FindViewById <ProgressBar>(Resource.Id.progressBar).Visibility = ViewStates.Gone;
});
}
// If there are no errors, then tokens exist as the request was a great success.
else if (!string.IsNullOrEmpty(response.Data?.Tokens.Access))
{
LOG_EVENT_WITH_ACTION("LOGIN", "SUCCESS");
// When the application is closed, the ActiveUser is reset. The username and tokens
// are used to build a new active user.
var prefs = PreferenceManager.GetDefaultSharedPreferences(ApplicationContext);
// Used in MainActivity to determine if a user has logged in.
prefs.Edit().PutString("username", email.Text).Commit();
prefs.Edit().PutString("tokens", JsonConvert.SerializeObject(response.Data.Tokens)).Commit();
// Set active user on login/register as the user object is in the response.
// This prevents us from storing a user object in local storage.
Queries.SetActiveUser(response.Data);
FirebaseAnalytics.GetInstance(this).SetUserId(Session.ActiveUser.Id.ToString());
// We do not want the user to return to ANY gabber recording pages once captured.
var intent = new Intent(this, typeof(MainActivity));
intent.SetFlags(ActivityFlags.ClearTop | ActivityFlags.ClearTask | ActivityFlags.NewTask);
StartActivity(intent);
// Prevent returning to login once authenticated.
Finish();
}
}
};
_email.RequestFocus();
Window.SetSoftInputMode(SoftInput.StateAlwaysVisible);
}
public static List <QueryEntity> GetTypeQueries(TypeEntity typeEntity)
{
Type type = TypeLogic.GetType(typeEntity.CleanName);
return(Queries.GetTypeQueries(type).Keys.Select(GetQueryEntity).ToList());
}
protected async override Task OnInitializedAsync()
{
await base.OnInitializedAsync();
Categories = await Queries.QueryAsync(new ListAllCategory());
}
protected void bulkApply_Click(object sender, EventArgs e)
{
if (UsersRW.Contains(user))
{
Dictionary <string, string> Params = new Dictionary <string, string>();
Params.Add("WebOwnerCondition", "IS NULL");
Params.Add("WebStoreName", storeDDL.SelectedValue);
Params.Add("WebArchiveSet", "0");
Params.Add("WebArchiveWhere", "0");
Params.Add("WebQtyLogicalOP", opDDL.SelectedValue);
Params.Add("WebQtyWhere", opTXT.Text);
Params.Add("WebStartDate", webStartDate.SelectedValue);
Params.Add("WebStoreNumber", StoreNumberTXT.Text.Trim() == "" ? "NULL" : StoreNumberTXT.Text.Trim());
Params.Add("WebSalesDate", saleDate.Text.Trim() == "" ? "NULL" : saleDate.Text.Trim());
Params.Add("Action", "BULKUPDATE");
switch (bulkDDL.SelectedValue)
{
case "update":
if (colDDL.SelectedValue == "Qty")
{
Params.Add("WebQtySet", newVal.Text.Replace("'", ""));
}
else
{
Params["Web" + colDDL.SelectedValue] = newVal.Text.Replace("'", "");
}
break;
case "pending":
Params.Add("WebProgramSet", "");
break;
case "misc":
Params.Add("WebProgramSet", "Misc");
break;
case "return":
Params.Add("WebProgramSet", "Return");
break;
case "archive":
Params["WebArchiveSet"] = "1";
break;
}
switch (viewDDL.SelectedValue)
{
case "Pending":
Params.Add("WebProgramWhere", " NOT IN ('Return', 'Misc')");
break;
case "Return":
Params.Add("WebProgramWhere", " = 'Return'");
break;
case "Misc":
Params.Add("WebProgramWhere", " = 'Misc'");
break;
case "Archive":
Params["WebArchiveWhere"] = "1";
break;
}
if (bulkDDL.SelectedValue != "")
{
Queries.ExecuteFromStoreProcedure("spx_PAYOUTsales", Params);
}
salesGrid.DataBind();
}
}
/// <summary>
/// Returns queries for a particular worksheet
/// </summary>
/// <param name="sheet"></param>
/// <returns></returns>
public Queries QueriesForSheet(string sheet)
{
if(!_sheets.ContainsKey(sheet))
{
var queries = new Queries(sheet, Projects, _defaultQuery);
queries.Fetch += Run;
queries.Save += Save;
_sheets[sheet] = queries;
}
return _sheets[sheet];
}
