public ServiceResult <object> GridView(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tableName = Util.GetSqlServerTableName <DataLayer.Model.Core.Role.Role>();
var queryString =
$"select entityId,roleName,expireMinute,deleted,fullTitle,createBy,accessKey from (select EntityId as entityId, RoleName as roleName,ExpireMinute as expireMinute,FullTitle as fullTitle,Deleted as deleted,CreateBy as createBy,AccessKey as accessKey from {tableName} where code <> 'ADMIN') e " +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
queryString = QueryUtil.SetPaging(bp.Clause.PageNo, bp.Clause.PageSize, queryString);
using (var unitOfWork = new UnitOfWork())
{
var roleList = unitOfWork.Role.CreateNativeQuery(queryString, x => new[]
{
x[0] != null ? Convert.ToInt32(x[0]) : (object)null,
x[1] != null ? Convert.ToInt64(x[1]) : (object)null,
x[2]?.ToString(),
x[3]?.ToString()
});
if (roleList.Count == 0)
{
return(new ServiceResult <object>(new List <RoleDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "roleName", "expireMinute" };
list.Add(headerTitle);
list.AddRange(roleList);
return(new ServiceResult <object>(list, roleList.Count));
}
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> GridView(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tableName = Util.GetSqlServerTableName <DataLayer.Model.Core.Organization.Organization>();
var queryString =
$"select * from ( select EntityId as entityId,Name as name,child.parentName,ParentId as parentId,FullTitle as fullTitle,Deleted as deleted , AccessKey as accessKey , CreateBy as createBy from {tableName} as org left join (select EntityId as parentEntityId,Name as parentName from {tableName}) child on child.parentEntityId = org.ParentId ) e " +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, false)) +
QueryUtil.GetOrderByClause(bp.Clause);
queryString = QueryUtil.SetPaging(bp.Clause.PageNo, bp.Clause.PageSize, queryString);
using (var unitOfWork = new UnitOfWork())
{
var orgList = unitOfWork.Organization.CreateNativeQuery(queryString, x => new[]
{
x[0] != null ? Convert.ToInt32(x[0]) : (object)null,
x[1] != null ? Convert.ToInt64(x[1]) : (object)null,
x[2]?.ToString(),
x[3]?.ToString()
});
if (orgList.Count == 0)
{
return(new ServiceResult <object>(new List <OrganizationDto>(), 1));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "name", "parent" };
list.Add(headerTitle);
list.AddRange(orgList);
return(new ServiceResult <object>(list, orgList.Count));
}
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> GetState(BusinessParam bp, EntityStateDto dto)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tblUser = Util.GetSqlServerTableName <Users>();
var tblOrganization = Util.GetSqlServerTableName <DataLayer.Model.Core.Organization.Organization>();
var tblRole = Util.GetSqlServerTableName <DataLayer.Model.Core.Role.Role>();
var tblEntity = Util.GetSqlServerTableName <DataLayer.Model.Core.EntityState.EntityState>();
var queryString =
$"select entityId,tableName,tblEntityId,organizationName,userRoleRoleName, userLockerFirstName,userLockerLastName,userEntityId,fullTitle,deleted,createBy,accessKey from(select EntityId as entityId,FullTitle as fullTitle,mainUser.userEntityId as userEntityId ,Deleted as deleted,CreateBy as createBy,AccessKey as accessKey,TableName as tableName,TableEntityId as tblEntityId,mainOrganization.orgName as organizationName,mainRole.roleName as userRoleRoleName,mainUser.userFirstName as userLockerFirstName,mainUser.lastName as userLockerLastName from(select * from {tblEntity} where TableName = N'{dto.TableName}' And TableEntityId = {dto.TableEntityId}) as mainData left join(select EntityId as roleEntityId,RoleName as roleName from {tblRole}) as mainRole on mainRole.roleEntityId = mainData.RoleId left join(select EntityId as OrganizationEntityId ,Name as orgName from {tblOrganization}) as mainOrganization on mainOrganization.OrganizationEntityId = mainData.OrganizationId left join(select EntityId as userEntityId,FirstName as userFirstName,LastName as lastName from {tblUser}) as mainUser on mainUser.userEntityId = mainData.UserId ) e " +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var unitOfWork = new UnitOfWork())
{
var entityStateList = unitOfWork.EntityState.CreateNativeQuery(queryString, x =>
new Dictionary <string, object>
{
{ "entityId", Convert.ToInt64(x[0].ToString()) },
{ "roleName", x[4].ToString() },
{ "name", x[5].ToString() },
{ "family", x[6].ToString() },
{ "orgName", x[3].ToString() },
{ "active", bp.UserInfo.UserId == Convert.ToInt64(x[7].ToString()) ? "1" : "0" }
});
return(entityStateList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(entityStateList[0], entityStateList.Count));
}
}
catch (Exception ex)
{
return(ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> AutocompleteView(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tableName = Util.GetSqlServerTableName <Users>();
var queryString =
$"select * from (select EntityId as entityId,PersonId as parentId,FirstName as firstName,LastName as lastName,Username as username, FullTitle as fullTitle,Deleted as deleted,CreateBy as createBy,AccessKey as accessKey from {tableName}) e" +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, true, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var unitOfWork = new UnitOfWork())
{
var usersList = unitOfWork.Users.CreateNativeQuery(queryString, x => new Dictionary <string, object>
{
{ "entityId", Convert.ToInt64(x[0].ToString()) },
{
"parentId",
!string.IsNullOrEmpty(x[1].ToString()) ? Convert.ToInt64(x[1].ToString()) : (long?)null
},
{ "firstName", x[2]?.ToString() },
{ "lastName", x[3]?.ToString() },
{ "username", x[4]?.ToString() },
{ "fullTitle", x[4]?.ToString() }
});
return(usersList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(usersList, usersList.Count));
}
}
catch (Exception ex)
{
return(ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
