public void Update()
{
var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=archive:false&limit=80";
var user = new User();
var lucene1 = new LuceneRequest <EventCouch>();
lucene1.rows = new List <Row <EventCouch> >();
Task <string> task = HTTP_GET(url);
task.Wait();
var res = task.Result;
var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res);
foreach (var l in lucene.rows)
{
EventCouch ev = new EventCouch();
ev = EventManager.ConvertEventWarToEventCouchParent(l.fields);
lucene1.rows.Add(new Row <EventCouch>()
{
id = l.id, fields = ev
});
}
CouchRequest <EventCouch> list = new CouchRequest <EventCouch>();
list.total_rows = lucene.total_rows;
foreach (var r in lucene1.rows)
{
list.rows.Add(r.fields);
list.rows.Last()._id = r.id;
}
int i = 0;
foreach (var r in list.rows)
{
r.warehouse_id = "91af1930ecfb96fcc19ae7689c000689";
//var id1 = "";
//// id1 = GetUUID();
//DateTime UpdatedTime = r.Data_vydachi ?? new DateTime();
//r.Data_vydachi = new DateTimeOffset(r.Data_vydachi).ToUnixTimeMilliseconds();
var json = JsonConvert.SerializeObject(r);
var request = (HttpWebRequest)WebRequest.Create("http://localhost:5984/events/" + r._id);
ServicePointManager.DefaultConnectionLimit = 1000;
request.Credentials = new NetworkCredential("admin", "root");
request.Method = "PUT";
request.ContentType = "application/json";
request.KeepAlive = false;
using (var streamWriter = new StreamWriter(request.GetRequestStream()))
{
var o = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(json);
var json1 = JsonConvert.SerializeObject(o);
streamWriter.Write(json1);
}
}
}
public CouchRequest <EventCouch> GetFilterSortDocuments(string filter = "", int pagesize = 10, string sort = "Номер_упаковки", string order = "", int page = 0, string warehouse = "")
{
CouchRequest <EventCouch> list = new CouchRequest <EventCouch>();
var limit = pagesize;
var skip = (page - 1) * limit;
if (filter == null)
{
filter = "";
}
var q = "";
if (filter != "")
{
q = "( " + filter + " ) AND archive:false ";
}
else
{
q = "archive:false ";
}
var sort1 = "&sort=";
if (sort == "Номер_упаковки" || sort == "Количество")
{
if (order != "desc")
{
sort1 += "\"/\"" + sort + "<int>";
}
else
{
sort1 += "\"\\\"" + sort + "<int>";
}
}
else
{
if (order != "desc")
{
sort1 += "\"/\"" + sort;
}
else
{
sort1 += "\"\\\"" + sort;
}
}
if (warehouse == null || warehouse == "")
{
warehouse = "";
}
else
if (warehouse == "")
{
q = "(" + q + ")";
}
else
{
q = "(" + q + ")" + " AND " + "warehouse:" + warehouse;
}
var url = "http://localhost:5984/_fti/local/events/_design/searchdocuments/by_fields?q=" + q + sort1 + "&skip=" + skip + "&limit=" + limit;
var user = new User();
var lucene1 = new LuceneRequest <EventCouch>();
lucene1.rows = new List <Row <EventCouch> >();
Task <string> task = HTTP_GET(url);
task.Wait();
var res = task.Result;
var lucene = JsonConvert.DeserializeObject <LuceneRequest <EventWar> >(res);
foreach (var l in lucene.rows)
{
EventCouch ev = new EventCouch();
ev = EventManager.ConvertEventWarToEventCouchParent(l.fields);
lucene1.rows.Add(new Row <EventCouch>()
{
id = l.id, fields = ev
});
}
list.total_rows = lucene.total_rows;
// url = "http://localhost:5984/_fti/local/warehouses/_design/searchdocuments/by_fields?q=archive:false";
// task = HTTP_GET(url);
// task.Wait();
// res = task.Result;
//var lucene123 = JsonConvert.DeserializeObject<LuceneRequest<Warehouse.Model.Db.Warehouse>>(res);
// foreach (var r in lucene123.rows)
// {
// r.fields.id = r.id;
// list.wars.Add(r.fields);
// }
foreach (var r in lucene1.rows)
{
list.rows.Add(r.fields);
}
list.wars = GetWarehouses();
return(list);
}
