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> 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.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> 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 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> 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> 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> 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 static void GenerateSiteMap(string url, double priority, DateTime date, int frequencyId, string path) { try { var list = new List <SitemapNode>(); var node = new SitemapNode { Url = url, Priority = priority, LastModified = date }; switch (frequencyId) { case 1: node.Frequency = SitemapFrequency.Always; break; case 2: node.Frequency = SitemapFrequency.Daily; break; case 3: node.Frequency = SitemapFrequency.Hourly; break; case 4: node.Frequency = SitemapFrequency.Weekly; break; case 5: node.Frequency = SitemapFrequency.Monthly; break; case 6: node.Frequency = SitemapFrequency.Yearly; break; case 7: node.Frequency = SitemapFrequency.Never; break; default: node.Frequency = SitemapFrequency.Always; break; } list.Add(node); new SitemapDocument().CreateSitemapXML(list, path); } catch (Exception ex) { ExceptionUtil.ExceptionHandler(ex, "SiteMapGenerator.GenerateSiteMap", null); } }
public ServiceResult <object> ActiveCode() { try { var phoneNumber = Request.Form["phoneNumber"].ToString(); var code = Request.Form["code"].ToString(); var captcha = Request.Form["captcha"].ToString(); if (string.IsNullOrEmpty(phoneNumber)) { return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "لطفا تلفن همراه را وارد نمایید")); } if (string.IsNullOrEmpty(code)) { return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "لطفا کد فعال سازی را وارد نمایید")); } if (string.IsNullOrEmpty(captcha)) { return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "لطفا کد امنیتی را وارد نمایید")); } if (!DataLayer.Tools.Captcha.ValidateCaptchaCode(captcha, Request.HttpContext)) { return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "کد امنیتی صحیح نمی باشد")); } using (var unitOfWork = new UnitOfWork()) { var user = unitOfWork.Users .Get(p => p.Username == phoneNumber.ToLower().Trim() && p.PhoneCode == code.Trim()) .FirstOrDefault(); if (user != null) { if (user.Deleted != 0) { return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "اطلاعاتی یافت نشد")); } user.PhoneCode = Util.RandomNumber(); user.Active = true; unitOfWork.Users.Update(user); unitOfWork.Users.Save(); return(new ServiceResult <object>(true, 1)); } return(new ServiceResult <object>(Enumerator.ErrorCode.ApplicationError, "اطلاعات ارسالی معتبر نمی باشد")); } } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, "AccountService.ActiveCode", null)); } }
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 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 ServiceResult <object> Save(BusinessParam bp, SystemConfigDto dto) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { Copier.GetEntity(dto); return(new ServiceResult <object>(dto, 1)); } 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 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> 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 context = new ParsiContext()) { var person = context.Person.Where(p => p.EntityId == entityId) .Include(p => p.CurrentFile) .Include(p => p.CurrentBloodType) .Include(p => p.CurrentCitizenship) .Include(p => p.CurrentDisabilityType) .Include(p => p.CurrentHealthStatus) .Include(p => p.CurrentHousingSituation) .Include(p => p.CurrentLifeStatus) .Include(p => p.CurrentMaritalStatus) .Include(p => p.CurrentMilitaryServiceStatus) .Include(p => p.CurrentNationality) .Include(p => p.CurrentSex) .Include(p => p.CurrentReligion) .Include(p => p.CurrentSubReligion) .Include(p => p.CreateUserEntity) .Include(p => p.UpdateUserEntity) .IgnoreQueryFilters() .ToList(); return(person.Count == 0 ? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکورد یافت نشد") : new ServiceResult <object>(Copier.GetDto(person[0]), 1)); } } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
public ServiceResult <object> Delete(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)); } DataLayer.Model.Core.UseCase.UseCase useCase; using (var unitOfWork = new UnitOfWork()) { useCase = unitOfWork.UseCase.GetRecord(entityId); } if (useCase == null) { return(ExceptionUtil.ExceptionHandler("شناسه مورد نظر یافت نشد", ClassDetails[0].Facade + methodName, bp.UserInfo)); } useCase.Deleted = useCase.EntityId; using (var unitOfWork = new UnitOfWork()) { unitOfWork.UseCase.Update(useCase); unitOfWork.UseCase.Save(); } Elastic <UseCaseDto, DataLayer.Model.Core.UseCase.UseCase> .SaveToElastic(useCase, ClassDetails[0].Clazz, bp); return(new ServiceResult <object>(true, 1)); } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
private string GetPathOfFile(JsonFileDto dto, BusinessParam bp) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { return ($"/service/file/download/{FileRepositoryFacade.ReplaceInValidCharacter(Encryption.Encrypt(GetJsonData(dto)))}.{dto.Extension}"); } catch (Exception ex) { ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo); return(""); } }
private async Task <ServiceResult <object> > CreateThumbnail(IFormFile formFile, FileDto fileDto, BusinessParam bp) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { var webRootPath = bp.Environment.WebRootPath; var dto = new FileDto { Alt = fileDto.Alt, DataSize = fileDto.DataSize, Description = fileDto.Description, DisplayInFileManager = false, Extension = fileDto.Extension, FullTitle = fileDto.FullTitle, Name = fileDto.Name, ParentId = fileDto.ParentId, Path = fileDto.Path, Thumbnail = fileDto.Thumbnail, Title = fileDto.Title }; var resize = new ImageResize(); resize.Resize(webRootPath + dto.Path, webRootPath + dto.Thumbnail); dto.DisplayInFileManager = false; dto.Path = dto.Thumbnail; var file = Copier.GetEntity(dto, bp, true); using (var unitOfWork = new UnitOfWork()) { var done = unitOfWork.File.Insert(file); unitOfWork.File.Save(); if (!done) { return(ExceptionUtil.ExceptionHandler("خطا در ذخیره فایل درون دیتابیس", ClassDetails[0].Facade + methodName, bp.UserInfo)); } Elastic <FileDto, DataLayer.Model.Core.File.File> .SaveToElastic(file, ClassDetails[0].Clazz, bp); dto.EntityId = file.EntityId; return(new ServiceResult <object>(dto, 1)); } } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
public ServiceResult <object> GetAllData(BusinessParam bp) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { using (var unitOfWork = new UnitOfWork()) { var accessGroups = unitOfWork.AccessGroup.Get(p => p.EntityId != 1).ToList(); return(new ServiceResult <object>(Copier.GetDto(accessGroups), accessGroups.Count)); } } 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 context = new ParsiContext()) { var data = context.Organization.Where(p => p.EntityId == entityId) .Include(p => p.CurrentLogo) .Include(p => p.CurrentOrganizationGrade) .Include(p => p.CurrentOrganizationOwnershipType) .Include(p => p.CurrentOrganizationRoadType) .Include(p => p.CurrentOrganizationStatus) .Include(p => p.CurrentOrganizationType) .Include(p => p.CurrentProvince) .Include(p => p.CurrentCity) .Include(p => p.CurrentOrganization) .Include(p => p.CreateUserEntity) .Include(p => p.UpdateUserEntity) .IgnoreQueryFilters() .ToList(); return(data.Count == 0 ? new ServiceResult <object>(Enumerator.ErrorCode.NotFound, "رکورد یافت نشد") : new ServiceResult <object>(Copier.GetDto(data[0]), 1)); } } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
public string GetOrgAccess(long orgId) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { using (var unitOfWork = new UnitOfWork()) { return(unitOfWork.Organization.Get(p => p.EntityId == orgId).Select(p => p.AccessKey) .FirstOrDefault()); } } catch (Exception ex) { ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, null); return(""); } }
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> GetAllList(BusinessParam bp) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { List <DataLayer.Model.Core.Action.Action> myAction; using (var unitOfWork = new UnitOfWork()) { myAction = unitOfWork.Action.Get().ToList(); } return(new ServiceResult <object>(Copier.GetDto(myAction), myAction.Count)); } catch (Exception ex) { return(ExceptionUtil.ExceptionHandler(ex, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
public ServiceResult <object> SaveList(BusinessParam bp, List <UseCaseActionAccessGroupDto> lstDto) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { foreach (var dto in lstDto) { DataLayer.Model.Core.UseCaseActionAccessGroup.UseCaseActionAccessGroup caseActionAccessGroup; if (dto.EntityId == 0) { using (var unitOfWork = new UnitOfWork()) { caseActionAccessGroup = Copier.GetEntity(dto, bp, true); if (caseActionAccessGroup.UseCaseAction != -1) { unitOfWork.UseCaseActionAccessGroup.Insert(caseActionAccessGroup); unitOfWork.UseCaseActionAccessGroup.Save(); } } } else { using (var unitOfWork = new UnitOfWork()) { caseActionAccessGroup = Copier.GetEntity(dto, bp, false); unitOfWork.UseCaseActionAccessGroup.Update(caseActionAccessGroup); unitOfWork.UseCaseActionAccessGroup.Save(); } } Elastic <UseCaseActionAccessGroupDto, DataLayer.Model.Core.UseCaseActionAccessGroup.UseCaseActionAccessGroup> .SaveToElastic(caseActionAccessGroup, "UseCaseActionAccessGroup", bp); } return(new ServiceResult <object>(true, 1)); } catch (Exception e) { return(ExceptionUtil.ExceptionHandler(e, ClassDetails[0].Facade + methodName, bp.UserInfo)); } }
public ServiceResult <object> GetAllExtension(BusinessParam bp) { var methodName = $".{new StackTrace().GetFrame(1).GetMethod().Name}"; try { using (var unitOfWork = new UnitOfWork()) { var extensionList = unitOfWork.File.Get().Select(p => p.Extension).Distinct().ToList(); return(extensionList.Count <= 0 ? new ServiceResult <object>(0, 1) : new ServiceResult <object>(extensionList, extensionList.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.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)); } }