public async Task <string> AddBulkComicsToList(string name, List <Comic> comicsToAdd) { PullList list = FindListByName(name); string result = null; using (_client = new DocumentClient(_uri, _settings.AuthorizationKey)) { string pathLink = string.Format("dbs/{0}/colls/{1}", _settings.DatabaseId, _settings.CollectionId); dynamic doc = _client.CreateDocumentQuery <Document>(pathLink).Where(l => l.Id == list.Id).AsEnumerable().FirstOrDefault(); if (doc != null) { PullList newList = doc; foreach (var comic in comicsToAdd) { if (comic != null) { list.Comics.Add(comic); } } newList.Comics = list.Comics; ResourceResponse <Document> x = await _client.ReplaceDocumentAsync(doc.SelfLink, newList); result = x.StatusCode.ToString(); } } return(result); }
public async Task <string> DeleteBulkComicsFromList(List <string> nameofComics, string name) { PullList list = FindListByName(name); string result = null; using (_client = new DocumentClient(_uri, _settings.AuthorizationKey)) { string pathLink = string.Format("dbs/{0}/colls/{1}", _settings.DatabaseId, _settings.CollectionId); dynamic doc = _client.CreateDocumentQuery <Document>(pathLink).Where(l => l.Id == list.Id).AsEnumerable().FirstOrDefault(); if (doc != null) { PullList newList = doc; foreach (string cname in nameofComics) { var comicToRemove = list.Comics.Where(y => y.Title == cname).First(); if (comicToRemove != null) { list.Comics.Remove(comicToRemove); } } newList.Comics = list.Comics; ResourceResponse <Document> x = await _client.ReplaceDocumentAsync(doc.SelfLink, newList); result = x.StatusCode.ToString(); } } return(result); }
//public void Get_ShopOrders(string SalesNumber, ref JobHeaderDataModel jobheader) //{ // string lstrTXLink = "http://pcinet/ShopOrders/GetOrder.aspx?TX=true&SpecsCS=true&SalesOrder=" + SalesNumber; //Link number 1 // string lstrTALink = "http://pcinet/ShopOrders/GetOrder.aspx?TA=true&SpecsCS=true&SalesOrder=" + SalesNumber; // string lstrCALink = "http://pcinet/ShopOrders/GetOrder.aspx?CA=true&SpecsCS=true&SalesOrder=" + SalesNumber; // string lstrLVRLink = "http://pcinet/ShopOrders/GetOrder.aspx?SalesOrder=" + SalesNumber + "&SpecsCS=true"; //} public void Get_PullList(string SalesNumber, ref JobHeaderDataModel jobheader) { string dir = @"\\pcinet\wwwroot\ShopOrders\CSFiles\ICS\Cutsheets"; System.IO.DirectoryInfo path1 = new System.IO.DirectoryInfo(dir); List <PullList> PullLists = new List <PullList>(); PullList singlepulllist = new PullList(); foreach (System.IO.FileInfo fi in path1.GetFiles(SalesNumber + "*.pdf").Where(x => x.Extension == "PullList.pdf")) { singlepulllist.fileName = Convert.ToString(fi.Name); singlepulllist.fileDate = Convert.ToString(fi.CreationTime); singlepulllist.filePath = Convert.ToString(fi.DirectoryName); singlepulllist.hyperlink = "http://pcinet/ShopOrders/CSFiles/ICS/Cutsheets/" + fi.Name; PullLists.Add(singlepulllist); } jobheader.PullLists = PullLists; }
public PullList FindListByName(string name) { PullList list = null; using (_client = new DocumentClient(_uri, _settings.AuthorizationKey)) { string pathLink = string.Format("dbs/{0}/colls/{1}", _settings.DatabaseId, _settings.CollectionId); dynamic doc = _client.CreateDocumentQuery <PullList>(pathLink).Where(n => n.Name == name).AsEnumerable().FirstOrDefault(); if (doc != null) { list = doc; } } return(list); }
public async Task <IActionResult> AddNewList([FromBody] PullList pulllist) { PullListResult result = new PullListResult(); try { string id = await PullLists.Add(pulllist); if (id != null) { result.Id = id; } return(Ok(string.Format("New List Added for {0}", pulllist.Name))); } catch { return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public async Task <string> Add(PullList list) { string id = null; PullList l = new PullList(); l.Name = list.Name; l.Comics = list.Comics; l.Active = true; using (_client = new DocumentClient(_uri, _settings.AuthorizationKey)) { string pathLink = string.Format("dbs/{0}/colls/{1}", _settings.DatabaseId, _settings.CollectionId); ResourceResponse <Document> doc = await _client.CreateDocumentAsync(pathLink, l); id = doc.Resource.Id; } return(id); }
public async Task <string> UpdateListStatus(string name, bool status) { PullList list = FindListByName(name); string result = null; using (_client = new DocumentClient(_uri, _settings.AuthorizationKey)) { string pathLink = string.Format("dbs/{0}/colls/{1}", _settings.DatabaseId, _settings.CollectionId); dynamic doc = _client.CreateDocumentQuery <Document>(pathLink).Where(l => l.Id == list.Id).AsEnumerable().FirstOrDefault(); if (doc != null) { PullList newList = doc; newList.Active = status; ResourceResponse <Document> x = await _client.ReplaceDocumentAsync(doc.SelfLink, newList); result = x.StatusCode.ToString(); } } return(result); }
private void btnPullList_Click(object sender, EventArgs e) { PullList f3 = new PullList(); f3.Show(); }