public Province Update(Province obj)
{
ProvinceBO provinceBO = new ProvinceBO(obj);
provinceDao.Update(provinceBO);
return(obj);
}
public override bool Delete(params object[] keys)
{
try
{
var provinceBo = new ProvinceBO();
var obj = provinceBo.Get(this.ConnectionHandler, keys);
if (obj == null)
{
return(false);
}
var byFilter = new CityBO().Any(this.ConnectionHandler, x => x.ProvinceId == obj.Id);
if (byFilter)
{
throw new Exception("این کشور دارای استان است آن را نمیتوانید حذف کنید");
}
return(provinceBo.Delete(this.ConnectionHandler, keys));
}
catch (KnownException ex)
{
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
catch (Exception ex)
{
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
}
public override bool Delete(params object[] keys)
{
try
{
this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted);
this.FileManagerConnection.StartTransaction(IsolationLevel.ReadUncommitted);
var countryBo = new CountryBO();
var obj = countryBo.Get(this.ConnectionHandler, keys);
if (obj == null)
{
return(false);
}
var countryIpRangeBo = new CountryIPRangeBO();
var byFilter = new ProvinceBO().Any(this.ConnectionHandler, x => x.CountryId == obj.Id);
if (byFilter)
{
throw new Exception("این کشور دارای استان است آن را نمیتوانید حذف کنید");
}
var countryIpRanges = countryIpRangeBo.Where(this.ConnectionHandler, x => x.CountryId == obj.Id);
foreach (var countryIpRange in countryIpRanges)
{
if (!countryIpRangeBo.Delete(this.ConnectionHandler, countryIpRange.Id))
{
throw new Exception("خطایی در حذف IP کشور وجود دارد");
}
}
if (!countryBo.Delete(this.ConnectionHandler, keys))
{
throw new Exception("خطایی در حذف کشور وجود دارد");
}
if (obj.Image != null)
{
FileManagerComponent.Instance.FileTransactionalFacade(this.FileManagerConnection).Delete(obj.Image);
}
this.ConnectionHandler.CommitTransaction();
this.FileManagerConnection.CommitTransaction();
return(true);
}
catch (KnownException ex)
{
this.ConnectionHandler.RollBack();
this.FileManagerConnection.RollBack();
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
catch (Exception ex)
{
this.ConnectionHandler.RollBack();
this.FileManagerConnection.RollBack();
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
}
public int Insert(Province obj)
{
ProvinceBO provinceBO = new ProvinceBO(obj);
return(provinceDao.Insert(provinceBO));
}
