public async Task<ActionResult> Edit(string Id, string SuppliedName, string Question, string Subject)
{
var accessToken = Session["AccessToken"].ToString();
var apiVersion = Session["ApiVersion"].ToString();
var instanceUrl = Session["InstanceUrl"].ToString();
var client = new ForceClient(instanceUrl, accessToken, apiVersion);
CaseModel1 caseModel = new CaseModel1() { Status = "Closed"};
await client.UpdateAsync("Case", Id, caseModel);
//var cases = await client.QueryAsync<CaseModel>("SELECT CaseNumber, Status, Subject, Description FROM Case WHERE CaseNumber='" + caseID + "'");
//var cases = await client.QueryAsync<CaseModel>("SELECT id, CaseNumber, SuppliedName, Subject, Description, Status FROM Case WHERE id='" + Id + "'");
QuestionDBContext db = new LegendaryQuestion.Models.QuestionDBContext();
List<int> list = new List<int>();
try
{
var I = db.Queries.Where(c => c.Name == SuppliedName && c.Question == Question && c.Subject == Subject).Select(c => c.ID);
foreach (var x in I)
{
list.Add(x);
}
Query query = db.Queries.Find(list[0]);
db.Queries.Remove(query);
db.SaveChanges();
}
catch { }
return RedirectToAction("Index");
}
public async Task<ActionResult> Open(string Id, string SuppliedName)
{
var accessToken = Session["AccessToken"].ToString();
var apiVersion = Session["ApiVersion"].ToString();
var instanceUrl = Session["InstanceUrl"].ToString();
var client = new ForceClient(instanceUrl, accessToken, apiVersion);
CaseModel1 caseModel = new CaseModel1() { Status = "New" };
await client.UpdateAsync("Case", Id, caseModel);
//var cases = await client.QueryAsync<CaseModel>("SELECT CaseNumber, Status, Subject, Description FROM Case WHERE CaseNumber='" + caseID + "'");
//var cases = await client.QueryAsync<CaseModel>("SELECT id, CaseNumber, SuppliedName, Subject, Description, Status FROM Case WHERE id='" + Id + "'");
//QuestionDBContext db = new QuestionDBContext();
// QuestionDBContext db = await.client.QueryAsync<QuestionDBContext>("SELECT *FROM Queries Where SuppliedName= '" + SuppliedName + "'");
return RedirectToAction("Index");
}