public Answer Retrived(int id) { try { Answer oA = new Answer(); SBH_TR_QUESTIONS oB = _ctx.SBH_TR_QUESTIONS.Where(x => x.ROW_STATUS == fn.fg.IsActive && x.ID == id).FirstOrDefault(); if (oB != null) { oA.ID_QUESTIONS = id; oA.QUESTIONS = oB.QUESTIONS; oA.TITLE_QUESTIONS = oB.TITLE_QUESTIONS; return(oA); } else { return(null); } } catch (Exception ex) { return(null); throw new Exception(ex.Message); } }
public Questions Retrived(int id) { try { Questions oA = new Questions(); SBH_TR_QUESTIONS oB = _ctx.SBH_TR_QUESTIONS.Where(x => x.ID == id && x.ROW_STATUS == fn.fg.IsActive).FirstOrDefault(); if (oB != null) { oA.ID = oB.ID; oA.ID_CATEGORY = oB.ID_CATEGORY; //oA.ID_USER = oB.ID_USER; oA.QUESTIONS = oB.QUESTIONS; //oA.CREATED_TIME = oB.CREATED_TIME; //oA.CREATED_BY = oB.CREATED_BY; //oA.LAST_MODIFIED_TIME = oB.LAST_MODIFIED_TIME; //oA.LAST_MODIFIED_BY = oB.LAST_MODIFIED_BY; //oA.ROW_STATUS = oB.ROW_STATUS; return(oA); } else { return(null); } } catch (Exception ex) { return(null); throw new Exception(ex.Message); } }
public bool Edit(int id, Questions par) { bool res = false; try { SBH_TR_QUESTIONS a = _ctx.SBH_TR_QUESTIONS.Find(id); if (a != null) { a.ID_CATEGORY = par.ID_CATEGORY; //a.ID_USER = par.ID_USER; a.QUESTIONS = par.QUESTIONS; a.CREATED_BY = null; a.LAST_MODIFIED_TIME = DateTime.Now; a.LAST_MODIFIED_BY = "System"; _ctx.Entry(a).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); res = true; } } catch (Exception ex) { throw new Exception(ex.Message); } return(res); }
public object[] Add(Questions par) { object[] res; string flag = "0"; try { int maxid = 0; try { SBH_TR_QUESTIONS o = _ctx.SBH_TR_QUESTIONS.OrderByDescending(s => s.ID).First(); maxid = o.ID + 1; } catch { maxid = maxid + 1; } SBH_TR_QUESTIONS a = new SBH_TR_QUESTIONS() { ID_CATEGORY = par.ID_CATEGORY, ID_USER = par.ID_USER, QUESTIONS = par.QUESTIONS, CREATED_TIME = DateTime.Now, CREATED_BY = par.USER_NAME, ROW_STATUS = fn.fg.IsActive, MOST_COMMENT = 0, TITLE_QUESTIONS = par.TITLE_QUESTIONS, MAXID = maxid }; _ctx.SBH_TR_QUESTIONS.Add(a); _ctx.SaveChanges(); SBH_TM_USER_ADMIN b = _ctx.SBH_TM_USER_ADMIN.Find(par.ID_USER); if (b != null) { int x = 0; if (!String.IsNullOrWhiteSpace(b.MOST_ACT_QUESTIONS.ToString())) { x = int.Parse(b.MOST_ACT_QUESTIONS.ToString()); } b.MOST_ACT_QUESTIONS = x + 1; b.MOST_ACT_QUESTIONS_DATE = DateTime.Now; _ctx.Entry(b).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); } flag = "1"; res = new object[] { flag, maxid }; } catch (Exception ex) { res = new object[] { flag, "" }; throw new Exception(ex.Message); } return(res); }
public bool Delete(int id) { bool res = false; try { SBH_TR_QUESTIONS a = _ctx.SBH_TR_QUESTIONS.Find(id); a.ROW_STATUS = fn.fg.NotActive; _ctx.Entry(a).State = System.Data.Entity.EntityState.Modified; res = true; } catch (Exception ex) { throw new Exception(ex.Message); } 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); }