public override List <cstRoleTbl> Execute()
{
List <cstRoleTbl> roleList = new List <cstRoleTbl>();
local_x3v6Entities context = new local_x3v6Entities();
switch (_action)
{
case csteActionenum.New:
Role role = new Role();
role.RoleId = Guid.NewGuid();
role.Name = _role.Name;
role.Action = _role.Action;
role.CreatedBy = GlobalClasses.ClGlobal.UserID;
role.CreatedDateTime = DateTime.UtcNow;
context.AddToRoles(role);
context.SaveChanges();
break;
case csteActionenum.Update:
Role roleTypeUpdate = context.Roles.First(i => i.RoleId == _role.RoleId);
roleTypeUpdate.Name = _role.Name;
roleTypeUpdate.Action = _role.Action;
roleTypeUpdate.Updatedby = GlobalClasses.ClGlobal.UserID;
roleTypeUpdate.UpdatedDateTime = DateTime.UtcNow;
context.SaveChanges();
break;
case csteActionenum.Delete:
break;
case csteActionenum.Get:
var result = from r in context.Roles
where r.RoleId == _id
select r;
foreach (var varRole in result)
{
cstRoleTbl objRole = new cstRoleTbl();
objRole.RoleId = varRole.RoleId;
objRole.Name = varRole.Name;
objRole.Action = varRole.Action;
roleList.Add(objRole);
}
break;
}
return(roleList);
}