//QA modul public void AddQuestion(Question pitanje) { List<Tag> tags = pitanje.Tags.ToList(); List<Category> kate = pitanje.Categories.ToList(); string cmd = string.Format("EXEC [dbo].[usp_QuestionsInsert] '{0}',{1},'{2}','{3}','{4}',{5},{6}", pitanje.QuestionBody, pitanje.User.UserID, pitanje.CreatedDate.Value.ToString("MM/dd/yyyy H:m:s:f", CultureInfo.InvariantCulture), pitanje.GUID, pitanje.QuestionTitle, 0, 0); pitanje = context.Database.SqlQuery<Question>(cmd).SingleOrDefault(); foreach (var tag in tags) { context.Database.ExecuteSqlCommand("EXEC dbo.usp_TagInQuestionInsert " + pitanje.QuestionID + "," + tag.TagID); } foreach (var cat in kate) { context.Database.ExecuteSqlCommand("EXEC [dbo].[usp_QuestionsInCategoryInsert] " + pitanje.QuestionID + "," + cat.CategoryID); } }
public ItemPreporuka(Question q) { question = q; }
public void Update_Question(Question q) { context.Database.ExecuteSqlCommand("EXEC [dbo].[usp_QuestionsUpdate] {0},{1},{2},{3},{4},{5},{6}", q.QuestionID, q.QuestionBody, q.User.UserID, q.CreatedDate, q.GUID, q.Likes, q.NumOfViews); }
public Question GetQuestionZaPreporuku(User a) { List<Tag> listaTagovaLoginUsera = new List<Tag>(); List<Category> listaKategorijaLoginUsera = new List<Category>(); List<QuestionsRating> listaQuesionRatingLoginUsera = new List<QuestionsRating>(); List<Question> questionsOfUser = context.Questions.Where(q => q.CreatorID == a.UserID).ToList(); foreach (var item in questionsOfUser) { foreach (var i in item.Tags) { listaTagovaLoginUsera.Add(i); } } foreach (var item in questionsOfUser) { foreach (var i in item.Categories) { listaKategorijaLoginUsera.Add(i); } } foreach (var item in questionsOfUser) { foreach (var i in item.QuestionsRatings) { listaQuesionRatingLoginUsera.Add(i); } } Question PitanjeVirtualno = new Question(); PitanjeVirtualno.QuestionsRatings = listaQuesionRatingLoginUsera; PitanjeVirtualno.Tags = listaTagovaLoginUsera; PitanjeVirtualno.Categories = listaKategorijaLoginUsera; return PitanjeVirtualno; }
private List<QuestionRecommender> GetPreporukaPitanja(Question q) { ItemPreporuka ip = new ItemPreporuka(q); return ip.GetQuestionsPreporke(); }
public ActionResult Create(string Naslov, string Content, string jsonTagQuestion, string jsonKatQuestion) { Question pitanje = new Question(); pitanje.User = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext); pitanje.CreatedDate = DateTime.Now; pitanje.QuestionBody = Server.HtmlDecode(Content).Replace("'", "'"); pitanje.QuestionTitle = Naslov; pitanje.GUID = Guid.NewGuid(); var ListaTagova = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.Json.Tag>>(jsonTagQuestion); var ListaKategorija = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.Json.Kategorija>>(jsonKatQuestion); List<Igman.DB.DAL.Tag> listTempTag = SinhronyzeWithDB(ListaTagova.Where(x => x.TagID == "-1").ToList(), ListaTagova.Where(x => x.TagID != "-1").ToList()); List<Category> listaKategorija = SinhronyzeWithDB(ListaKategorija); pitanje.Categories = listaKategorija; pitanje.Tags = listTempTag; _db.AddQuestion(pitanje); return RedirectToAction("index", "Questions"); }