Exemple #1
0
        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> 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");
        }