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