public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
[CosmosDB("vnaaats-net", "fixes",
ConnectionStringSetting = "DbConnectionString")] IAsyncCollector <object> fixes,
ILogger log)
{
try {
// Get name
string name = "";
if (!string.IsNullOrWhiteSpace(req.Query["name"]))
{
name = req.Query["name"].ToString().ToUpper();
}
// Get lat
string lat = "0.0";
if (!string.IsNullOrWhiteSpace(req.Query["lat"]) &&
double.TryParse(req.Query["lat"], out var res))
{
lat = res.ToString();
}
// Get lon
string lon = "0.0";
if (!string.IsNullOrWhiteSpace(req.Query["lon"]) &&
double.TryParse(req.Query["lon"], out var res1))
{
lon = res1.ToString();
}
// Catch bad format
if (name == "" || lat == "0.0" || lon == "0.0")
{
return(new BadRequestObjectResult("Invalid request. Ensure correct format: ?name=[string]&lat=[double]&lon=[double]."));
}
// We got here so generate new fix and add data object
DBFix fix = new DBFix(name, lat, lon);
await fixes.AddAsync(fix);
// Log and return success code
//log.LogInformation();
return(new OkObjectResult($"Fix successfully added.\nName: {fix.name} \nLatitude: {fix.latitude}\nLongitude: {fix.longitude}"));
}
catch (Exception ex)
{
// Catch any errors
log.LogError($"Could not insert waypoint. Exception thrown: {ex.Message}.");
return(new StatusCodeResult(StatusCodes.Status500InternalServerError));
}
}
public void Distribute(bool SelFlag, IData data)
{
if ((!SelFlag || (this.dgvDataView.SelectedRows.Count > 0)) || (data != null))
{
StringList sl = new StringList();
IData data2 = null;
List<string> lst = new List<string>();
if (SelFlag)
{
for (int i = 0; this.dgvDataView.SelectedRows.Count > i; i++)
{
lst.Add(this.dgvDataView.SelectedRows[i].Cells["clmID"].Value.ToString());
}
}
bool flag = data == null;
if (flag)
{
this.drProgress = new DeleteRestore(12);
this.drProgress.Show();
this.drProgress.Refresh();
}
try
{
string str;
DataRow[] rowArray;
IData data3 = null;
if (data == null)
{
DBFix dBFixStr = new DBFix {
JobCode = "",
OutCode = "",
UserCode = "",
Open = "1"
};
str = this.FixListString(dBFixStr, SelFlag, data, lst);
rowArray = this.dtsDataView.Tables["NACCS"].Select(str);
if (rowArray.Length == 0)
{
return;
}
this.drProgress.pgbRestore.Minimum = 0;
this.drProgress.pgbRestore.Maximum = rowArray.Length;
for (int k = 0; k < rowArray.Length; k++)
{
this.drProgress.pgbRestore.Value = k + 1;
this.drProgress.Refresh();
if (rowArray[k]["clFolder"].ToString() != "")
{
if (!this.ExistCheck(sl, rowArray[k]["clFolder"].ToString()))
{
sl.Add(rowArray[k]["clFolder"].ToString());
}
rowArray[k]["clFolder"] = "";
data3 = this.GetData(int.Parse(rowArray[k]["clID"].ToString()));
if (data3 == null)
{
rowArray[k].Delete();
}
else
{
data3.UserFolder = "";
this.DataViewDataSave(data3, rowArray[k]["clFileName"].ToString());
}
}
}
this.dtsDataView.AcceptChanges();
}
for (int j = this.DBFixList.Count - 1; j > -1; j--)
{
for (int m = 0; m < this.DBFixList.Count; m++)
{
if (this.DBFixList[m].Priority == (j + 1))
{
str = this.FixListString(this.DBFixList[m], SelFlag, data, lst);
rowArray = this.dtsDataView.Tables["NACCS"].Select(str);
if (rowArray.Length != 0)
{
if (flag)
{
this.drProgress.pgbRestore.Minimum = 0;
this.drProgress.pgbRestore.Maximum = rowArray.Length;
}
for (int n = 0; n < rowArray.Length; n++)
{
if (flag)
{
this.drProgress.pgbRestore.Value = n + 1;
this.drProgress.Refresh();
}
if ((this.FOpenViewFlag && (rowArray[n]["clOpen"].ToString() == "0")) && (rowArray[n]["clFolder"].ToString() != this.DBFixList[m].Folder))
{
if ((rowArray[n]["clFolder"].ToString() != "") && !this.ExistCheck(sl, rowArray[n]["clFolder"].ToString()))
{
sl.Add(rowArray[n]["clFolder"].ToString());
}
if (!this.ExistCheck(sl, this.DBFixList[m].Folder))
{
sl.Add(this.DBFixList[m].Folder);
}
}
rowArray[n]["clFolder"] = this.DBFixList[m].Folder;
data2 = this.GetData(int.Parse(rowArray[n]["clID"].ToString()));
if (data2 == null)
{
rowArray[n].Delete();
}
else
{
data2.UserFolder = this.DBFixList[m].Folder;
this.DataViewDataSave(data2, rowArray[n]["clFileName"].ToString());
}
}
this.dtsDataView.AcceptChanges();
}
}
}
}
}
finally
{
this.dgvDataView.Refresh();
this.stpCount();
if (this.FOpenViewFlag)
{
this.ViewCountCheck(true);
}
if (flag)
{
this.drProgress.Close();
this.drProgress.Dispose();
}
}
}
}
private string FixListString(DBFix DBFixStr, bool SelFlag, IData data, List<string> lst)
{
StringBuilder builder = new StringBuilder();
builder.Append("clStatus = 'r' AND clDelete = 0");
if (DBFixStr.JobCode != "")
{
builder.Append(" AND clJobCode = '").Append(DBFixStr.JobCode).Append("'");
}
if (DBFixStr.OutCode != "")
{
builder.Append(" AND clOutCode Like '%").Append(DBFixStr.OutCode).Append("%'");
}
if (DBFixStr.UserCode != "")
{
builder.Append(" AND clUserCode Like '%").Append(DBFixStr.UserCode).Append("%'");
}
if (DBFixStr.Open == "0")
{
builder.Append(" AND clOpen = '1'");
}
if (SelFlag)
{
builder.Append(" AND clID IN (");
for (int i = 0; lst.Count > i; i++)
{
builder.Append(lst[i]).Append(',');
}
if (builder[builder.Length - 1] == ',')
{
builder.Remove(builder.Length - 1, 1);
}
builder.Append(")");
}
else if (data != null)
{
builder.Append(" AND clID IN (").Append(data.ID).Append(")");
}
return builder.ToString();
}
private void DBFixAdd()
{
this.DBFixList.Clear();
for (int i = 0; i < this.trmlist.Count; i++)
{
DBFix item = new DBFix {
ID = this.trmlist[i].Id,
Priority = this.trmlist[i].Priority,
UserCode = this.trmlist[i].UserCode,
JobCode = this.trmlist[i].JobCoode,
OutCode = this.trmlist[i].OutCode,
Folder = this.trmlist[i].Folder
};
if (this.trmlist[i].UnOpen)
{
item.Open = "1";
}
else
{
item.Open = "0";
}
this.DBFixList.Add(item);
}
}
