public bool Add(object[] id, int qid, string user) { bool res = false; try { foreach (var item in id) { SBH_TR_QUESTIONS_TAGGING a = new SBH_TR_QUESTIONS_TAGGING(); a.ID_QUESTIONS = qid; a.ID_USER_TAGGING = int.Parse(item.ToString()); a.ANSWER_STATUS = fn.fg.NotActive; a.CREATED_BY = user; a.CREATED_TIME = DateTime.Now; a.ROW_STATUS = fn.fg.IsActive; _ctx.SBH_TR_QUESTIONS_TAGGING.Add(a); _ctx.SaveChanges(); } res = true; } catch (Exception ex) { throw; } return(res); }
public bool Add(Answer ans) { bool res = false; try { SBH_TR_ANSWER a = new SBH_TR_ANSWER() { ID_QUESTIONS = ans.ID_QUESTIONS, ID_USER_ADMIN = ans.ID_USER_ADMIN, ANSWER = ans.ANSWER, CREATED_TIME = DateTime.Now, CREATED_BY = ans.CREATED_BY, ROW_STATUS = fn.fg.IsActive }; _ctx.SBH_TR_ANSWER.Add(a); _ctx.SaveChanges(); SBH_TR_QUESTIONS b = _ctx.SBH_TR_QUESTIONS.Find(ans.ID_QUESTIONS); if (b != null) { b.MOST_COMMENT_DATE = DateTime.Now; b.MOST_COMMENT = b.MOST_COMMENT + 1; _ctx.Entry(b).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); } //Answer from Guest doesn't record if (ans.ID_USER_ADMIN != 9) { SBH_TM_USER_ADMIN c = _ctx.SBH_TM_USER_ADMIN.Find(ans.ID_USER_ADMIN); if (c != null) { int x = 0; if (!String.IsNullOrWhiteSpace(c.MOST_ACT_ANSWER.ToString())) { x = int.Parse(c.MOST_ACT_ANSWER.ToString()); } c.MOST_ACT_ANSWER = x + 1; c.MOST_ACT_ANSWER_DATE = DateTime.Now; _ctx.Entry(c).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); } } SBH_TR_QUESTIONS_TAGGING d = _ctx.SBH_TR_QUESTIONS_TAGGING.Where(x => x.ID_QUESTIONS == ans.ID_QUESTIONS && x.ID_USER_TAGGING == ans.ID_USER_ADMIN).FirstOrDefault(); if (d != null) { d.ANSWER_STATUS = fn.fg.IsActive; d.LAST_MODIFIED_TIME = DateTime.Now; d.LAST_MODIFIED_BY = ans.CREATED_BY; _ctx.Entry(d).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); } res = true; } catch (Exception ex) { res = false; } return(res); }