/// <summary>
/// Update UserGroup
/// </summary>
/// <param name="updateDto">
/// Dto that contains all UserGroup data
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int UpdateData(SYS_UserGroupsDto updateDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
using (BaseDao context = new BaseDao())
{
ms_usergroups userGroup = context.ms_usergroups.FirstOrDefault(ig => ig.ID.Equals(updateDto.Id));
if (userGroup != null)
{
userGroup.Name1 = updateDto.Name1;
userGroup.Name2 = updateDto.Name2;
userGroup.Name3 = updateDto.Name3;
userGroup.Description = updateDto.Description;
//userGroup.SystemData = CommonData.Status.Disable;
//Create Update information
this.CreateUpdateHistory(userGroup, CommonData.FunctionGr.SY_UserGroups);
//Save to database
//returnCode = context.Saves();
returnCode = context.Saves(CommonData.FunctionGr.SY_UserGroups, CommonData.Action.Update, new { userGroup.Code, userGroup.Name1, userGroup.Name2, userGroup.Name3, userGroup.Description }, typeof(ms_usergroups).Name);
}
else
{
returnCode = CommonData.DbReturnCode.DataNotFound;
}
}
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <summary>
/// Delete UserGroup list
/// </summary>
/// <param name="listDeleteData">
/// List that contains UserGroup id
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int DeleteData(List <int> listDeleteData)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
List <object> lstHis = new List <object>();
using (BaseDao context = new BaseDao())
{
foreach (var id in listDeleteData)
{
ms_usergroups userGroup = context.ms_usergroups.FirstOrDefault(ig => ig.ID.Equals(id));
if (userGroup != null)
{
//Delete object
context.ms_usergroups.DeleteObject(userGroup);
lstHis.Add(new { userGroup.Code, userGroup.Name1, userGroup.Name2, userGroup.Name3, userGroup.Description });
}
else
{
return(CommonData.DbReturnCode.DataNotFound);
}
}
//Save to database
//returnCode = context.Saves();
returnCode = context.Saves(CommonData.FunctionGr.SY_UserGroups, CommonData.Action.Delete, lstHis, typeof(ms_usergroups).Name);
}
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <summary>
/// Insert new UserGroup
/// </summary>
/// <param name="insertDto">
/// Dto that contains all UserGroup data
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int InsertData(SYS_UserGroupsDto insertDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
using (BaseDao context = new BaseDao())
{
ms_usergroups userGroup = new ms_usergroups();
userGroup.Code = CommonMethod.ParseString(insertDto.Code);
userGroup.Name1 = CommonMethod.ParseString(insertDto.Name1);
userGroup.Name2 = CommonMethod.ParseString(insertDto.Name2);
userGroup.Name3 = CommonMethod.ParseString(insertDto.Name3);
userGroup.Description = insertDto.Description;
userGroup.SystemData = CommonData.Status.Disable;
//Create insert information
this.CreateInsertHistory(userGroup, CommonData.FunctionGr.SY_UserGroups);
//Add itemGroup
context.ms_usergroups.AddObject(userGroup);
//Save to database
//returnCode = context.Saves();
returnCode = context.Saves(CommonData.FunctionGr.SY_UserGroups, CommonData.Action.Insert,
new { userGroup.Code, userGroup.Name1, userGroup.Name2, userGroup.Name3, userGroup.Description, userGroup.SystemData },
typeof(ms_usergroups).Name);
}
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
public int InsertPermissionData(SYS_UserGroupsDto permissionDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
using (BaseDao context = new BaseDao())
{
try
{
context.BeginTransaction();
ms_usergroups userGroup = context.ms_usergroups.FirstOrDefault(ig => ig.Code.Equals(permissionDto.GroupCode));
if (userGroup != null)
{
#region Assign function
#region Remove old permission
//Remove function assign
IQueryable <ms_permissionsassign> lstFunctionPermission = context.ms_permissionsassign.Where(p => p.GroupCode.Equals(userGroup.Code));
foreach (ms_permissionsassign permission in lstFunctionPermission)
{
//Delete from database
context.ms_permissionsassign.DeleteObject(permission);
}
#endregion Remove old permission
#region Insert new permission
//insert function assign
foreach (SYS_PermissionAssignDto mappingDto in permissionDto.Mappings)
{
ms_permissionsassign permissionsAssign = new ms_permissionsassign();
permissionsAssign.GroupCode = userGroup.Code;
permissionsAssign.MappingID = mappingDto.MappingId;
permissionsAssign.SystemData = CommonData.Status.Disable;
//Create insert infomation
this.CreateInsertHistory(permissionsAssign, CommonData.FunctionGr.SY_UserGroups);
//Add to database
context.ms_permissionsassign.AddObject(permissionsAssign);
}
#endregion Insert new permission
#endregion Assign function
#region Assign warehouse
#region Remove old warehouse
//Remove warehouse assign
IQueryable <ms_warehouseassign> lstWHPermission = context.ms_warehouseassign.Where(p => p.GroupCode.Equals(userGroup.Code));
foreach (ms_warehouseassign whAssign in lstWHPermission)
{
//Delete from database
context.ms_warehouseassign.DeleteObject(whAssign);
}
#endregion Remove old warehouse
#region Insert new warehouse
//insert warehouse assign
foreach (MS_WarehouseAssignDto mappingDto in permissionDto.WHMappings)
{
if (!CommonMethod.IsNullOrEmpty(mappingDto.WarehouseCode))
{
ms_warehouseassign whAssign = new ms_warehouseassign();
whAssign.GroupCode = userGroup.Code;
whAssign.WarehouseCode = mappingDto.WarehouseCode;
//whAssign.OperID = mappingDto.OperID;
//whAssign.SystemData = CommonData.Status.Disable;
//Create insert infomation
this.CreateInsertHistory(whAssign, CommonData.FunctionGr.SY_UserGroups);
//Add to database
context.ms_warehouseassign.AddObject(whAssign);
}
}
#endregion Insert new warehouse
#endregion Assign warehouse
returnCode = context.Saves();
if (returnCode == 0)
{
returnCode = context.Commit();
}
else
{
context.Rollback();
}
}
else
{
context.Rollback();
returnCode = CommonData.DbReturnCode.DataNotFound;
}
}
catch (Exception ex)
{
context.Rollback();
returnCode = this.ProcessDbException(ex);
}
}
return(returnCode);
}
