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