public bool SubmitAnswer(SubmittedQuestion item)
        {
            try
            {
                using (var entity = new FaqModel())
                {
                    var question = entity.SubmittedQuestions.FirstOrDefault(q => q.SubmittedQuestionId == item.SubmittedQuestionId);
                    question.Answer = item.Answer;
                    var res = entity.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
        public bool FaqViewCountAdd(SubmittedQuestion item)
        {
            try
            {
                using (var entity = new FaqModel())
                {
                    var fq = entity.SubmittedQuestions.FirstOrDefault(f => f.SubmittedQuestionId == item.SubmittedQuestionId);
                    fq.ViewCount++;

                    var res = entity.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
        public bool SubmitFaq(SubmittedQuestion item)
        {
            try
            {
                using (var entity = new FaqModel())
                {
                    item.CreatedDateTime = DateTime.Now;
                    var cat = entity.Categories.FirstOrDefault(c => c.Name == item.Category.Name);
                    if (cat != null)
                    {
                        item.Category = cat;
                    }
                    entity.SubmittedQuestions.Add(item);
                    var res = entity.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
Exemple #4
0
        protected void Application_Start()
        {
            GlobalConfiguration.Configure(WebApiConfig.Register);

            using (var entity = new FaqModel())
            {
                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "PCen oppdaterer seg ikke.",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Helt umulig å oppdatere til nyeste version av Win8.",
                    Category        = new Category()
                    {
                        Name = "Data"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Drålig Signal",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Mobilen har ikke signal, gjelder iphone 6.",
                    Category        = new Category()
                    {
                        Name = "Mobil"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "TV slå seg ikke på.",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "TVen får ikke inn strøm.",
                    Category        = new Category()
                    {
                        Name = "TV og bilde"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Hva skjedde med Kodak?",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Hva hendte med Kodak verdens ledende foto aparat produsent?",
                    Category        = new Category()
                    {
                        Name = "Foto og video"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Varmepumpe lager lyd",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Er det vanlig med bråkende varme pumpe?",
                    Category        = new Category()
                    {
                        Name = "Hjem og fritid"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Boss 25",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "Boss@bøss.com",
                    QuestionText    = "Er den god?",
                    Category        = new Category()
                    {
                        Name = "Lyd og hodetelefoner"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Hvordan betale?",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Betanling går ikke gjennom.",
                    Category        = new Category()
                    {
                        Name = "Betaling"
                    },
                });
                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Leverings Tid",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Kan levering skje på kvelds tid?",
                    Category        = new Category()
                    {
                        Name = "Service og Suport"
                    },
                });

                // add some questions
                entity.SubmittedQuestions.Add(new SubmittedQuestion()
                {
                    Name            = "Fri Frakt?",
                    CreatedDateTime = DateTime.Today,
                    UserEmail       = "*****@*****.**",
                    QuestionText    = "Er det fri frakt når man bestiller over 10000 enheter?",
                    Category        = new Category()
                    {
                        Name = "Leveringsinfo"
                    },
                });

                var res = entity.SaveChanges();
            }
        }