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