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);
}
