public Login UserLogin(Login par)
{
try
{
Login oA = new Login();
SBH_TM_USER_ADMIN oB = _ctx.SBH_TM_USER_ADMIN.Where(d => d.ROW_STATUS == fn.fg.IsActive && d.USER_MAIL == par.Email && d.PASSWORD == par.Password).FirstOrDefault();
if (oB != null)
{
oA.UserId = oB.ID_USER_ADMIN;
oA.UserName = oB.USER_NAME;
oA.Id = oB.ID;
oA.IdGroup = int.Parse(oB.ID_GROUP.ToString());
oA.IsSuperAdmin = oB.IS_SUPER_ADMIN;
return(oA);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public ResultStatus ChangePassword(int id, string oldPassword, string newPassword)
{
ResultStatus rs = new ResultStatus();
try
{
SBH_TM_USER_ADMIN user = _ctx.SBH_TM_USER_ADMIN.Find(id);
if (user.PASSWORD == oldPassword)
{
user.LAST_MODIFIED_TIME = DateTime.Now;
user.LAST_MODIFIED_BY = user.USER_NAME;
user.PASSWORD = newPassword;
_ctx.Entry(user).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus("Change password has been success");
}
else if (user.PASSWORD == newPassword)
{
rs.SetErrorStatus("New password can not be same old password");
}
else
{
rs.SetErrorStatus("Old password is not match");
}
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public object[] Edit(int id, Register par)
{
object[] res = null;
try
{
if (par.ConfirmPassword != par.Password)
{
throw new Exception("password");
}
if (IsValidEmail(par.Email) == false)
{
throw new Exception("email");
}
SBH_TM_USER_ADMIN a = _ctx.SBH_TM_USER_ADMIN.Find(id);
SBH_TM_USER_PROFILE_ADMIN b = _ctx.SBH_TM_USER_PROFILE_ADMIN.Find(id);
if (a != null && b != null)
{
if (par.ID_GROUP != 0)
{
a.ID_GROUP = par.ID_GROUP;
}
a.USER_MAIL = par.Email;
a.USER_NAME = par.Name;
if (!string.IsNullOrWhiteSpace(par.Password) || !string.IsNullOrEmpty(par.Password))
{
a.PASSWORD = par.Password;
}
a.IS_SUPER_ADMIN = par.IsSuperAdmin;
a.ROW_STATUS = fn.fg.IsActive;
a.LAST_MODIFIED_TIME = DateTime.Now;
a.LAST_MODIFIED_BY = par.LAST_MODIFIED_BY;
_ctx.Entry(a).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
b.GENDER = par.Gender;
b.BORN = par.Born;
b.ADDRESS = par.Address;
b.DESCRIPTION = par.OtherDescription;
b.JOB = par.Job;
b.COMPANY = par.Company;
b.HOBBY = par.Hobby;
b.LAST_MODIFIED_TIME = DateTime.Now;
b.LAST_MODIFIED_BY = par.LAST_MODIFIED_BY;
_ctx.Entry(b).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
res = new object[] { true, fnn.fg.Save };
}
}
catch (Exception ex)
{
res = new object[] { false, 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 object[] Add(Register par)
{
object[] res = null;
try
{
if (par.ConfirmPassword != par.Password)
{
throw new Exception("password");
}
if (IsValidEmail(par.Email) == false)
{
throw new Exception("email");
}
var x = _ctx.SBH_TM_USER_ADMIN.ToList().Count();
SBH_TM_USER_ADMIN a = new SBH_TM_USER_ADMIN()
{
ID_USER_ADMIN = x.ToString(),
ID_GROUP = par.ID_GROUP,
USER_MAIL = par.Email,
USER_NAME = par.Name,
PASSWORD = par.Password,
IS_SUPER_ADMIN = par.IsSuperAdmin,
CREATED_TIME = DateTime.Now,
CREATED_BY = par.CREATED_BY == null ? par.Name : par.CREATED_BY,
ROW_STATUS = fn.fg.IsActive
};
_ctx.SBH_TM_USER_ADMIN.Add(a);
_ctx.SaveChanges();
SBH_TM_USER_PROFILE_ADMIN b = new SBH_TM_USER_PROFILE_ADMIN()
{
ID_USER_ADMIN = x,
GENDER = par.Gender,
BORN = par.Born,
ADDRESS = par.Address,
DESCRIPTION = par.OtherDescription,
JOB = par.Job,
COMPANY = par.Company,
HOBBY = par.Hobby,
CREATED_TIME = DateTime.Now,
CREATED_BY = par.CREATED_BY,
ROW_STATUS = fn.fg.IsActive
};
_ctx.SBH_TM_USER_PROFILE_ADMIN.Add(b);
_ctx.SaveChanges();
res = new object[] { true, fnn.fg.Save };
}
catch (Exception ex)
{
res = new object[] { false, ex.Message };
}
return(res);
}
public SelectList GetUserList()
{
List <SBH_TM_USER_ADMIN> users = _ctx.SBH_TM_USER_ADMIN.Where(x => x.ROW_STATUS == (int)EnumList.RowStatus.Active).ToList();
SBH_TM_USER_ADMIN user = new SBH_TM_USER_ADMIN {
ID = 0, USER_NAME = "Select User :"******"ID", "USER_NAME");
return(selectList);
}
public string GetPwd(int id)
{
string pwd = string.Empty;
try
{
SBH_TM_USER_ADMIN a = _ctx.SBH_TM_USER_ADMIN.Where(x => x.ROW_STATUS == fn.fg.IsActive && x.ID == id).FirstOrDefault();
pwd = a.PASSWORD;
}
catch (Exception ex)
{
throw;
}
return(pwd);
}
public bool Delete(int id)
{
bool res = false;
try
{
SBH_TM_USER_ADMIN a = _ctx.SBH_TM_USER_ADMIN.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);
}
