/// <summary> /// Create a new survey /// </summary> /// <param name="surveys">Survey to create</param> public void CreateSurvey(Surveys surveys) { try { using (var transaction = _surveyOnlineContext.Database.BeginTransaction()) { try { _surveyOnlineContext.Add(surveys); foreach (var question in surveys.Questions) { _surveyOnlineContext.Add(question); foreach (var answer in question.AnswerVariants) { _surveyOnlineContext.Add(answer); } } _surveyOnlineContext.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw; } } } catch { throw; } }
public List <SurveyStatus> GetEmployeeList() { SurveyPeriod surveyPeriodInfoObject = new SurveyPeriod(); surveyPeriodInfoObject.Type = "Annually"; surveyPeriodInfoObject.Period = "2016"; try { var empList = new Surveys().getAllSurveysListStatus(surveyPeriodInfoObject).Distinct().ToList(); List <SurveyStatus> employeeSurveyList = new List <SurveyStatus>(); foreach (var employeeInfo in empList) { if (!(employeeSurveyList.Where(c => c.Survey_For == employeeInfo.Survey_For).Count() > 0)) { employeeSurveyList.Add(employeeInfo); } } return(employeeSurveyList.Where(c => c.Completed == true).ToList()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void Select_As_Favourite(object sender, EventArgs e) { var fav = (Image)sender; var favSurvey = Surveys.Surveys.FirstOrDefault(s => s.SurveyId == fav.ClassId); if (favSurvey.Image == "unselect.png") { favSurvey.Image = "selected.png"; favSurvey.IsFavourite = true; } else { favSurvey.Image = "unselect.png"; favSurvey.IsFavourite = false; } var isSurveyAdded = _db.GetFavourites().FirstOrDefault(x => x.SurveId == fav.ClassId); if (isSurveyAdded == null || string.IsNullOrEmpty(isSurveyAdded.SurveId)) { _db.AddFav(fav.ClassId, favSurvey.IsFavourite, favSurvey.Image); } else { _db.UpdateFav(fav.ClassId, favSurvey.IsFavourite, favSurvey.Image); } Surveys.Favourites(); SurveyList.ItemsSource = Surveys.Surveys; }
public async Task <IActionResult> Update([FromBody] Surveys inputModel) { try { var data = await _surveysManager.Find_By_Id(inputModel.Id); if (data == null) { throw new Exception(MessageConst.DATA_NOT_FOUND); } inputModel.UpdatedDate = DateTime.Now; inputModel.CreatedDate = data.CreatedDate; await _surveysManager.Update(inputModel); if (inputModel.Questions != null) { await _questionsManager.UpdateListQuestion(inputModel.Questions, inputModel.Id); } return(Ok(data)); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public IHttpActionResult GetEmployeesWithSurveyAllPerBusinessUnit(string businessUnit) { SurveyPeriod surveyPeriodInfoObject = new SurveyPeriod(); surveyPeriodInfoObject.Type = "Annually"; surveyPeriodInfoObject.Period = "2016"; try { var empList = new Surveys().getAllSurveysListStatus(surveyPeriodInfoObject).Distinct().ToList(); empList = empList.Where(c => c.Team_Desc == businessUnit.Replace("and", "&")).Distinct().ToList(); var employeeSurveyList = new List <SurveyStatus>(); foreach (var employeeInfo in empList) { if (!(employeeSurveyList.Where(c => c.Survey_For == employeeInfo.Survey_For).Count() > 0)) { employeeSurveyList.Add(employeeInfo); } } return(Ok(employeeSurveyList)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IHttpActionResult GetEmployeesWithSurveyToVerifiy() { SurveyManagerList managerInfoObject = new SurveyManagerList(); var ADUserName = Generic.GetCurrentLogonUserName(); managerInfoObject.Type = "Annually"; managerInfoObject.Period = "2016"; managerInfoObject.Manager = new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == ADUserName.ToLower()).First().Employee; try { var list = new Surveys().getManagerSurveysListStatus(managerInfoObject); var employeeSurveyList = new List <SurveyManagerStatus>(); foreach (var item in list) { if (!(employeeSurveyList.Where(c => c.Survey_For == item.Survey_For).Count() > 0)) { employeeSurveyList.Add(item); } } return(Ok(employeeSurveyList)); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Get the survey from localstorage. /// </summary> /// <returns>Survey instance with questions.</returns> public Survey GetSurvey() { Survey result = Surveys.ToList()[0]; result.Questions = Questions.ToList(); return(result); }
/// <summary> /// 获取一个这是第几次诊断。 /// </summary> /// <param name="surveys"></param> /// <returns>0初诊,1复诊。</returns> public static int GetDiagnosisCount(this Surveys surveys) { var ary = EntityUtility.GetTuples(surveys.UserState); var flag = ary.FirstOrDefault(c => c.Item1 == "诊次")?.Item2 ?? 0; return((int)flag); }
public void ButtonProceed_Click(object sender, RoutedEventArgs e) { Surveys s = new Surveys(); var survey = survey_listview.SelectedItem as Surveys; try { s = surveyRepo.GetSurveyByName(survey.Name); } catch (NullReferenceException) { MessageBox.Show("You haven't chosen any survey", "Oops"); return; } var userName = TextBoxEnterName.Text; if (string.IsNullOrWhiteSpace(userName)) { MessageBox.Show("Name yourself, please", "Oops"); return; } Pass_survey next = new Pass_survey(s, userName); next.ShowDialog(); }
public bool SaveSurvey(Surveys survey) { int rowsAffected = 0; const string insertSurveySql = "INSERT INTO survey_result (parkCode, emailAddress, [state], activityLevel) " + "VALUES(@parkCode, @emailAddress, @state, @activityLevel);"; try { using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(insertSurveySql, conn); cmd.Parameters.AddWithValue("@parkCode", survey.ParkCode); cmd.Parameters.AddWithValue("@emailAddress", survey.EmailAddress); cmd.Parameters.AddWithValue("@state", survey.State); cmd.Parameters.AddWithValue("@activityLevel", survey.ActivityLevel); rowsAffected = cmd.ExecuteNonQuery(); } } catch (Exception) { throw; } return(rowsAffected > 0); }
public ActionResult Create([Bind(Include = "SurveyId,SubcontractorId,Month,Date,SurveysCompleted,SubmittedDate")] Surveys surveys) { if (ModelState.IsValid) { var dataexist = from s in db.Surveys where s.SubcontractorId == surveys.SubcontractorId && s.Month == surveys.Month && s.SubmittedDate.Year == DateTime.Today.Year select s; if (dataexist.Count() >= 1) { ViewBag.error = "Data already exists. Please change the params or search in the Reports tab for the current Record."; } else { surveys.SubmittedDate = DateTime.Now; db.Surveys.Add(surveys); db.SaveChanges(); return(RedirectToAction("Create")); } } ViewBag.SubcontractorId = new SelectList(db.SubContractors.OrderBy(a => a.OrgName), "SubcontractorId", "OrgName", surveys.Subcontractors); return(View(surveys)); }
public ActionResult Create([Bind(Include = "SurveyID,SurveyName,SurveyCode,SurveyType,CreatedBy,CreatedDate,ModifedBy,ModifiedDate")] Surveys surveys) { if (ModelState.IsValid) { User u = UserHelper.getMember(db); surveys.CreatedBy = u.UserID; surveys.CreatedDate = DateTime.Now; surveys.ModifedBy = u.UserID; surveys.ModifiedDate = DateTime.Now; db.Surveys.Add(surveys); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SurveyType = new SelectList(new[] { new { Value = "Participant", Text = "Participant" }, new { Value = "OEG Staff", Text = "OEG Staff" }, new { Value = "School Staff", Text = "School Staff" } } , "Value", "Text"); return(View(surveys)); }
public IHttpActionResult GetEmployeeSurveyQuestions(string id) { //First get a list of all the questions var Survey = new Surveys(); var surveyObject = new SurveyRaterSurvey(); surveyObject.Type = "Annually"; surveyObject.Period = "2016"; surveyObject.Rater = new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == Generic.GetCurrentLogonUserName().ToLower()).First().Employee; surveyObject.Ratee = id; try { var surveyList = new Surveys().getSurveyFor(surveyObject); //for (int i = 0; i < surveyList.Count(); i++) //{ // surveyList[counter].Q_No = counter; // counter++; //} return(Ok(surveyList.Distinct().ToList())); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <string> PostSurveys(Surveys surveys) { _context.Surveys.Add(surveys); await _context.SaveChangesAsync(); return("Su comentario se ha publicado correctamente"); }
public IHttpActionResult ManagerVerifySingleQuestion(SurveyVerify survey) { var empSurveyObject = GetSurveyObject(survey.Survey_For); empSurveyObject.Survey_For = survey.Survey_For; survey.Verify = true; var surveyForList = new Surveys().getSurveyForVerifyAllRaters(empSurveyObject); surveyForList = surveyForList.Where(c => c.Question == survey.Question).ToList(); survey.Type = empSurveyObject.Type; survey.Period = empSurveyObject.Period; foreach (var surveyObject in surveyForList) { survey.Rater = surveyObject.Rater; survey.User = Generic.GetCurrentLogonUserName(); var manager = new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == survey.User.ToLower()).First().Employee; survey.Manager = manager; var saveReviewQuestion = new SurveyUpdate().SurveyManagerVerify(survey); } return(Ok()); }
public IHttpActionResult GetEmployeeSurveyQuestionsForReview(string id) { //First get a list of all the questions var Survey = new Surveys(); var surveyObject = new SurveyForList(); surveyObject.Type = "Annually"; surveyObject.Period = "2016"; surveyObject.Survey_For = id; //surveyObject.Rater = new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == Generic.GetCurrentLogonUserName().ToLower()).First().Employee; //surveyObject.Ratee = id; try { var surveyList = new Surveys().getSurveyForListRaters(surveyObject).Distinct().ToList(); return(Ok(surveyList.Distinct().ToList())); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IHttpActionResult GetBusinessUnitList() { var departmentList = new List <DepartmentDropDown>(); var counter = 1; //Get AD group list var fgTeamList = new Surveys().getSurveyTeams(); foreach (var item in fgTeamList) { departmentList.Add(new DepartmentDropDown() { Name = item.Team.Replace("&", "and"), Value = counter.ToString() }); counter++; } var data = JsonConvert.SerializeObject(departmentList); return(Ok(departmentList)); }
/// <summary> /// 構造函數。 /// </summary> /// <param name="surveys"></param> /// <param name="conclusion"></param> /// <param name="db"></param> public SaveConclusioModel(Surveys surveys, SurveysConclusion conclusion, DbContext db) { Conclusion = conclusion; var template = db.Set <SurveysTemplate>().Find(surveys.TemplateId); UserId = surveys.UserId; SurveysTemplateId = surveys.TemplateId; var question = template.Questions.FirstOrDefault(c => c.QuestionTitle == "姓名"); if (null != question) { Name = surveys.SurveysAnswers.FirstOrDefault(c => c.TemplateId == question.Id)?.Guts; } question = template.Questions.FirstOrDefault(c => c.QuestionTitle == "手机号"); if (null != question) { Mobile = surveys.SurveysAnswers.FirstOrDefault(c => c.TemplateId == question.Id)?.Guts; } question = template.Questions.FirstOrDefault(c => c.QuestionTitle == "性别"); if (null != question) { Sex = surveys.SurveysAnswers.FirstOrDefault(c => c.TemplateId == question.Id)?.Guts; } //写入方剂Id var idTp = surveys.ThingPropertyItems.FirstOrDefault(c => c.Name == "PrescriptionId"); PrescriptionId = idTp?.Value; //写入方剂数据 idTp = conclusion.ThingPropertyItems.FirstOrDefault(c => c.Name == CnMedicineAlgorithmBase.CnPrescriptionesName); if (null != idTp) { Prescriptiones = EntityUtility.FromJson <List <CnPrescription> >(idTp.Value); } }
// idRestaurant, waiterCal, foodCal, comfortCal, generalCal, waiterName public async Task PostAlexaSurvey(int idRes, int A1, int A2, int A3, int A4, string A0) { Surveys survey = new Surveys(); Waiters waiters; survey.Idrestaurant = idRes; survey.Iduser = 3; ///// ESTE DEBE DE SER EL USER GENERAL survey.FoodRating = A2 / 2; survey.ComfortRating = A3 / 2; survey.GeneralScore = A4 / 2; survey.ServiceRating = A1 / 2; survey.DateStatistics = DateTime.Now; if (A0 != "0") { waiters = await _context.Waiters.Where(w => w.Idrestaurant == idRes && w.WaiterFirstName.Contains(A0)).FirstOrDefaultAsync(); survey.Idwaiter = (waiters == null) ? 0 : waiters.Idwaiter; } if (survey.Idwaiter == 0) { var genWaiter = await _context.Waiters.Where(w => w.Idrestaurant == idRes) .OrderBy(w => w.Idwaiter).FirstOrDefaultAsync(); survey.Idwaiter = genWaiter.Idwaiter; } _context.Surveys.Add(survey); await _context.SaveChangesAsync(); }
public IHttpActionResult GetEmployeeInformationForNotificationByTeam(string adGroupName) { var employeeObject = new Employee(); adGroupName = adGroupName.Replace(" and ", " & "); var employeeList = new List <Employee>(); SurveyTeam teamObject = new SurveyTeam(); teamObject.Team = adGroupName; SurveyRaterList raterInfo = new SurveyRaterList(); var ADUserName = Generic.GetCurrentLogonUserName(); raterInfo.Type = "Annually"; raterInfo.Period = "2016"; raterInfo.Team_Desc = adGroupName; // raterInfo.Rater = "Zukiso Diko"; // new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == ADUserName.ToLower()).First().Employee; var employeeWithSurveys = new Surveys().getSurveysListByTeam(raterInfo); employeeWithSurveys = employeeWithSurveys.Where(c => c.Team_Desc == adGroupName && c.Verified == true && c.Reviewed == true).ToList(); string data = JsonConvert.SerializeObject(employeeWithSurveys); return(Ok(data)); }
private void Page_Load(object sender, System.EventArgs e) { UITabList.SetCampaignTabs((MsterPageTabs)Page.Master, UITabList.CampaignTabs.Web); MessageLabel.Visible = false; SetupSecurity(); LocalizePage(); ShowFriendlyUrl(); if (!Page.IsPostBack) { // Header.SurveyId = SurveyId; ((Wap)Master.Master).HeaderControl.SurveyId = SurveyId; var survey = new Surveys().GetSurveyById(SurveyId, null).Surveys[0]; Guid guid = survey.SurveyGuid; if (!survey.IsFriendlyNameNull()) { txtFriendly.Text = survey.FriendlyName; } CodeHyperLink.NavigateUrl = GetUrl("?surveyid=" + guid.ToString()); CodeMobileHyperLink.NavigateUrl = GetMobileUrl("?surveyid=" + guid.ToString()); CodeHyperLink.Text = CodeHyperLink.NavigateUrl; CodeMobileHyperLink.Text = CodeMobileHyperLink.NavigateUrl; } SetupTextArea(); }
public IHttpActionResult GetEmployeeQuestionsByRater(string rater) { var empSurveyObject = GetSurveyObject(); var Survey = new Surveys(); var surveyObject = new SurveyRaterSurvey(); surveyObject.Type = "Annually"; surveyObject.Period = "2016"; surveyObject.Rater = new Surveys().getSurveyTeamEmployeeList().Where(c => c.AD_User_Name.ToLower() == Generic.GetCurrentLogonUserName().ToLower()).First().Employee; surveyObject.Ratee = rater; var raterListString = string.Empty; var surveyForList = new Surveys().getSurveyForVerifyAllRaters(empSurveyObject); foreach (var surveyObj in surveyForList) { raterListString += surveyObj.Rater + ";"; } var list = new Surveys().getSurveyFor(surveyObject); list[0].Rater = raterListString; return(Ok(list.Distinct().ToList())); }
internal static IEnumerable <RouterReturn> Map(Surveys psSurveys, RouterUser user) { //this is mapping the Prescision Sample Raw Result to //the RouterReturn var returnList = new List <RouterReturn>(); if (psSurveys?.Survey == null || !psSurveys.Survey.Any()) { return(returnList); } return(psSurveys.Survey.Select(s => new RouterReturn() { //HostId = (int)RouterHost.PrecisionSample, //Name = $"{s.SurveyName}. {s.IR}% success rate ({s.SurveyLength} minutes)", Title = s.SurveyName, SubTitle = $"{s.SurveyLength} minutes * {s.IR}% success * ${s.RewardValue}", //URL = s.SurveyUrl, //SuccessRate = s.IR, EarningPotential = s.IR * s.RewardValue / s.SurveyLength, //ProjectId = s.ProjectId, ProxyUrl = GetProxyUrl(user.RouterContactId, RouterHost.PrecisionSample, s.ProjectId, s.SurveyUrl) })?.ToList()); }
public async Task getSurveyQuestionPage(string key, Surveys data) { var result = true; await Navigation.PushPopupAsync(new LoadingPopPage(), true); result = await surveyMVVM.checkUserResponse(key); await Navigation.PopPopupAsync(true); if (!result) { await Navigation.PushAsync(new SurveyQuestionList() { Title = data.surveyName }, true); MessagingCenter.Send <SurveyPage, List <Question> >(this, MCenter.question.ToString(), data.questions); MessagingCenter.Send <SurveyPage, string>(this, MCenter.questionKey.ToString(), key); } else { await DisplayAlert("Uyarı", "Bu ankete daha önceden cevap verilmiş", "Tamam"); } await Navigation.PopAllPopupAsync(); }
private Surveys LoadPrecisionSampleSurveys(RouterUser user) { var db = new GloshareDbContext(); PrecisionSample ps = new PrecisionSample(); Surveys rawSurveys = ps.GetRawSurveys(user).Result; List <int> existingProjectIDs = db.RouterSurveyPrecisionSamples.Select(s => s.ProjectId).ToList(); foreach (SurveysSurvey survey in rawSurveys.Survey) { if (!existingProjectIDs.Contains((int)survey.ProjectId)) { RouterSurveyPrecisionSample rsps = new RouterSurveyPrecisionSample() { Name = survey.SurveyName, ProjectId = Convert.ToInt32(survey.ProjectId), SurveyLength = survey.SurveyLength, ConversionRate = survey.IR, GrossRevenue = survey.GrossRevenue, RewardValue = survey.RewardValue, TrafficType = survey.SurveyTrafficType, Url = survey.SurveyUrl, VerityCheckRequired = survey.VerityCheckRequired == "Yes" }; db.RouterSurveyPrecisionSamples.Add(rsps); db.SaveChanges(); } } return(rawSurveys); }
public ActionResult DeleteConfirmed(int id) { Surveys surveys = db.Surveys.Find(id); db.Surveys.Remove(surveys); db.SaveChanges(); return(RedirectToAction("Index")); }
//Get all surveys public virtual async Task <List <Survey> > GetSurveysAsync() { return(await Surveys .Include(s => s.Questions) .OrderBy(s => s.Id) .AsNoTracking() .ToListAsync()); }
public IHttpActionResult GetAllEmlpoyees() { var employeeList = new Surveys().getSurveyTeamEmployeeList(); string data = JsonConvert.SerializeObject(employeeList); return(Ok(data)); }
public virtual ActionResult Edit(string id) { var model = SurveyEditModel.FromDomain(Surveys.Get(id), Accounting); ViewData["groups"] = GroupSummaries; ViewData["users"] = UserSummaries[model.Availability.Users ?? new string[0]]; return(View(model)); }
//Create survey public virtual async Task <Survey> AddSurveyAsync(Survey survey) { survey.Date = DateTime.Now; await Surveys.AddAsync(survey); await SaveChangesAsync(); return(survey); }