public string Post([Bind] Sys_GroupModel group)
{
var success = string.Empty;
var model = new Sys_GroupEntity
{
ID = group.ID,
Code = group.Code,
GroupName = group.GroupName,
IsActivate = group.IsActivate
};
var service = new Sys_GroupServices();
if (group.ID != Guid.Empty)
{
group.ID = group.ID;
success = service.Edit <Sys_GroupEntity>(model) + ",1";
}
else
{
success = service.Add <Sys_GroupEntity>(model) + ",0";
group.ID = model.ID;
}
return(success);
}
public void NUnit_Group_Domain_Get()
{
Sys_GroupServices service = new Sys_GroupServices();
var repo = service.GetAllUseEntity <Sys_Group>(ref status);
Console.Write("Total Record: " + repo.Count());
}
public void NUnit_Group_Domain_GetById()
{
Sys_GroupServices service = new Sys_GroupServices();
var model = new Sys_Group { Id = 2 };
var result = service.GetById<Sys_Group>(model.Id, ref status) as Sys_Group;
NUnit.Framework.Assert.IsNotNull(result);
Console.Write("SearchResult: " + result.Id
+ " | " + result.Code
+ " | " + result.GroupName
);
}
public void NUnit_Group_Domain_Edit()
{
Sys_GroupServices service = new Sys_GroupServices();
var model = new Sys_Group
{
Id = 1,
Code = "1",
GroupName = "Update GroupName ",
};
var result = service.Edit<Sys_Group>(model);
Console.WriteLine("Result" + result);
}
public void NUnit_Group_Domain_Edit()
{
Sys_GroupServices service = new Sys_GroupServices();
var model = new Sys_Group
{
Id = 1,
Code = "1",
GroupName = "Update GroupName ",
};
var result = service.Edit <Sys_Group>(model);
Console.WriteLine("Result" + result);
}
public void NUnit_Group_Domain_GetById()
{
Sys_GroupServices service = new Sys_GroupServices();
var model = new Sys_Group {
Id = 2
};
var result = service.GetById <Sys_Group>(model.Id, ref status) as Sys_Group;
NUnit.Framework.Assert.IsNotNull(result);
Console.Write("SearchResult: " + result.Id
+ " | " + result.Code
+ " | " + result.GroupName
);
}
// GET api/<controller>/5
public Sys_GroupModel Getbyid(Guid id)
{
var service = new Sys_GroupServices();
var result = service.GetSysGroupById(id);
var sysGroupModel = new Sys_GroupModel
{
ID = result.ID,
Code = result.Code,
GroupName = result.GroupName,
IsActivate = result.IsActivate,
Notes = result.Notes
};
return(sysGroupModel);
}
// GET api/<controller>
/// <summary>
/// Lấy tất cả dữ liệu
/// </summary>
/// <returns></returns>
public IQueryable <Sys_GroupModel> Get()
{
string status = string.Empty;
var service = new Sys_GroupServices();
var list = service.GetAllUseEntity <Sys_GroupEntity>(ref status).AsQueryable <Sys_GroupEntity>();
return(list.Select(item => new Sys_GroupModel
{
ID = item.ID,
GroupName = item.GroupName,
Code = item.Code,
IsActivate = item.IsActivate,
Notes = item.Description
}));
}
// DELETE api/<controller>/5
public void Delete(Guid id)
{
var service = new Sys_GroupServices();
var result = service.Delete <Sys_GroupEntity>(id);//delete nhóm (sys_Group)
if (id != Guid.Empty)
{
//delete ds nhóm quyền (sys_GroupPermission2)
string status = string.Empty;
BaseService baseService = new BaseService();
List <object> lstObj = new List <object>();
lstObj.Add(id);
service.UpdateData <Sys_GroupPermission2Entity>(lstObj, ConstantSql.hrm_sys_sp_delete_GroupPermission2, ref status);
}
}
public void NUnit_Group_Domain_Remove()
{
Sys_GroupServices service = new Sys_GroupServices();
int rs = 0;
var model = new Sys_Group {
Id = 1
};
var result = service.Remove <Sys_Group>(model.Id);
// NUnit.Framework.Assert.IsTrue(result);
if (result == ActionStatus.EditSucceed.ToString())
{
rs += 1;
Console.WriteLine("Process Success >>> Remove >>> " + model.Id);
}
}
public Sys_GroupModel Put(Sys_GroupModel model)
{
var group = new Sys_GroupEntity
{
ID = model.ID,
Code = model.Code,
GroupName = model.GroupName,
IsActivate = model.IsActivate,
};
var service = new Sys_GroupServices();
if (model.ID != Guid.Empty)
{
group.ID = model.ID;
service.Edit <Sys_GroupEntity>(group);
}
else
{
service.Add <Sys_GroupEntity>(group);
}
return(model);
}
public void NUnit_Group_Domain_Remove()
{
Sys_GroupServices service = new Sys_GroupServices();
int rs = 0;
var model = new Sys_Group { Id = 1 };
var result = service.Remove<Sys_Group>(model.Id);
// NUnit.Framework.Assert.IsTrue(result);
if (result == ActionStatus.EditSucceed.ToString())
{
rs += 1;
Console.WriteLine("Process Success >>> Remove >>> " + model.Id);
}
}
public void NUnit_Group_Domain_Get()
{
Sys_GroupServices service = new Sys_GroupServices();
var repo = service.GetAllUseEntity<Sys_Group>(ref status);
Console.Write("Total Record: " + repo.Count());
}
public Guid Post([FromBody] FormDataCollection grouppermissionInfo)
{
Guid groupId = Guid.Empty;
if (grouppermissionInfo != null)
{
#region Lưu Sys_GroupEntity
var groupInfos = grouppermissionInfo.Where(p => !p.Key.Contains("allow")).Distinct().ToList();
Guid id = Guid.Empty;
bool IsActivate = false;
#region Get Group Info
Guid.TryParse(groupInfos.Where(p => p.Key == "ID").Select(p => p.Value).FirstOrDefault(), out id);
var code = groupInfos.Where(p => p.Key == Sys_GroupModel.FieldNames.Code).Select(p => p.Value).FirstOrDefault();
var description = groupInfos.Where(p => p.Key == Sys_GroupModel.FieldNames.Notes).Select(p => p.Value).FirstOrDefault();
var groupName = groupInfos.Where(p => p.Key == Sys_GroupModel.FieldNames.GroupName).Select(p => p.Value).FirstOrDefault();
bool.TryParse(groupInfos.Where(p => p.Key == Sys_GroupModel.FieldNames.IsActivate).Select(p => p.Value).FirstOrDefault(), out IsActivate);
#endregion
var group = new Sys_GroupEntity()
{
ID = id,
IsActivate = IsActivate,
Code = code,
Notes = description,
GroupName = groupName
};
var groupService = new Sys_GroupServices();
if (group.ID == Guid.Empty)
{
//add
var statusAdding = groupService.Add <Sys_GroupEntity>(group);
groupId = group.ID;
}
else
{
//edit
string statusSysGroup = string.Empty;
groupId = id;
var statusEditing = groupService.GetSysGroupById(group.ID);
if (statusEditing != null)
{
statusEditing.IsActivate = group.IsActivate;
statusEditing.Code = group.Code;
statusEditing.Notes = group.Notes;
statusEditing.Description = group.Notes;
statusEditing.GroupName = group.GroupName;
groupService.Edit <Sys_GroupEntity>(statusEditing);
}
}
#endregion
List <Guid> listResourceId = new List <Guid>();
List <string> lstValue = grouppermissionInfo.Where(p => p.Key.Contains("allow") && p.Value != "0").Select(m => m.Value).Distinct().ToList();
var lstAdding = new List <Sys_GroupPermission2Entity>();
var lstEditing = new List <Sys_GroupPermission2Entity>();
var service = new Sys_GroupPermissionServices();
//[Tung.Ly 20150114] - Modify : lay danh sach Sys_GroupPermission2 bởi GroupID bằng entity thay vì dùng store
// Dùng store không lấy được dữ liệu => nên tạm thời dùng entity
var groupPermisstion2s = service.GetAllGroupPermissionByGroupId(groupId);
foreach (string itemValue in lstValue)
{
//lay thong tin nhom quyen
var lstgrouppermissionInfo = grouppermissionInfo.Where(m => m.Key.Contains("allow") && m.Value == itemValue).ToList();
int privilegeNumber = 0;
Guid resourceId = Guid.Empty;
Guid.TryParse(itemValue, out resourceId);
if (resourceId != Guid.Empty && !listResourceId.Any(p => p == resourceId))
{
listResourceId.Add(resourceId);
}
#region Get Privilege (View/Create/Modify/Delete/Export/Import)
foreach (var item in lstgrouppermissionInfo)
{
var lst = item.Key.Split(new char[] { '_' });
int number = int.Parse(lst[2]);
switch (number)
{
case 1:
privilegeNumber = privilegeNumber + (int)PrivilegeType.View;
break;
case 2:
privilegeNumber = privilegeNumber + (int)PrivilegeType.Create;
break;
case 3:
privilegeNumber = privilegeNumber + (int)PrivilegeType.Modify;
break;
case 4:
privilegeNumber = privilegeNumber + (int)PrivilegeType.Delete;
break;
case 5:
privilegeNumber = privilegeNumber + (int)PrivilegeType.Export;
break;
case 6:
privilegeNumber = privilegeNumber + (int)PrivilegeType.Import;
break;
}
}
#endregion
#region Thêm/chỉnh sửa nhóm quyền
groupId = group.ID;
var groupPermisstion = groupPermisstion2s.Where(p => p.ResourceID == resourceId).FirstOrDefault();
if (groupPermisstion == null || groupPermisstion.ID == Guid.Empty)
{
groupPermisstion = new Sys_GroupPermission2Entity
{
GroupID = groupId,
ResourceID = resourceId,
PrivilegeNumber = privilegeNumber
};
if (lstAdding.FirstOrDefault(p => p.ResourceID == resourceId && p.GroupID == groupId) == null)
{
lstAdding.Add(groupPermisstion);
}
}
else
{
if (groupPermisstion.PrivilegeNumber != privilegeNumber)
{
groupPermisstion.PrivilegeNumber = privilegeNumber;
//check groupPermission exist
if (lstEditing.FirstOrDefault(p => p.ResourceID == resourceId && p.GroupID == groupId) == null)
{
lstEditing.Add(groupPermisstion);
}
}
}
#endregion
}//close foreach
#region Thêm/Chỉnh sửa danh sách nhóm quyền (GroupPermission)
var gService = new Sys_GroupPermissionServices();
gService.CreateOrUpdateGroupPermission(groupId, lstAdding, lstEditing, listResourceId);
#endregion
}
return(groupId);
}
