public BusinessResult <TEntity> MarkDeleted(TEntity entity) { BusinessResult <TEntity> result = null; try { var prop = typeof(TEntity).GetProperty("IsDeleted"); if (prop != null) { prop.SetValue(entity, true); DbEntityEntry <TEntity> updated = Context.Entry <TEntity>(entity); updated.State = EntityState.Modified; if (Context.SaveChanges() > 0) { result = new BusinessResult <TEntity>(entity); } else { result = new BusinessResult <TEntity>(null, "Bilinmeyen bir hata", BusinessResultType.Warning); } } else { result = new BusinessResult <TEntity>(null, "Yanlış tipte entity gönderdin, Property Yok: IsDeleted.", BusinessResultType.Warning); } } catch (Exception ex) { result = new BusinessResult <TEntity>(entity, "Hata oluştu:" + ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public BusinessResult <List <TEntity> > FindList(Expression <Func <TEntity, bool> > filter, params string[] includetables) { BusinessResult <List <TEntity> > result = null; try { IQueryable <TEntity> query = Context.Set <TEntity>().Where(filter); includetables.ToList().ForEach(tableName => { query = query.Include(tableName); }); var entities = query.ToList(); if (entities.Count == 0) { result = new BusinessResult <List <TEntity> >(null, "Listede hiç bir kayıt yoktu.", BusinessResultType.Success); } else { result = new BusinessResult <List <TEntity> >(entities, "", BusinessResultType.Success); } } catch (Exception ex) { result = new BusinessResult <List <TEntity> >(null, "Hata oluştu:" + ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public async Task <IBusinessResult <GetByIdCustomerResponse> > GetById(int id) { #region [ Config Cache ] string keyCache = string.Format(keyGetByIdCache, id); TimeSpan expirationCache = TimeSpan.FromMinutes(20); #endregion if (!_cache.TryGetValue(keyCache, out IBusinessResult <GetByIdCustomerResponse> result)) { result = await GetByIdCache(id); if (!result.HasErrors) { var cacheEntryOptions = new MemoryCacheEntryOptions() .SetSlidingExpiration(expirationCache); // Save data in cache. _cache.Set(keyCache, result, cacheEntryOptions); } } if (!result.Data.AnyOrNotNull()) { return(BusinessResult <GetByIdCustomerResponse> .Create( "Customer not found.".ToMessageResult("GetById", MessageType.Warning) )); } return(result); }
public BusinessResult <int> UpdateList(List <TEntity> entities) { BusinessResult <int> result = null; try { entities.ForEach(e => { DbEntityEntry <TEntity> updated = Context.Entry <TEntity>(e); updated.State = EntityState.Modified; }); int contextResult = Context.SaveChanges(); if (contextResult > 0) { result = new BusinessResult <int>(contextResult); } else { result = new BusinessResult <int>(0, "Bilinmeyen bir hata", BusinessResultType.Warning); } } catch (Exception ex) { result = new BusinessResult <int>(0, "Hata oluştu:" + ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public BusinessResult <TEntity> Update(TEntity entity) { BusinessResult <TEntity> result = null; try { //Context.Set<TEntity>().Add(entity); DbEntityEntry <TEntity> updated = Context.Entry <TEntity>(entity); updated.State = EntityState.Modified; if (Context.SaveChanges() > 0) { result = new BusinessResult <TEntity>(entity); } else { result = new BusinessResult <TEntity>(null, "Bilinmeyen bir hata", BusinessResultType.Warning); } } catch (Exception ex) { result = new BusinessResult <TEntity>(entity, "Hata oluştu:" + ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public async Task <IBusinessResult> ToggleActivationAsync(int memberId) { var result = new BusinessResult(); try { var entity = await unitOfWork.MemberDataService.GetByIdAsync(memberId); if (entity != null) { entity.IsActive = !entity.IsActive; await unitOfWork.CommitAsync(); result.ReturnMessage.Add(MESSAGE_MODIFY_ENTITY); } else { result.ReturnStatus = false; result.ReturnMessage.Add("اطلاعاتی یافت نشد"); } } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public new BusinessResult <ShareYourNoteUser> Insert(ShareYourNoteUser model) { //Method gizledik. ShareYourNoteUser user = Find(x => x.Username == model.Username || x.Email == model.Email); BusinessResult <ShareYourNoteUser> result = new BusinessResult <ShareYourNoteUser>(); result.Result = model; if (user != null) { if (user.Username == model.Username) { result.AddError(ErrorMessages.UsernameAlreadyExist, "Kullanıcı adı kayıtlı."); } if (user.Email == model.Email) { result.AddError(ErrorMessages.EmailAlreadyExist, "E-Posta Kullanımda."); } } else { result.Result.ProfilePhotoName = "defaultImage.png"; result.Result.ActivateGuid = Guid.NewGuid(); if (base.Insert(result.Result) == 0) { result.AddError(ErrorMessages.ProfileCouldNotUpdate, "Kullanıcı kayıt edilemedi"); } } return(result); }
public BusinessResult <List <Category> > GetTopProductCategories(int categorycount) { BusinessResult <List <Category> > result = null; try { var query = string.Format("select * from {0} where Id in (select top @count CategoryId from {1} group by CategoryId order by count(*) desc)", DbConstants.Categories.SchemaWithName, DbConstants.Products.SchemaWithName); var queryResult = Context.Categories.SqlQuery(query, new SqlParameter("@count", categorycount)).ToList(); if (queryResult.Any()) { foreach (var category in queryResult) { category.Group = Context.CategoryGroups.SingleOrDefault(cg => cg.Id == category.GroupId); } result = new BusinessResult <List <Category> >(queryResult); } else { result = new BusinessResult <List <Category> >(null, "There is not any categories", BusinessResultType.Info); } } catch (Exception ex) { result = new BusinessResult <List <Category> >(null, ex.GetOriginalException().Message, BusinessResultType.Warning); } return(result); }
public virtual async Task <IBusinessResult> UpdateAsync(TEntity entity) { var result = new BusinessResult(); try { if (validator != null) { ValidationResult results = await validator.ValidateAsync(entity); bool validationSucceeded = results.IsValid; IList <ValidationFailure> failures = results.Errors; if (validationSucceeded == false) { result.PopulateValidationErrors(failures); return(result); } } dataRepository.Update(entity); await unitOfWork.CommitAsync(); result.ReturnStatus = true; result.ReturnMessage.Add(".ویرایش اطلاعات با موفقیت انجام شد"); } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public new BusinessResult <users> UpdateProfile(users model) { users user = Find(x => x.id != model.id && (x.username == model.username || x.mailadress == model.mailadress)); BusinessResult <users> result = new BusinessResult <users>(); result.Result = model; if (user != null && user.id != model.id) { if (user.username == model.username) { result.AddError(ErrorMessages.UsernameAlreadyExist, "Kullanıcı Adı Kullanımda"); } if (user.mailadress == model.mailadress) { result.AddError(ErrorMessages.EmailAlreadyExist, "E-Posta Adresi kullanımda"); } return(result); } result.Result = Find(x => x.id == model.id); result.Result.mailadress = model.mailadress; result.Result.password = model.password; result.Result.username = model.username; result.Result.isactive = model.isactive; result.Result.isadmin = model.isadmin; if (base.Update(result.Result) == 0) { result.AddError(ErrorMessages.ProfileCouldNotUpdate, "Profil güncellenemedi"); } return(result); }
public ActionResult UserActivate(Guid id) { BusinessResult <EvernoteUser> activateResult = um.ActivateUser(id); if (activateResult.Errors.Count > 0) { ErrorViewModel errorModel = new ErrorViewModel() { Title = "Geçersiz İşlem", Items = activateResult.Errors }; return(View("Error", errorModel)); } OkViewModel okModel = new OkViewModel() { Header = "Hesap Aktifleştirildi", RedirectUrl = "/Home/Login/" }; okModel.Items.Add("MyEvernote hesabınız aktifleştirildi.Artık not paylaşabilir ve beğeni yapabilirsiniz.."); return(View("Ok", okModel)); }
public ActionResult Register(RegisterViewModel model) { //Username ve Email kontrolü //Kayıt(Insert) işlemi //Aktivasyon epostası gönder if (ModelState.IsValid) { BusinessResult <EvernoteUser> userResult = um.RegisterUser(model); if (userResult.Errors.Count > 0) { userResult.Errors.ForEach(x => ModelState.AddModelError("", x.Message)); return(View(model)); } } OkViewModel okModel = new OkViewModel() { Header = "Kayıt Başarılı", RedirectUrl = "/Home/Login/" }; okModel.Items.Add("E-posta adresinize gelen aktivasyon linkine tıklayarak hesabınızı aktive edebilirsiniz.Hesabınızı aktive etmeden not ekleme ve gönderi beğenme işlemi yapamazsınız."); return(View("Ok", okModel)); }
public ActionResult Login(LoginViewModel model) { //Giriş kontrolü //User aktif mi //Yönlendirme //Session a kullanıcı bilgisini atma if (ModelState.IsValid) { BusinessResult <EvernoteUser> loginResult = um.LoginUser(model); if (loginResult.Errors.Count > 0) { if (loginResult.Errors.Find(x => x.Code == ErrorMessageCode.UserIsnotActive) != null) { ViewBag.SetLink = "http://Home/Activate/1234-2222-12345"; } loginResult.Errors.ForEach(x => ModelState.AddModelError("", x.Message)); return(View(model)); } CurrentSession.Set <EvernoteUser>("login", loginResult.Result); return(RedirectToAction("Index")); } return(View()); }
public BusinessResult <TEntity> Get(Expression <Func <TEntity, bool> > filter, params string[] includetables) { BusinessResult <TEntity> result = null; try { IQueryable <TEntity> query = Context.Set <TEntity>().Where(filter); includetables.ToList().ForEach(tableName => { query = query.Include(tableName); }); var entity = query.SingleOrDefault(filter); if (entity == null) { result = new BusinessResult <TEntity>(null, "Kayıt bulunamadı", BusinessResultType.Warning); } else { result = new BusinessResult <TEntity>(entity, "", BusinessResultType.Success); } } catch (Exception ex) { result = new BusinessResult <TEntity>(null, "Hata oluştu:" + ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public BusinessResult <Load> InsertWithBeam(Load load, string beamname) { BusinessResult <Load> result = null; try { using (IBeamRepository beamRepo = new BeamRepository(new BeamDeflectionDbContext())) { var _beam = beamRepo.Get(x => x.Name == beamname).Result; if (_beam != null) { load.BeamId = _beam.ID; var insert = this.Insert(load); if (insert != null) { result = new BusinessResult <Load>(load, "", BusinessResultType.Success); } else { result = new BusinessResult <Load>(null, "Kayıt başarısız.", BusinessResultType.NotSet); } } else { result = new BusinessResult <Load>(null, "Kayıt başarısız. Kiriş bulunamadı.", BusinessResultType.NotSet); } } } catch (Exception ex) { result = new BusinessResult <Load>(null, "Hata :" + ex.GetBaseException(), BusinessResultType.Error); } return(result); }
public async Task PlaceAutocompleteSearchProcessTest_WithRequiredValues() { var httpClient = new HttpClient(); var restService = new RESTRequest <PlacesResponse, Dictionary <string, string> >(httpClient); BusinessResult <SearchPlacesResponse> result = default; try { var request = new SearchPlacesRequest() { ApiKey = Globals.Credentials.PlacesApiKey, //Address = "1600 Amphitheatre Pkwy, Mountain View, CA 94043", Address = "1600 Amphitheatre", PlaceBaseUrl = _baseUrl, OperationId = $"{Guid.NewGuid()}", CancellationToken = CancellationToken.None, }; var searchProcessor = new PlaceAutocompleteSearchProcessor(restService, _logger); result = await searchProcessor.ExecuteAsync(request); _output.WriteLine(JsonConvert.SerializeObject(result)); Assert.NotNull(result); Assert.NotNull(result.Result); Assert.IsType <SearchPlacesResponse>(result.Result); Assert.Empty(result.Error); } catch (Exception ex) { result.Error.Add(new BusinessError(LogLevel.Critical, "test exception", ex, result?.Result?.OperationId)); _output.WriteLine($"{result.Error}"); Assert.True(false); } }
public async Task <IBusinessResult> BatchDeleteAsync(BranchGoalDTO batchData) { var result = new BusinessResult(); try { var branchBenefitIds = batchData.Items .Where(x => x.BranchGoalId != null) .Select(x => x.BranchGoalId.Value) .ToList(); var branchBenefits = await unitOfWork.BranchGoalDataService.GetAsync(where : x => branchBenefitIds.Contains(x.Id)); branchBenefits.ForEach(x => { x.Deleted = true; }); await unitOfWork.CommitAsync(); result.ReturnStatus = true; result.ReturnMessage.Add(" اطلاعات با موفقیت حذف شد"); } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public BusinessResult <List <Role> > GetUserRoles(int userid) { BusinessResult <List <Role> > result = null; try { string command = string.Format("Select * from {0} where IsActive=1 and Id IN(Select RoleId from {1} where UserId=@userid)", DbConstants.Roles.SchemaWithName, DbConstants.UserRoles.SchemaWithName); var roles = Context.Roles.SqlQuery(command, new SqlParameter("@userid", userid)).ToList(); if (roles.Any()) { foreach (var role in roles) { string modulecommand = string.Format("Select * from {0} where IsActive=1 and Id In(Select ModuleId from {1} where RoleId=@roleid)", DbConstants.Modules.SchemaWithName, DbConstants.RoleModules.SchemaWithName); role.Modules = Context.Modules.SqlQuery(modulecommand, new SqlParameter("@roleid", role.Id)).ToList(); } result = new BusinessResult <List <Role> >(roles); } else { result = new BusinessResult <List <Role> >(null, "No Records", BusinessResultType.Warning); } } catch (Exception ex) { result = new BusinessResult <List <Role> >(null, ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public BusinessResult GetUserById(int id) { BusinessResult result = new BusinessResult(); using (var conexion = Util.GetConnection()) { conexion.Open(); using (var objPE = new UserPE()) { try { BOUser objUser = objPE.GetUserById(conexion, id); if (objUser == null) { result.ErrorsList.Add("Record not found."); } else { result.Success = true; result.Other = objUser; } } catch (Exception error) { throw new Exception(error.Message); } } } return(result); }
public BusinessResult <Customers> GetCustomer(int customerId) { BusinessResult <Customers> result = new BusinessResult <Customers>(); try { var queryResult = customerRepository.GetCustomer(customerId); if (queryResult != null) { result.Data = queryResult; result.Status = Common.Enums.ReturnStatus.OK; } else { result.Status = Common.Enums.ReturnStatus.DataNotFound; result.Message = "No requested customer found."; } } catch (Exception ex) { result.Status = Common.Enums.ReturnStatus.Error; result.Message = ex.Message; } return(result); }
public async Task <BusinessResult <int> > CreateCustomer(Customers customerRec) { BusinessResult <int> result = new BusinessResult <int>(); try { if (customerRec != null) { var rst = await customerRepository.CreateCustomer(customerRec); result.Status = Common.Enums.ReturnStatus.OK; result.Message = "Customer addedd successfully"; result.Data = rst; } else { result.Status = Common.Enums.ReturnStatus.BadRequest; result.Message = "Requested Data should not be null"; } } catch (Exception ex) { result.Status = Common.Enums.ReturnStatus.Error; result.Message = ex.Message; } return(result); }
/// <summary> /// 获取业务数据 /// </summary> /// <param name="messgae"></param> /// <returns></returns> public BusinessResult ExecuteBusiness(string cmdkey, string args = "", BusinessType type = BusinessType.Get) { try { if (_BusinessServer == null) { return(null); } BusinessMessage msg = new BusinessMessage(); msg.BusinessCommand = cmdkey; msg.BusiType = type; msg.BusiPriority = BusinessPriority.Highest; msg.BusinessParam = args; BusinessResult bs = DeviceCommBusinessServerHelper.Instanse.ExecuteBusiness(msg); if (bs == null || !bs.Result) { return(null); } return(bs); } catch (Exception ex) { ErrorLog.Error(ex.StackTrace.ToString()); } return(null); }
public async Task <IBusinessResult> AddOrModfiyFinalPromotionAsync(List <MemberPromotion> entities) { var result = new BusinessResult(); try { var result_validator = lstValidationRules.Validate(entities); if (!result_validator.IsValid) { result.PopulateValidationErrors(result_validator.Errors); return(result); } entities.ForEach(memshar => { unitOfWork.MemberPromotionDataService.Update(memshar); }); await unitOfWork.CommitAsync(); result.ReturnMessage.Add(MESSAGE_ADD_ENTITY); } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public async Task <IBusinessResult> DeleteAsync(BranchReceiptGoalPercentDTO branchReceiptGoalPercentDTO) { var result = new BusinessResult(); try { var lst_itemDeleted = await unitOfWork.BranchReceiptGoalPercentDataService.GetAsync(x => branchReceiptGoalPercentDTO.Branches.Contains(x.BranchId) && x.GoalId == branchReceiptGoalPercentDTO.GoalId && x.NotReachedPercent == branchReceiptGoalPercentDTO.NotReachedPercent && x.ReachedPercent == branchReceiptGoalPercentDTO.ReachedPercent ); lst_itemDeleted.ForEach(x => { unitOfWork.BranchReceiptGoalPercentDataService.Delete(x); }); await unitOfWork.CommitAsync(); result.ReturnMessage.Add(MESSAGE_DELETE_ENTITY); result.ReturnStatus = true; } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public async Task <IBusinessResult> AddOrUpdateAsync(CostCoefficient entity) { var result = new BusinessResult(); try { ValidationResult validationResult = validator.Validate(entity); if (validationResult.IsValid == false) { result.PopulateValidationErrors(validationResult.Errors); return(result); } entity.Records.ForEach(x => unitOfWork.CostCoefficientDataService.InsertOrUpdate(x)); await unitOfWork.CommitAsync(); result.ReturnStatus = true; result.ReturnMessage.Add("ثبت اطلاعات با موفقیت انجام گردید"); } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public BusinessResult <List <Product> > GetNextActiveProducts(int count, int skip) { BusinessResult <List <Product> > result = null; try { #region SqlQuery //string query = string.Format("Select top @count* {0} where Id>@startid and IsActive=1 and IsDeleted=0",DbConstants.Products.SchemaWithName); //var parameters = new[] //{ // new SqlParameter("@count",count), // new SqlParameter("@startid",startid) //}; #endregion var queryResult = Context.Products.Where(x => x.IsActive && !x.IsDeleted).OrderBy(x => x.CreatedAt).Skip(skip).Take(count).ToList(); if (queryResult.Any()) { result = new BusinessResult <List <Product> >(queryResult); } else { result = new BusinessResult <List <Product> >(null, "No record in the list", BusinessResultType.Info); } } catch (Exception ex) { result = new BusinessResult <List <Product> >(null, ex.GetOriginalException().Message, BusinessResultType.Error); } return(result); }
public async Task <IBusinessResult> DeleteOrgStructureShareDTOAsync(OrgStructureShareDTO personelShareDTO) { var result = new BusinessResult(); try { personelShareDTO.Items .Where(x => x.Id != 0) .ToList() .ForEach(x => { unitOfWork.OrgStructureShareDataService.Delete(x); }); await unitOfWork.CommitAsync(); result.ReturnMessage.Add(" اطلاعات با موفقیت حذف شد"); } catch (DbEntityValidationException ex) { result.PopulateValidationErrors(ex); } catch (Exception ex) { CatchException(ex, result, ""); } return(result); }
public async Task <IBusinessResult> DeleteAsync(int positionTypeId) { var result = new BusinessResult(); try { var lst_ExistsData = await unitOfWork.OrgStructureDataService.GetAsync(x => x.PositionTypeId == (PositionTypeEnum)positionTypeId); // delete new orgsturctures foreach (var item in lst_ExistsData) { unitOfWork.OrgStructureDataService.Delete(item); } await unitOfWork.CommitAsync(); result.ReturnMessage.Add(MESSAGE_DELETE_ENTITY); result.ReturnStatus = true; } catch (Exception ex) { CatchException(ex, result, "", ""); } return(result); }
public new BusinessResult <EvernoteUser> Update(EvernoteUser data) { EvernoteUser db_user = Find(x => x.Id != data.Id && (x.UserName == data.UserName || x.Email == data.Email)); BusinessResult <EvernoteUser> res = new BusinessResult <EvernoteUser>(); res.Result = data; if (db_user != null && db_user.Id != data.Id) { if (db_user.UserName == data.UserName) { res.AddError(ErrorMessageCode.UsernameAlreadyExists, "Kullanıcı Adı Kayıtlı"); } if (db_user.Email == data.Email) { res.AddError(ErrorMessageCode.EmailAlreadyExists, "Email Adresi Kayıtlı"); } return(res); } res.Result = Find(x => x.Id == data.Id); res.Result.Email = data.Email; res.Result.Name = data.Name; res.Result.Surname = data.Surname; res.Result.Password = data.Password; res.Result.UserName = data.UserName; res.Result.IsActive = data.IsActive; res.Result.IsAdmin = data.IsAdmin; if (base.Update(res.Result) == 0) { res.AddError(ErrorMessageCode.UserCouldNotUpdated, "Kullanıcı güncellenemedi"); } return(res); }
public new BusinessResult <EvernoteUser> Insert(EvernoteUser data) { EvernoteUser user = Find(x => x.UserName == data.UserName || x.Email == data.Email); BusinessResult <EvernoteUser> res = new BusinessResult <EvernoteUser>(); res.Result = data; if (user != null) { if (user.UserName == data.UserName) { res.AddError(ErrorMessageCode.UsernameAlreadyExists, "Kullanıcı Adı Kayıtlı"); } if (user.Email == data.Email) { res.AddError(ErrorMessageCode.EmailAlreadyExists, "Email Adres Kayıtlı"); } } else { res.Result.ProfileImageFileName = "user_default.png"; res.Result.ActivateGuid = Guid.NewGuid(); if (base.Insert(res.Result) == 0) { res.AddError(ErrorMessageCode.UserIsNotInserted, "Kullanıcı Eklenemedi"); } } return(res); }
public BusinessResult Save(IDbTransaction trans) { BusinessResult result = new BusinessResult(); DataCriteria criteria = this.CreateSaveCriteria(); return (BusinessResult)DataPortal.ExecuteNonQuery(criteria, trans); }
public BusinessResult Delete() { BusinessResult result = new BusinessResult(); DataCriteria criteria = this.CreateDeleteCriteria(); return (BusinessResult)DataPortal.ExecuteNonQuery(criteria); }