public async Task <IActionResult> Edit(int id, [Bind("Queryid,Name,Email,Contact,Message")] query query)
{
if (id != query.Queryid)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(query);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!queryExists(query.Queryid))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(query));
}
public MainForm()
{
InitializeComponent();
//DateTime sdf = DateTime. // Parse edilmiş string datetime olduktan sonra, messagebox içinde göstermek için tostring yaptığımızda, formatı özellikle
// değiştiriyor olabilir. Tostring yapıp mesaj içinde göstermek yerine, yapmak istediğimiz compare işlemin gerçekleştirip çalışıp çalışmadığına bakalım.
DateTime.TryParseExact(now, "h:mm tt", CultureInfo.InvariantCulture, 0, out dtNowParsed);
//MessageBox.Show("now: " + now + "\r\ndtNow: " + dtNowParsed.ToString("hh:mm tt", CultureInfo.InvariantCulture));
XmlSerializer xmlDeserialize = new XmlSerializer(typeof(query));
try
{
var request = (HttpWebRequest)WebRequest.Create("https://query.yahooapis.com/v1/public/yql");
var parameter1 = "q=select * from weather.forecast where woeid in (select woeid from geo.places(1) where text=%22Pendik, istanbul%22) and u=%22c%22&env=store://datatables.org/alltableswithkeys";
var data = Encoding.UTF8.GetBytes(parameter1);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = data.Length;
using (var stream = request.GetRequestStream())
{
stream.Write(data, 0, data.Length);
}
var response = (HttpWebResponse)request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream());
string responseString = reader.ToString();
object obj = xmlDeserialize.Deserialize(reader);
xmlData = (query)obj;
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void ThenTheFollowingTasksExistInTheProject(Table table)
{
var q = new query($"Select name from task where Project = '{Context.ProjectId}'");
var results = Context.Api.ExecuteQuery(q);
Assert.True((results.Error == null), results.Error);
var actual = TestHelper.ToList<ClarizenEntity>(results.Data.entities);
table.CompareToSet(actual);
}
public void UpdateRates(query currentExchangeRate, query lastExchangeRate)
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("");
Console.WriteLine("-----------------Subscriber - 2-----------------");
Console.WriteLine("------------------------------------------------");
DisplayUpdates(currentExchangeRate, lastExchangeRate);
}
public void ThenThereAreAdminUsers(int expectedAdminUserCount)
{
var query = new query("SELECT DisplayName, Admin FROM user where admin = 1");
var results = Context.Api.ExecuteQuery(query);
Assert.True((results.Error == null), results.Error);
Assert.Equal((int)expectedAdminUserCount, (int)results.Data.entities.Length);
}
public async Task <IActionResult> Create([Bind("Queryid,Name,Email,Contact,Message")] query query)
{
if (ModelState.IsValid)
{
_context.Add(query);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(query));
}
private void CekOngkir()
{
var key = MainProgram.rajaOngkirKey; // api key raja ongkir
var baseUrl = "http://api.rajaongkir.com/starter/";
var client = new RestClient();
client.BaseUrl = new Uri(baseUrl);
// versi gratis raja ongkir, hanya mendukung pengecekan jne, tiki dan pos
var listOfKurir = new string[] { "jne", "tiki", "pos" };
_listOfCost.Clear();
foreach (var kurir in listOfKurir)
{
var request = new RestRequest("cost", Method.POST);
request.AddHeader("key", key);
request.AddHeader("content-type", "application/x-www-form-urlencoded");
var query = new query
{
origin = _kabupatenAsal.kabupaten_id.ToString(),
destination = _kabupatenTujuan.kabupaten_id.ToString(),
weight = (int)NumberHelper.StringToDouble(txtBerat.Text),
courier = kurir
};
request.RequestFormat = DataFormat.Json;
request.AddJsonBody(query);
try
{
var response = client.Execute(request);
var ongkir = JsonConvert.DeserializeObject <root>(response.Content);
if (ongkir.rajaongkir.results[0].costs.Count > 0)
{
foreach (var costs in ongkir.rajaongkir.results[0].costs)
{
costs.kurir_code = kurir.ToUpper();
_listOfCost.Add(costs);
}
}
}
catch
{
}
}
GridListControlHelper.Refresh <costs>(this.gridList, _listOfCost);
base.SetActiveBtnPilih(_listOfCost.Count > 0);
}
Random r = new Random();//Remove this line when checking in real-time
/// <summary>
/// Start up function
/// </summary>
public void initializeService()
{
XElement root = XElement.Load("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDJPY%22,%20%22USDGBP%22,%20%22USDINR%22)&env=store://datatables.org/alltableswithkeys");//Yahoo Api that returns exchange rates as XML document
Console.Clear();
Console.WriteLine("Last updated at : {0}", DateTime.Now.ToString());
currentExchangeRate = (query)CreateObject(root.ToString(), new query());
//Notify observers about the update
notifyObservers();
UpdateExchangeRates();
}
/// <summary>
/// Display updates on the screen.
/// </summary>
/// <param name="objQuery">Updated exchange rates instance</param>
public void DisplayUpdates(query currentExchangeRate, query lastExchangeRate)
{
for (int itemCounter = 0; itemCounter < currentExchangeRate.Items[0].rate.Count(); itemCounter++)
{
Console.ForegroundColor = ConsoleColor.White;
Console.Write("{0} : ", ((queryResultsRate)(currentExchangeRate.Items[0].rate[itemCounter])).Name);
if (lastExchangeRate.Items != null)
{
if (((queryResultsRate)(currentExchangeRate.Items[0].rate[itemCounter])).Rate != ((queryResultsRate)(lastExchangeRate.Items[0].rate[itemCounter])).Rate)
{
Console.ForegroundColor = ConsoleColor.Yellow;
}
}
Console.Write("{0}\n", ((queryResultsRate)(currentExchangeRate.Items[0].rate[itemCounter])).Rate);
}
}
private void 一维分析ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (DBname.dbName == "" || DBname.dbName == "请选择数据库")
{
MessageBox.Show("一维分析之前请先选择数据库!!!");
return;
}
query anaf1 = new query();
//打开一维分析的界面
//if (anaf1.IsDisposed)
// anaf1 = new query();
// 打开新的子窗体
// anaf1.MdiParent = this;
//anaf1.WindowState = FormWindowState.Maximized;
anaf1.Show();
}
public IActionResult display(query m)
{
string sim = m.content;
ISearchResponse <Book> results;
if (!string.IsNullOrWhiteSpace(sim))
{
results = _client.Search <Book>(s => s
.Query(q => q
.Match(t => t
.Field(f => f.Title)
.Query(sim)
)
)
);
}
else
{
return(RedirectToAction("Index", "Home"));
}
return(View(results));
}
public override Task <DeleteUpdateResponse> Update(SetRequest request, ServerCallContext context)
{
string error = "";
int rows = -1;
try
{
query q = QueryGenerator.Update(request.Assembly, request.SystemType, request.JSON, request.TPHType);
rows = DBExecuter.execNonQuery(q.sql, q.paramList);
}
catch (Exception e)
{
error = e.GetBaseException().Message;
}
return(Task.FromResult(
new DeleteUpdateResponse
{
Error = new basicResponse {
ErrorResponse = error
},
RowsAffected = rows
}));;
}
public override Task <InsertResponse> Insert(SetRequest request, ServerCallContext context)
{
string error = "";
int idVal = -1;
try
{
query q = QueryGenerator.Insert(request.Assembly, request.SystemType, request.JSON, request.TPHType);
idVal = (int)DBExecuter.execScalar <int>(q.sql, q.paramList);
}
catch (Exception e)
{
error = e.GetBaseException().Message;
}
return(Task.FromResult(new InsertResponse
{
Error = new basicResponse {
ErrorResponse = error
},
InsertedID = idVal
}));
}
static CZQL()
{
API ClarizenAPI = new API();
if (!ClarizenAPI.Login(ConfigurationManager.AppSettings["username"], ConfigurationManager.AppSettings["password"]))
{
return;
}
IClarizenQuery query = new Query()
.Select("Name,Work")
.From("Task")
.Where("StartDate>2016-12-31 AND StartDate<2017-12-31");
query CZQuery = ClarizenAPI.ExecuteQuery(query);
if (CZQuery.IsCalledSuccessfully)
{
Console.WriteLine("{0} results found", CZQuery.Data.entities.Length);
foreach (dynamic entity in CZQuery.Data.entities)
{
Console.WriteLine("\t{0}\t{1}", entity.id, entity.Name);
}
if (CZQuery.Data.paging.hasMore)
{
Console.WriteLine("There are more records than the ones shown here");
}
}
else
{
Console.WriteLine(CZQuery.Error);
}
if (ClarizenAPI.Logout())
{
Console.WriteLine("{0} API calls made in this session", ClarizenAPI.TotalAPICallsMadeInCurrentSession);
}
}
private void UpdateExchangeRates()
{
try
{
Thread.Sleep(10000); //Wait for 10 seconds between updates
XElement root = XElement.Load("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDJPY%22,%20%22USDGBP%22,%20%22USDINR%22)&env=store://datatables.org/alltableswithkeys"); //Yahoo Api that returns exchange rates as XML document
Console.Clear();
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine("Last updated at : {0}", DateTime.Now.ToString());
lastExchangeRate = currentExchangeRate;
lastExchangeRate.Items[0].rate[r.Next(3)].Rate = "0";//Remove this line when checking in real-time
currentExchangeRate = (query)CreateObject(root.ToString(), currentExchangeRate);
//Notify observers about the update
notifyObservers();
UpdateExchangeRates();//Recursive call
}
catch (Exception)
{
throw;
}
}
query = new ExpressionBuilder(query, ctx.dataContext, key.expression, ctx.lambda.Parameters.ToArray())
public int GetCardbyCode(string referencedClassName, string code)
{
int returnvalue = 0;
var myQuery = new query();
var fil = new filter
{
@operator = "LIKE",
name = "Code",
value = new string[] { "%" + code + "%" }
};
myQuery.filter = fil;
var cardfound = _clientconnection.getCardList(referencedClassName, null, myQuery, null, 1, 0, null, null);
if (cardfound.cards != null)
{
var r = cardfound.cards.FirstOrDefault();
returnvalue = r.id;
}
return returnvalue;
}
command = new SqlCommand(query, LoginForm.connection);
public query ConvertFilterToQuery(string filter)
{
query myQuery = null;
try
{
var re1 = @"^(?<Attribute>\w{1,})+\s(?<Operator>\-\w{1,})+\s(?<Value>(\S|\w|\d|\s){1,})+$";
WriteVerbose("Original Filter: " + filter);
var r = new Regex(re1, RegexOptions.IgnoreCase | RegexOptions.Singleline);
var m = r.Match(filter);
if (m.Success)
{
var var1 = m.Groups["Attribute"].ToString();
var var2 = m.Groups["Operator"].ToString();
var var3 = m.Groups["Value"].ToString().Replace("*","%");
string filterString = ConvertFilterToCMDBuildOperator(var2);
//filterString = FixUpPropertyNames(filterString, mpClass);
WriteVerbose("Property: " + var1);
WriteVerbose("Operator: " + filterString);
WriteVerbose("Value: " + var3);
myQuery = new query(); //(filterString, mpClass);
var fil = new filter
{
@operator = filterString,
name = var1,
value = new string[] { var3 }
};
myQuery.filter = fil;
WriteVerbose("Using " + filterString + " as query");
return myQuery;
}
}
catch // This is non-catastrophic - it's our first attempt
{
WriteDebug("failed: " + filter);
}
return myQuery;
}
.Get <GetOperation>("operations/{operationId}", async(query, ctx) =>
{
return(await connection.QueryFirstAsync <T>(query, ConvertParameters(parameter)));
protected override void ProcessRecord()
{
base.BeginProcessing();
try
{
var resclass = _clientconnection.getAttributeList(_name);
if (resclass != null)
{
var o = new card { className = _name };
var ht = new Hashtable(StringComparer.OrdinalIgnoreCase);
foreach (var prop in resclass)
{
try
{
WriteVerbose("Property in Class: " + prop.name);
ht.Add(prop.name, prop);
}
catch (Exception e)
{
WriteError(new ErrorRecord(e,
"property '" + prop.name +
"' has already been added to collection",
ErrorCategory.InvalidOperation, prop));
}
}
// now go through the hashtable that has the values we we want to use and
// assigned them into the new values
foreach (string s in PropertyHashtable.Keys)
{
if (!ht.ContainsKey(s))
{
WriteError(new ErrorRecord(new SystemException(s), "property not found on object", ErrorCategory.NotSpecified, o));
}
else
{
var p = ht[s] as attributeSchema;
if (p != null)
{
WriteVerbose(p.name);
AssignNewValue(this,p, o, PropertyHashtable[s]);
}
}
}
//Create Card
var query = new query();
var f = new filter();
f.@operator = "EQUALS";
f.name = "Code";
f.value = new[] {ht["Code"].ToString()};
query.filter = f;
var searchcard = _clientconnection.getCardList(o.className, null, query, null, 1, 0, null, null);
int rcard;
if (searchcard != null)
{
var firstOrDefault = searchcard.cards.FirstOrDefault();
if (firstOrDefault != null) rcard = firstOrDefault.id;
//_clientconnection.updateCard()
}
else
{
rcard = _clientconnection.createCard(o);
}
if (PassThru)
{
var r = _clientconnection.getCard(_name, 0, null);
WriteObject(AdaptCardObject(this, r));
}
}
}
catch (Exception e)
{
WriteError(new ErrorRecord(e, "Unknown error", ErrorCategory.NotSpecified, ""));
}
}
where gmi.Name != gmi.Pow.Nazwa && gmi.Name.ToLower().StartsWith(query) select new GminModel(gmi) into gmi
where (miejsc.Nazwa != miejsc.Gmi.Name || miejsc.RM == 99) && miejsc.Nazwa.ToLower().StartsWith(query) select new MiejscModel(miejsc) into miejsc
=> (await SearchApi.Search(query, SpotifySearchTypes.Track, null, (0, 0))).Tracks;
// Execute Reader -------------------------------------
ExecuteReader(query, o => {
=> AssertSingleResult(query, query, asserter, entryCount);
await FormatCachedLinkData((query, allowAPICalls) => FindConnections(query as TConnection, allowAPICalls), cachedPaths);
where pow.Nazwa.ToLower().StartsWith(query) select new PowModel(pow) into pow
public async Task <List <Activity> > Handle(query request, CancellationToken cancellationToken)
{
List <Activity> activities = await Context.Activities.ToListAsync();
return(activities);
}
public static nodes[] readfile(string map, string query, string output)
{
FileStream file = new FileStream(@map, FileMode.Open, FileAccess.Read);
StreamReader sr = new StreamReader(file);
int vertices;
//int wronganswers = 0;
int edges;
string line = sr.ReadLine();
vertices = int.Parse(line);
nodes[] list_vertix = new nodes[vertices];
//prority_queue.Add(dummy);
for (int i = 0; i < vertices; i++)
{
line = sr.ReadLine();
string[] lineparts = line.Split(' ');
nodes n = new nodes();
n.name = Int32.Parse(lineparts[0]);
n.distance = double.MaxValue;
n.time = double.MaxValue;
n.parent = -4;
n.visited = false;
n.x = double.Parse(lineparts[1]);
n.y = double.Parse(lineparts[2]);
//prority_queue.Add(n);
//list_vertix.Add(n);t3del
list_vertix[n.name] = n;
}
//dictionary of edges
line = sr.ReadLine();
edges = int.Parse(line);
for (int i = 0; i < edges; i++)//e
{
line = sr.ReadLine();
string[] lineparts = line.Split(' ');
info edge = new info();
Int32 key_ = Int32.Parse(lineparts[0]);
Int32 end = Int32.Parse(lineparts[1]);
edge.distance = double.Parse(lineparts[2]);
edge.speed = double.Parse(lineparts[3]);
edge.time = (edge.distance / edge.speed) * 60; // time minutes
if (dic_edges.ContainsKey(key_) == true)
{
List <KeyValuePair <Int32, info> > old_list = new List <KeyValuePair <Int32, info> >();
dic_edges.TryGetValue(key_, out old_list); // return bool (true or false) (true return value)
old_list.Add(new KeyValuePair <Int32, info>(end, edge));
dic_edges[key_] = old_list;
}
else
{
List <KeyValuePair <Int32, info> > old_list = new List <KeyValuePair <Int32, info> >();
old_list.Add(new KeyValuePair <Int32, info>(end, edge));
dic_edges.Add(key_, old_list);
}
//______________________//
// bnzbt mn al end ll start
if (dic_edges.ContainsKey(end) == true)
{
List <KeyValuePair <Int32, info> > old_list = new List <KeyValuePair <Int32, info> >();
dic_edges.TryGetValue(end, out old_list); // return bool (true or false) (true return value)
old_list.Add(new KeyValuePair <Int32, info>(key_, edge));
dic_edges[end] = old_list;
}
else
{
List <KeyValuePair <Int32, info> > old_list = new List <KeyValuePair <Int32, info> >();
old_list.Add(new KeyValuePair <Int32, info>(key_, edge));
dic_edges.Add(end, old_list);
}
}
sr.Close();
//_____________________________________________________________//
FileStream file1 = new FileStream(@query, FileMode.Open, FileAccess.Read);
StreamReader sr1 = new StreamReader(file1);
int num_queries;
line = sr1.ReadLine();
num_queries = int.Parse(line);
for (int i = 0; i < num_queries; i++)
{
line = sr1.ReadLine();
string[] lineparts = line.Split(' ');
query quer = new query();
quer.xstart = double.Parse(lineparts[0]);
quer.ystart = double.Parse(lineparts[1]);
quer.xend = double.Parse(lineparts[2]);
quer.yend = double.Parse(lineparts[3]);
quer.radius = double.Parse(lineparts[4]);
list_query.Add(quer);
}
sr1.Close();
return(list_vertix);//t3deel
}
List<$$$TableName$$$Entity> list = $$$TableName$$$Facade.Search(query);
.WildcardSearch(query, fieldSelectors));
public void load_doc(string doc_key, string vars_key, xml_doc doc, db_provider conn, Dictionary <string, object> keys = null, bool for_pg = false)
{
string var_key = !string.IsNullOrEmpty(vars_key) ? vars_key + "." : "";
// sql-select
if (doc.exists("//sql-select"))
{
foreach (xml_node s in doc.nodes("//sql-select"))
{
xml_node ref_node = s;
foreach (DataRow r in conn.dt_table(_core.parse(s.get_attr("qry"), keys)).Rows)
{
foreach (xml_node n in _core.parse_nodes(s.clone_childs(s), keys, r))
{
ref_node = ref_node.add_after(n);
}
}
}
while (true)
{
xml_node s = doc.node("//sql-select"); if (!s.remove())
{
break;
}
}
}
// aggiungo
string nkey = "";
try {
foreach (xml_node var in doc.nodes("/config//folders/folder"))
{
nkey = var_key + var.get_attr("name");
_folders.Add(nkey, new folder(doc_key, nkey, _core.parse(var.get_val()), for_pg));
}
} catch (Exception ex) { throw new Exception("chiave folders.'" + nkey + "' - " + ex.Message); }
nkey = "";
try {
foreach (xml_node tbl in doc.nodes("/config//tables/table"))
{
nkey = var_key + tbl.get_attr("name");
_tables.Add(nkey, new table(doc_key, nkey, tbl, for_pg));
}
} catch (Exception ex) { throw new Exception("chiave tables.'" + nkey + "' - " + ex.Message); }
nkey = "";
try {
foreach (xml_node tbl in doc.nodes("/config/html-blocks/html-block"))
{
nkey = var_key + tbl.get_attr("name");
html_block b = new html_block(doc_key, nkey, tbl.text, for_pg);
foreach (xml_node f in tbl.nodes("cond"))
{
b.add_cond(f.get_attr("name"), f.text);
}
_html_blocks.Add(nkey, b);
}
} catch (Exception ex) { throw new Exception("chiave html-blocks.'" + nkey + "' - " + ex.Message); }
nkey = "";
try {
foreach (xml_node qry in doc.nodes("/config//queries/*"))
{
if (qry.name == "query")
{
nkey = var_key + qry.get_attr("name");
query q = new query(doc_key, nkey, qry.text, qry.get_attr("des"), for_pg);
foreach (xml_node f in qry.nodes("cond"))
{
q.add_cond(f.get_attr("name"), f.text);
}
_queries.Add(nkey, q);
}
else if (qry.name == "query_do")
{
nkey = var_key + qry.get_attr("name");
_queries.Add(nkey, new query(doc_key, nkey, qry.get_attr("des"), for_pg)
{
tp = query.tp_query.do_while,
text_do = qry.sub_node("do").text, text_while = qry.sub_node("while").text
});
}
else if (qry.name == "queries")
{
nkey = var_key + qry.get_attr("name");
query q = new query(doc_key, nkey, qry.get_attr("des"), for_pg);
_queries.Add(nkey, q);
foreach (xml_node q2 in qry.nodes("*"))
{
if (q2.name == "query")
{
q.add_query(q2.text);
}
else if (q2.name == "exec_query")
{
foreach (string q3 in _queries[q2.get_attr("name")].queries)
{
q.add_query(q3);
}
}
}
}
}
} catch (Exception ex) { throw new Exception("chiave queries.'" + nkey + "' - " + ex.Message); }
}
