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();
}
