public ServiceResult <object> AutocompleteView(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tableName = Util.GetSqlServerTableName <DataLayer.Model.Core.Person.Person>();
var queryString =
$"select * from (select EntityId as entityId,FirstName as firstName,LastName as lastName,FullTitle as fullTitle,Deleted as deleted,AccessKey as accessKey,CreateBy as createBy 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 personList = unitOfWork.Person.CreateNativeQuery(queryString, x =>
new Dictionary <string, object>
{
{ "entityId", Convert.ToInt64(x[0].ToString()) },
{ "fullName", $"{x[1]} {x[2]}" },
{ "firstName", $"{x[1]}" },
{ "lastName", $"{x[2]}" },
{ "fullTitle", x[3]?.ToString() }
});
return(personList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(personList, personList.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 <DataLayer.Model.Core.UseCase.UseCase>();
var queryString =
$"select * from (select EntityId as entityId,UseCaseName as useCaseName,Clazz as clazz,TableName as tableName,FullTitle as fullTitle,CreateBy as createBy,AccessKey as accessKey,Deleted as deleted from {tableName}) e" +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var unitOfWork = new UnitOfWork())
{
var useCaseList = unitOfWork.UseCase.CreateNativeQuery(queryString, x => new UseCaseDto
{
EntityId = Convert.ToInt64(x[0].ToString()),
UseCaseName = x[1]?.ToString(),
Clazz = x[2]?.ToString(),
TableName = x[3]?.ToString(),
FullTitle = x[4]?.ToString()
});
return(useCaseList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(useCaseList, useCaseList.Count));
}
}
catch (Exception ex)
{
return(ExceptionUtil.ExceptionHandler(ex, 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.File.File>();
var queryString = $"select * from (SELECT * FROM {tableName}) e" +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false,
true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var content = new ParsiContext())
{
var files = content.File.FromSqlRaw(queryString).OrderBy(x => x.Extension)
.ThenByDescending(x => x.Created).IgnoreQueryFilters().ToList();
var lstData = files.Select(file => Copier.GetDto(file)).ToList();
return(lstData.Count <= 0
? new ServiceResult <object>(new List <FileDto>(), 0)
: new ServiceResult <object>(lstData, lstData.Count));
}
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, 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 <DataLayer.Model.Core.AccessGroup.AccessGroup>();
var queryString =
"select * from (select EntityId,Name,FullTitle,code,CreateBy,AccessKey,Deleted from " +
tableName + " where code <> 'ADMIN') e" +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var unitOfWork = new UnitOfWork())
{
var accessGroupList = unitOfWork.AccessGroup.CreateNativeQuery(queryString, x =>
new Dictionary <string, object>
{
{ "entityId", Convert.ToInt64(x[0].ToString()) },
{ "name", Convert.ToInt64(x[1].ToString()) },
{ "fullTitle", Convert.ToInt64(x[2].ToString()) }
});
return(accessGroupList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(accessGroupList, accessGroupList.Count));
}
}
catch (Exception ex)
{
return(ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> AutocompleteViewParent(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var tableName = Util.GetSqlServerTableName <DataLayer.Model.Core.ComboVal.ComboVal>();
var queryString =
$"SELECT * FROM(SELECT e1.EntityId AS entityId,e1.Name AS name,e1.Value AS value,e1.code AS code,e2.Name AS parentName,e2.code AS parentCode,e1.Deleted,e1.FullTitle AS fullTitle,e1.AccessKey,e1.CreateBy FROM {tableName} e1 LEFT JOIN {tableName} e2 on e1.ParentId = e2.EntityId where e1.Deleted = 0 and e2.Deleted = 0) e" +
QueryUtil.GetWhereClause(bp.Clause,
QueryUtil.GetConstraintForNativeQuery(bp, ClassDetails[0].Clazz, false, false, true)) +
QueryUtil.GetOrderByClause(bp.Clause);
using (var unitOfWork = new UnitOfWork())
{
var comboList = unitOfWork.ComboVal.CreateNativeQuery(queryString, x => new ComboValDto
{
EntityId = Convert.ToInt64(x[0].ToString()),
Name = x[1]?.ToString(),
Value = x[2]?.ToString(),
Code = x[3]?.ToString()
});
return(comboList.Count == 0
? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکوردی یافت نشد")
: new ServiceResult <object>(comboList, comboList.Count));
}
}
catch (Exception ex)
{
return(ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> GridView(BusinessParam bp)
{
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,fullTitle,deleted,createBy,accessKey from (select EntityId as entityId,FullTitle as fullTitle ,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 {tblEntity} 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);
queryString = QueryUtil.SetPaging(bp.Clause.PageNo, bp.Clause.PageSize, queryString);
using (var unitOfWork = new UnitOfWork())
{
var entityStateList = unitOfWork.EntityState.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(),
x[4]?.ToString(),
x[5]?.ToString(),
x[6]?.ToString(),
x[7]?.ToString()
});
if (entityStateList.Count == 0)
{
return(new ServiceResult <object>(new List <EntityStateDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[]
{
"entityId", "tblName", "tblEntityId", "organizationName", "userRoleRoleName",
"userLockerFirstName", "userLockerLastName"
};
list.Add(headerTitle);
list.AddRange(entityStateList);
return(new ServiceResult <object>(list, entityStateList.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 <Users>();
var queryString =
$"select entityId,firstName,lastName,username,attempt,lastVisit,deleted,fullTitle,createBy,accessKey from (select EntityId as entityId, FirstName as firstName,LastName as lastName,Username as username,Attempt as attempt,LastVisit as lastVisit,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 usersList = unitOfWork.Users.CreateNativeQuery(queryString, x => new[]
{
x[0] != null ? Convert.ToInt32(x[0]) : (object)null,
x[1] != null ? Convert.ToInt32(x[1]) : (object)null,
x[2]?.ToString(),
x[3]?.ToString(),
x[4]?.ToString(),
x[5]?.ToString(),
Util.GetTimeStamp(string.IsNullOrEmpty(x[6]?.ToString())
? (DateTime?)null
: Convert.ToDateTime(x[6].ToString()))
});
if (usersList.Count == 0)
{
return(new ServiceResult <object>(new List <PersonDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[]
{ "entityId", "firstName", "lastName", "username", "attempt", "lastVisit" };
list.Add(headerTitle);
list.AddRange(usersList);
return(new ServiceResult <object>(list, usersList.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.Person.Person>();
var queryString =
$"select * from (select entityId,firstName,lastName,NationalCode,fatherName,birthDate,deleted,fullTitle,createBy,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 personList = unitOfWork.Person.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(),
x[4]?.ToString(),
x[5]?.ToString(),
Util.GetTimeStamp(string.IsNullOrEmpty(x[6]?.ToString())
? (DateTime?)null
: Convert.ToDateTime(x[6].ToString()))
});
if (personList.Count == 0)
{
return(new ServiceResult <object>(new List <PersonDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[]
{ "entityId", "firstName", "lastName", "nationalCode", "fatherName", "birthDate" };
list.Add(headerTitle);
list.AddRange(personList);
return(new ServiceResult <object>(list, personList.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.ComboVal.ComboVal>();
var queryString =
"select entityId,name,value,code,parentId,fullTitle,createBy,accessKey from (select data.EntityId as entityId,data.Name as name,data.Value as value,data.Code as code,parent.Name as parentId,data.FullTitle as fullTitle,data.Deleted as deleted,data.CreateBy as createBy,data.AccessKey as accessKey from (select EntityId,Name,Value,Code,ParentId,FullTitle,Deleted,AccessKey,CreateBy from " +
tableName + " where Deleted =0) data left join(select EntityId, Name from " + tableName +
" where Deleted = 0) parent on data.ParentId = parent.EntityId ) 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 comboList = unitOfWork.ComboVal.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(),
x[4]?.ToString(),
x[5]?.ToString()
});
if (comboList.Count == 0)
{
return(new ServiceResult <object>(new List <ComboValDto>(), 1));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "name", "value", "code", "parentName" };
list.Add(headerTitle);
list.AddRange(comboList);
return(new ServiceResult <object>(list, comboList.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.Menu.Menu>();
var tblUseCase = Util.GetSqlServerTableName <DataLayer.Model.Core.UseCase.UseCase>();
var queryString =
$"select entityId,useCaseName,name,title,orderNode,parentName,useCase,parentId,deleted,createBy,fullTitle,accessKey from ( select EntityId as entityId, Name as name,Title as title, OrderNode as orderNode,useCaseTarget.useCaseName as useCaseName ,parentMenu.parentName as parentName, ParentId as parentId, UseCase as useCase,Deleted as deleted , CreateBy as createBy , AccessKey as accessKey, FullTitle as fullTitle from {tableName} as mainData left join (select EntityId as useCaseEntityId,UseCaseName as useCaseName from {tblUseCase}) as useCaseTarget on useCaseTarget.useCaseEntityId = mainData.UseCase left join (select EntityId as parentEntityId , Name as parentName from {tableName}) as parentMenu on parentMenu.parentEntityId = mainData.ParentId ) 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 lstMenu = unitOfWork.Menu.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(),
x[4]?.ToString(),
x[5]?.ToString(),
x[6]?.ToString()
});
if (lstMenu.Count == 0)
{
return(new ServiceResult <object>(new List <MenuDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "useCase", "name", "title", "orderNode", "parent" };
list.Add(headerTitle);
list.AddRange(lstMenu);
return(new ServiceResult <object>(list, lstMenu.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.UseCase.UseCase>();
var queryString =
$"select entityId,useCaseName,clazz,tableName,uName as parent,ParentId,createBy,accessKey,fullTitle,deleted from (select * from (select EntityId as entityId, UseCaseName as useCaseName, Clazz as clazz, TableName as tableName, ParentId, CreateBy as createBy, FullTitle as fullTitle, AccessKey As accessKey, Deleted as deleted from {tableName} where code <> 'ADMIN') as currentUseCase left join(select EntityId as eId, UseCaseName as uName from {tableName}) as parentUseCase on currentUseCase.ParentId = parentUseCase.eId) 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 useCaseList = unitOfWork.UseCase.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(),
x[4]?.ToString(),
x[5]?.ToString()
});
if (useCaseList.Count == 0)
{
return(new ServiceResult <object>(new List <UseCaseDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "useCaseName", "clazz", "tableName", "parent" };
list.Add(headerTitle);
list.AddRange(useCaseList);
return(new ServiceResult <object>(list, useCaseList.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.Location.Location>();
var tableNameComboVal = Util.GetSqlServerTableName <DataLayer.Model.Core.ComboVal.ComboVal>();
var queryString =
$"select entityId,name,typeName,type,parentName,parentId,fullTitle,deleted,createBy,accessKey from ( select combo.comboName as typeName,parent.parentName as parentName, EntityId as entityId, Name as name,Type as type,ParentId as parentId,FullTitle as fullTitle,Deleted as deleted,CreateBy as createBy,AccessKey as accessKey from {tableName} as mainLocation left join (select EntityId as comboId,Name as comboName from {tableNameComboVal}) as combo on combo.comboId = mainLocation.type left join (select EntityId as parentEntityId,Name as parentName from {tableName}) as parent on parent.parentEntityId = mainLocation.ParentId ) 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 locationList = unitOfWork.Location.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(),
x[5]?.ToString()
});
if (locationList.Count == 0)
{
return(new ServiceResult <object>(new List <LocationDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "name", "type", "parent" };
list.Add(headerTitle);
list.AddRange(locationList);
return(new ServiceResult <object>(list, locationList.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.Action.Action>();
var queryString =
$"select * from (select EntityId as entityId,ActionName as actionName,ActionEnName as actionEnName,FullTitle as fullTitle,Deleted as deleted,AccessKey as accessKey,CreateBy as createBy from {tableName}) 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 actionList = unitOfWork.Action.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 (actionList.Count == 0)
{
return(new ServiceResult <object>(new List <ActionDto>(), 0));
}
var list = new List <object>();
var headerTitle = new object[] { "entityId", "actionName", "actionEnName" };
list.Add(headerTitle);
list.AddRange(actionList);
return(new ServiceResult <object>(list, actionList.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));
}
}
