public SYS_UserDetailDTO GetUserInfo(string userCode) { int returnCode = CommonData.DbReturnCode.Succeed; SYS_UserDetailDTO userDto = new SYS_UserDetailDTO(); try { using (BaseDao context = new BaseDao()) { ms_users user = context.ms_users.Where(c => c.Code == userCode).FirstOrDefault(); if (user != null) { userDto.ID = user.ID; userDto.FullName = user.DisplayName; userDto.UserName = user.Code; userDto.Status = user.Status; } } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(userDto); }
/// <summary> /// Get informations of user /// </summary> /// <param name="selectDto"></param> /// <param name="dtResult"></param> /// <returns></returns> public int SelectUsersData(SYS_UserDetailDTO selectDto, out DataTable dtResult) { int returnCode = CommonData.DbReturnCode.Succeed; dtResult = new DataTable(); try { using (BaseDao context = new BaseDao()) { IQueryable <ms_users> _users = context.ms_users.Where(u => u.Code == selectDto.UserName); #region Search data IEnumerable <SYS_UserDetailDTO> lstResult = _users.Select(ig => new SYS_UserDetailDTO { UserName = ig.Code, DisplayName = ig.DisplayName, }); dtResult = base.ToDataTable(lstResult); #endregion Search data } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }
public int UpdateData(Ivs.Core.Interface.IDto updateDto) { SYS_UserDAO _UserDAO = new SYS_UserDAO(); SYS_UserDetailDTO dto = (SYS_UserDetailDTO)updateDto; return(_UserDAO.UpdateData(dto)); }
public int InsertData(Ivs.Core.Interface.IDto insertDto) { SYS_UserDAO _UserDAO = new SYS_UserDAO(); SYS_UserDetailDTO dto = (SYS_UserDetailDTO)insertDto; return(_UserDAO.InsertData(dto)); }
public int SearchData(Ivs.Core.Interface.IDto selectDto, out System.Data.DataTable dtResult) { SYS_UserDAO _UserDAO = new SYS_UserDAO(); SYS_UserDetailDTO dto = (SYS_UserDetailDTO)selectDto; return(_UserDAO.SelectData(dto, out dtResult)); }
public int SelectData(SYS_UserDetailDTO selectDto, out DataTable dtResult) { int returnCode = CommonData.DbReturnCode.Succeed; dtResult = new DataTable(); try { using (BaseDao context = new BaseDao()) { //Search in ms_groupsassign table IQueryable <ms_groupsassign> groupsassign = context.ms_groupsassign.AsQueryable(); //if (!CommonMethod.IsNullOrEmpty(selectDto.UserName)) //{ // groupsassign = groupsassign.Where(ga => ga.UserCode.Contains(selectDto.UserName)); //} //if (!CommonMethod.IsNullOrEmpty(selectDto.FullName)) //{ // groupsassign = groupsassign.Where(ga => ga.GroupCode.Equals(selectDto.GroupCode)); //} //Search in ms_users table IQueryable <ms_users> user = context.ms_users.AsQueryable(); if (!CommonMethod.IsNullOrEmpty(selectDto.UserName)) { user = user.Where(u => u.Code.Contains(selectDto.UserName) && u.DisplayName.Contains(selectDto.FullName)); } //Search in ms_usergroups table IQueryable <ms_usergroups> groupuser = context.ms_usergroups.AsQueryable(); if (!CommonMethod.IsNullOrEmpty(selectDto.GroupCode)) { groupuser = groupuser.Where(ug => ug.Code.Equals(selectDto.GroupCode)); } var query = user.Where(c => c.Code.Contains(selectDto.UserName) && c.DisplayName.Contains(selectDto.FullName)); //Join User, UserGroup, GroupAssign var result = from u in query select new { ID = u.ID, UserName = u.Code, FullName = u.DisplayName, Password = u.Password, Status = u.Status, Profile = u.Profile, SystemData = u.SystemData }; dtResult = base.ToDataTable(result); } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }
public int UpdateData(SYS_UserDetailDTO _UserUpdateDto) { int returnCode = CommonData.DbReturnCode.Succeed; try { using (BaseDao context = new BaseDao()) { context.BeginTransaction(); #region Update User ms_users _users = context.ms_users.FirstOrDefault(u => u.ID.Equals(_UserUpdateDto.ID)); if (_users != null) { _users.ID = _UserUpdateDto.ID; _users.Code = _UserUpdateDto.UserName; _users.DisplayName = _UserUpdateDto.FullName; _users.Status = _UserUpdateDto.Status; _users.Password = _UserUpdateDto.Password; //Save to database //returnCode = context.Saves(); returnCode = context.Saves(CommonData.FunctionGr.SY_Users, CommonData.Action.Update, new { _users.Code, _users.DisplayName, _users.Status }, typeof(ms_users).Name); //Check if error occur if (returnCode != CommonData.DbReturnCode.Succeed) { context.Rollback(); return(returnCode); } } else { returnCode = CommonData.DbReturnCode.DataNotFound; } #endregion Update User #region Delete GroupAssign var _groupsassign = context.ms_groupsassign.AsQueryable(); _groupsassign = _groupsassign.Where(ga => ga.UserCode.Equals(_UserUpdateDto.UserName)); foreach (var ga in _groupsassign) { context.DeleteObject(ga); } #endregion Delete GroupAssign #region Insert data to GroupAssign Table ms_groupsassign groupsassign = null; foreach (var item in _UserUpdateDto.UserGroups) { groupsassign = new ms_groupsassign(); groupsassign.UserCode = _UserUpdateDto.UserName; groupsassign.GroupCode = item.Code; groupsassign.SystemData = "0"; context.ms_groupsassign.AddObject(groupsassign); returnCode = context.Saves(); } if (returnCode != CommonData.DbReturnCode.Succeed) { context.Rollback(); return(returnCode); } //Commit to database if (returnCode == CommonData.DbReturnCode.Succeed) { context.Commit(); } #endregion Insert data to GroupAssign Table } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }
public int InsertData(SYS_UserDetailDTO insertUserDto) { int returnCode = CommonData.DbReturnCode.Succeed; try { using (BaseDao context = new BaseDao()) { context.BeginTransaction(); #region Insert data to User Table //table user ms_users _users = new ms_users(); _users.Code = insertUserDto.UserName; _users.DisplayName = insertUserDto.FullName; _users.Password = insertUserDto.Password; _users.Profile = insertUserDto.Profile; _users.Status = insertUserDto.Status; _users.SystemData = "0"; //Add user context.ms_users.AddObject(_users); //Save to database //returnCode = context.Saves(); returnCode = context.Saves(CommonData.FunctionGr.SY_Users, CommonData.Action.Insert, new { _users.Code, _users.DisplayName, _users.Password, _users.Profile, _users.Status, _users.SystemData }, typeof(ms_users).Name); if (returnCode != CommonData.DbReturnCode.Succeed) { context.Rollback(); return(returnCode); } #endregion Insert data to User Table #region Insert data to GroupAssign Table ms_groupsassign _groupsassign = null; foreach (var item in insertUserDto.UserGroups) { _groupsassign = new ms_groupsassign(); _groupsassign.UserCode = insertUserDto.UserName; _groupsassign.GroupCode = item.Code; _groupsassign.SystemData = "0"; context.ms_groupsassign.AddObject(_groupsassign); returnCode = context.Saves(); } if (returnCode != CommonData.DbReturnCode.Succeed) { context.Rollback(); return(returnCode); } //Commit to database if (returnCode == CommonData.DbReturnCode.Succeed) { context.Commit(); } #endregion Insert data to GroupAssign Table } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }