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> 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 async Task <IActionResult> Download(string file, BusinessParam bp, bool thumbnail)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
var lastPoint = file.LastIndexOf(".", StringComparison.Ordinal);
var link = file.Substring(0, lastPoint);
var jsonFileDto = GetJsonDto(Encryption.Decryption(FileRepositoryFacade.ReplaceValidCharacter(link)));
var fileDto = GetFileFromDataBaseWithId(jsonFileDto.EntityId, null);
var path = bp.Environment.WebRootPath + fileDto.Path;
if (thumbnail)
{
var lastIndexOf = path.LastIndexOf(".", StringComparison.Ordinal);
var substring = path.Substring(0, lastIndexOf);
substring += "_thumb" + path.Substring(lastIndexOf);
path = substring;
}
var stream = new FileStream(path, FileMode.Open);
return(new FileStreamResult(stream, FileRepositoryFacade.MimType[fileDto.Extension])
{
FileDownloadName = fileDto.Name + "." + fileDto.Extension
});
}
catch (Exception e)
{
ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, null);
return(null);
}
}
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> Delete(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
long entityId = 0;
if (bp.Clause?.Wheres != null && bp.Clause.Wheres.Count > 0)
{
foreach (var item in bp.Clause.Wheres.Where(item => item.Key.Equals("entityId")))
{
entityId = long.Parse(item.Value);
}
}
using (var unitOfWork = new UnitOfWork())
{
var record = unitOfWork.File.GetRecord(entityId);
if (record == null)
{
return(new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "فایل مورد نظر یافت نشد"));
}
record.Deleted = record.EntityId;
unitOfWork.File.Update(record);
unitOfWork.File.Save();
return(new ServiceResult <object>(Copier.GetDto(record), 1));
}
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> DeletedList(BusinessParam bp, long roleId)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
using (var unitOfWork = new UnitOfWork())
{
var accessGroups = unitOfWork.RoleAccessGroup.Get(p => p.Role == roleId).ToList();
foreach (var item in accessGroups)
{
unitOfWork.RoleAccessGroup.Delete(item);
Elastic <RoleAccessGroupDto, DataLayer.Model.Core.RoleAccessGroup.RoleAccessGroup> .SaveToElastic(
item, ClassDetails[0].Clazz, bp);
}
unitOfWork.UseCaseActionAccessGroup.Save();
}
return(new ServiceResult <object>(true, 1));
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public ServiceResult <object> ShowRow(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
long entityId = 0;
foreach (var where in bp.Clause.Wheres.Where(where =>
where.Key.Equals("entityId") && where.Value != null && !where.Value.Equals("")))
{
entityId = long.Parse(where.Value);
}
try
{
if (entityId == 0)
{
return(ExceptionUtil.ExceptionHandler("شناسه مورد نظر یافت نشد",
ClassDetails[0].Facade + methodName,
bp.UserInfo));
}
using (var content = new ParsiContext())
{
var data = content.AccessGroup.Where(p => p.EntityId == entityId).Include(p => p.CreateUserEntity)
.Include(p => p.UpdateUserEntity).Include(p => p.ParentAccessGroupUseCaseActionAccessGroup)
.ThenInclude(p => p.CurrentUseCaseAction).ThenInclude(p => p.CurrentAction).IgnoreQueryFilters()
.ToList();
return(new ServiceResult <object>(Copier.GetDto(data[0]), 1));
}
}
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.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> Save(BusinessParam bp, PersonDto dto)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
DataLayer.Model.Core.Person.Person person;
if (dto.EntityId == 0)
{
using (var unitOfWork = new UnitOfWork())
{
person = Copier.GetEntity(dto, bp, true);
unitOfWork.Person.Insert(person);
unitOfWork.Person.Save();
}
}
else
{
using (var unitOfWork = new UnitOfWork())
{
person = Copier.GetEntity(dto, bp, false);
unitOfWork.Person.Update(person);
unitOfWork.Person.Save();
}
}
Elastic <PersonDto, DataLayer.Model.Core.Person.Person> .SaveToElastic(person, ClassDetails[0].Clazz, bp);
return(new ServiceResult <object>(Copier.GetDto(person), 1));
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public FrmDockReport()
{
InitializeComponent();
_errProvider = new ErrorProvider();
_basicService = new BasicService();
_srvParcel = new dtxk.business.Services.ServiceParcel(_basicService.dtxkContext);
_srvPhysicalPerson = new ServicePhysicalPerson(_basicService.dtxkContext);
_srvLegalPerson = new ServiceLegalPerson(_basicService.dtxkContext);
_srvDocPrcl = new ServiceDocumentedParcel(_basicService.dtxkContext);
_srvUser = new ServiceAppUser(_basicService.dtxkContext);
_businessParam = new BusinessParam(UserSettings.UserId);
_workerSearchCadastreNo = new BackgroundWorker();
_workerSearchCadastreNo.DoWork += new DoWorkEventHandler(_backgroundWorker_DoWork);
_workerSearchCadastreNo.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_backgroundWorker_RunWorkerCompleted);
_workerSearchPhysicalPerson = new BackgroundWorker();
_workerSearchPhysicalPerson.DoWork += new DoWorkEventHandler(_workerSearchPhysicalPerson_DoWork);
_workerSearchPhysicalPerson.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_workerSearchPhysicalPerson_RunWorkerCompleted);
_workerSearchLegalPerson = new BackgroundWorker();
_workerSearchLegalPerson.DoWork += new DoWorkEventHandler(_workerSearchLegalPerson_DoWork);
_workerSearchLegalPerson.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_workerSearchLegalPerson_RunWorkerCompleted);
// _workerSearchParcelOwner = new BackgroundWorker();
// _workerSearchParcelOwner.DoWork += new DoWorkEventHandler(_workerSearchParcelOwner_DoWork);
// _workerSearchParcelOwner.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_workerSearchParcelOwner_RunWorkerCompleted);
}
public async Task <IActionResult> Download(string file)
{
var thumbnail = Request.Query.ContainsKey("thumbnail");
var bp = new BusinessParam(_hostEnvironment);
return(await FileFacade.GetInstance().Download(file, bp, thumbnail));
}
public Users GetEntity(UserDto dto, BusinessParam bp, bool setCreate)
{
var user = new Users
{
EntityId = dto.EntityId,
Username = dto.Username,
Password = dto.Password,
EmailCode = dto.EmailCode,
PhoneCode = dto.PhoneCode,
Attempt = dto.Attempt,
LastVisit = Util.GetDateTime(dto.LastVisit),
Active = dto.Active,
Code = dto.Code,
Deleted = dto.Deleted,
FullTitle = dto.Username + " | " + dto.FirstName + " | " + dto.LastName,
FirstName = dto.FirstName,
LastName = dto.LastName,
PersonId = dto.PersonId,
IsAdmin = dto.IsAdmin
};
if (string.IsNullOrEmpty(user.Code))
{
user.Code = "-";
}
return(SetMandatoryField(user, bp, setCreate));
}
public ServiceResult <object> GetAllMenu(Clause clause)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
if (userInfo == null)
{
return(new ServiceResult <object>(Enumerator.ErrorCode.UserExpired,
"زمان استفاده از حساب کاربری به پایان رسیده است"));
}
var bp = new BusinessParam(userInfo, clause);
var data = new List <MenuDto>();
if (_memoryCache.TryGetValue("Menu_" + bp.UserInfo.RoleId, out data))
{
return(new ServiceResult <object>(data, data.Count));
}
var myServiceData = MenuFacade.GetInstance().GetAllMenu(bp);
if (myServiceData.Done)
{
data = (List <MenuDto>)myServiceData.Result;
_memoryCache.Set("Menu_" + bp.UserInfo.RoleId, data,
TimeSpan.FromMinutes(DataLayer.Tools.SystemConfig.MenuCacheTimeMinute));
}
return(myServiceData);
}
public ServiceResult <object> Save(FileDto dto)
{
var userInfo = _userSessionManager.GetUserInfo(dto.Ticket, Request);
var bp = new BusinessParam(userInfo);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, dto.EntityId == 0 ? "insert" : "update");
return(checkAccess.Done ? FileFacade.GetInstance().Save(bp, dto) : checkAccess);
}
public static void SaveToElastic(TE entity, string clazz, BusinessParam businessParam)
{
try
{
}
catch (Exception ex)
{
}
}
public static void SaveToHistory(TE entity, BusinessParam businessParam)
{
try
{
}
catch (Exception ex)
{
}
}
public ServiceResult <object> AutocompleteView(Clause clause)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
var bp = new BusinessParam(userInfo, clause);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "autocomplete");
return(checkAccess.Done
? EntityStateFacade.GetInstance().AutocompleteView(bp)
: checkAccess);
}
public ServiceResult <object> GetTotalUseCase(Clause clause, bool getAllData, string term, string pageNumber)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
var bp = new BusinessParam(userInfo, clause);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "gridView");
return(checkAccess.Done
? UseCaseFacade.GetInstance().GetTotalUseCase(bp, getAllData, term, pageNumber)
: checkAccess);
}
public ServiceResult <object> CreateFolder(FolderDto dto)
{
var userInfo = _userSessionManager.GetUserInfo(dto.Ticket, Request);
var bp = new BusinessParam(userInfo, _hostEnvironment);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "insert");
return(checkAccess.Done
? FileFacade.GetInstance().CreateFolder(bp, dto)
: checkAccess);
}
public ServiceResult <object> GridView(Clause clause)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
var bp = new BusinessParam(userInfo, clause);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "gridView");
return(checkAccess.Done
? UseCaseFacade.GetInstance().GridView(bp)
: checkAccess);
}
public ServiceResult <object> Delete(Clause clause)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
var bp = new BusinessParam(userInfo, clause);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "delete");
return(checkAccess.Done
? PersonFacade.GetInstance().Delete(bp)
: checkAccess);
}
public ServiceResult <object> ShowRow(Clause clause)
{
var userInfo = _userSessionManager.GetUserInfo(clause.Ticket, Request);
var bp = new BusinessParam(userInfo, clause);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "update");
return(checkAccess.Done
? SystemConfigFacade.GetInstance().ShowRow(bp)
: checkAccess);
}
public ServiceResult <object> CreateFile()
{
var ticket = Request.Form["ticket"];
var userInfo = _userSessionManager.GetUserInfo(ticket, Request);
var bp = new BusinessParam(userInfo, _hostEnvironment);
var checkAccess = _userSessionManager.CheckAccess(bp, ClassDetails[0].Clazz, "insert");
return(checkAccess.Done
? FileFacade.GetInstance().CreateFile(bp, Request).Result
: checkAccess);
}
public BusinessAccessDto AddList(BusinessParam bp, BusinessAccessDto dto)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
using (var unitOfWork = new UnitOfWork())
{
var item = unitOfWork.BusinessAccess.Get(p =>
p.UseCase == dto.UseCase && p.Role == dto.Role.EntityId &&
p.Organization == dto.Organization.EntityId).FirstOrDefault();
if (item != null)
{
var lstIds = new HashSet <string>();
var split = dto.EntityIds.Split(",");
foreach (var s in split)
{
if (!string.IsNullOrEmpty(s))
{
lstIds.Add(s.Trim());
}
}
if (dto.AddCurrentList)
{
var split2 = item.EntityIds.Split(",");
foreach (var s in split2)
{
if (!string.IsNullOrEmpty(s))
{
lstIds.Add(s.Trim());
}
}
}
var result = new StringBuilder();
foreach (var data in lstIds)
{
result.Append(data).Append(",");
}
item.EntityIds = result.ToString().Substring(0, result.ToString().Length - 1);
return(Copier.GetDto(item));
}
return(dto);
}
}
catch (Exception e)
{
ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo);
return(dto);
}
}
public DataLayer.Model.Core.UseCaseAction.UseCaseAction SetMandatoryField(
DataLayer.Model.Core.UseCaseAction.UseCaseAction useCaseAction,
BusinessParam bp, bool setCreate)
{
useCaseAction.AccessKey = bp.UserInfo.AccessKey;
useCaseAction.UpdateBy = bp.UserInfo.UserId;
useCaseAction.Updated = DateTime.Now;
if (!setCreate) return useCaseAction;
useCaseAction.CreateBy = bp.UserInfo.UserId;
useCaseAction.Created = DateTime.Now;
return useCaseAction;
}
public Users SetMandatoryField(Users user, BusinessParam bp, bool setCreate)
{
user.AccessKey = bp.UserInfo.AccessKey;
user.UpdateBy = bp.UserInfo.UserId;
user.Updated = DateTime.Now;
if (!setCreate)
{
return(user);
}
user.CreateBy = bp.UserInfo.UserId;
user.Created = DateTime.Now;
return(user);
}
public ServiceResult <object> ShowRow(BusinessParam bp)
{
var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}";
try
{
return(new ServiceResult <object>(Copier.GetDto(), 1));
}
catch (Exception e)
{
return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo));
}
}
public DataLayer.Model.Core.Organization.Organization SetMandatoryField(DataLayer.Model.Core.Organization.Organization organization,
BusinessParam bp, bool setCreate)
{
organization.UpdateBy = bp.UserInfo.UserId;
organization.Updated = DateTime.Now;
if (!setCreate)
{
return(organization);
}
organization.CreateBy = bp.UserInfo.UserId;
organization.Created = DateTime.Now;
return(organization);
}
public DataLayer.Model.Core.EntityState.EntityState SetMandatoryField(DataLayer.Model.Core.EntityState.EntityState entityState,
BusinessParam bp, bool setCreate)
{
entityState.AccessKey = bp.UserInfo.AccessKey;
entityState.UpdateBy = bp.UserInfo.UserId;
entityState.Updated = DateTime.Now;
if (!setCreate)
{
return(entityState);
}
entityState.CreateBy = bp.UserInfo.UserId;
entityState.Created = DateTime.Now;
return(entityState);
}
