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