private void btnApply_Click(object sender, RoutedEventArgs e) { Mouse.OverrideCursor = Cursors.Wait; ResetFilterSurvey(); FilterSurvey(); List <NewSurvey> newSurveys = new List <NewSurvey>(); foreach (var ques in Db.Context.Questions.ToList()) { NewSurvey ns = new NewSurvey() { Question = ques.Text }; ns.Outstanding = surveys.Count(t => t.AnswerId == 1 && t.QuestionId == ques.QuestionId); ns.VeryGood = surveys.Count(t => t.AnswerId == 2 && t.QuestionId == ques.QuestionId); ns.Good = surveys.Count(t => t.AnswerId == 3 && t.QuestionId == ques.QuestionId); ns.Adequate = surveys.Count(t => t.AnswerId == 4 && t.QuestionId == ques.QuestionId); ns.NeedImprovement = surveys.Count(t => t.AnswerId == 5 && t.QuestionId == ques.QuestionId); ns.Poor = surveys.Count(t => t.AnswerId == 6 && t.QuestionId == ques.QuestionId); ns.NotKnow = surveys.Count(t => t.AnswerId == 7 && t.QuestionId == ques.QuestionId); newSurveys.Add(ns); } LoadChartSurvey(); dgSurveys.ItemsSource = newSurveys; Mouse.OverrideCursor = Cursors.Arrow; }
public static string CreateNewSurvey(string spSiteUrl, IDictionary <string, string> cookies, string ListName, NewSurvey entries) { try { using (ClientContext context = new ClientContext(spSiteUrl)) { context.ExecutingWebRequest += delegate(object sender, WebRequestEventArgs e) { e.WebRequestExecutor.WebRequest.CookieContainer = new CookieContainer(); foreach (KeyValuePair <string, string> KvpCookie in cookies) { Cookie cookie = new Cookie(KvpCookie.Key, KvpCookie.Value); e.WebRequestExecutor.WebRequest.CookieContainer.Add(new Uri(spSiteUrl), cookie); } }; Entry entry = entries.GetEntry(); User newUser = context.Web.EnsureUser(entry.Presenter); context.Load(newUser); context.ExecuteQuery(); FieldUserValue userValue = new FieldUserValue(); userValue.LookupId = newUser.Id; List list = context.Web.Lists.GetByTitle(ListName); ListItemCreationInformation info = new ListItemCreationInformation(); ListItem listItem = list.AddItem(info); listItem["Title"] = entry.Title; listItem["Presenter"] = userValue; listItem["TrainingDate"] = entry.TrainingDate; listItem["TrainingDuration"] = entry.TrainingDuration; listItem["SurveyStatus"] = entry.SurveyStatus; listItem["SurveyStatus_old"] = entry.SurveyStatus; listItem["Question"] = entry.SurveyQuestion; listItem.Update(); context.ExecuteQuery(); } return("success"); } catch (Exception e) { return("failed"); } }