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