public static async Task <ReturnedSaveFuncInfo> SaveRangeAsync(List <PardakhtHavaleBussines> list, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.PardakhtHavale.SaveRangeAsync(list, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(bool status, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var tafsil = await TafsilBussines.GetAsync(Guid);
if (tafsil == null)
{
res.AddError("حساب انتخاب شده معتبر نمی باشد");
return(res);
}
res.AddReturnedValue(await tafsil.ChangeStatusAsync(status, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await PhoneBookBussines.ChangeStatusAsync(Guid, status, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.Advisor.ChangeStatusAsync(this, status, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebAdvisor.SaveAsync(this));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <ReturnedSaveFuncInfo> SaveFromServerAsync()
{
var res = new ReturnedSaveFuncInfo();
SqlConnection cn = null;
SqlTransaction tr = null;
try
{
cn = new SqlConnection(Cache.ConnectionString);
var list = await WebCalendar.GetAllAsync();
res.AddReturnedValue(list);
if (res.HasError)
{
return(res);
}
if (list.value == null || list.value.Count <= 0)
{
return(res);
}
await cn.OpenAsync();
tr = cn.BeginTransaction();
var listBus = new List <CalendarBussines>();
foreach (var item in list.value)
{
listBus.Add(new CalendarBussines()
{
Guid = Guid.NewGuid(),
Modified = DateTime.Now,
Description = item.Description,
DateM = item.DateM,
Monasebat = item.Monasebat,
isTatil = item.STRasmi
});
}
res.AddReturnedValue(await RemoveAllAsync(tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await SaveRangeAsync(listBus, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> UpdateAccountAsync(decimal price, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.Tafsil.UpdateAccountAsync(Guid, price, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(bool status, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.SmsPanels.ChangeStatusAsync(this, status, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <ReturnedSaveFuncInfo> RemoveRangeAsync(Guid masterGuid, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.BuildingGallery.RemoveRangeAsync(masterGuid, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(CheckValidation());
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await SaveTafsilAsync(tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await SaveMobileAsync(tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.Advisor.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebAdvisor.SaveAsync(this));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> RemoveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.Contract.RemoveAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
var sanad = await SanadBussines.GetAsync(SanadNumber);
if (sanad != null)
{
res.AddReturnedValue(await sanad.RemoveAsync(tr));
if (res.HasError)
{
return(res);
}
}
res.AddReturnedValue(await UserLogBussines.SaveAsync(EnLogAction.Delete, EnLogPart.Contracts, tr));
if (res.HasError)
{
return(res);
}
//if (Cache.IsSendToServer)
// _ = Task.Run(() => WebContract.SaveAsync(this));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await CheckValidationAsync());
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.BuildingOption.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
var action = IsModified ? EnLogAction.Update : EnLogAction.Insert;
res.AddReturnedValue(await UserLogBussines.SaveAsync(action, EnLogPart.BuildingOptions, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebBuildingOptions.SaveAsync(this));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(bool status, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var list = await PeoplesBussines.GetAllAsync(Guid, false, new CancellationToken());
foreach (var item in list)
{
item.GroupGuid = Guid.Empty;
res.AddReturnedValue(await UnitOfWork.Peoples.SaveAsync(item, tr));
if (res.HasError)
{
return(res);
}
}
res.AddReturnedValue(await UnitOfWork.PeopleGroup.ChangeStatusAsync(this, status, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebPeopleGroup.SaveAsync(this));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> RemoveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UpdateAccountsAsync(this, true, tr));
if (res.HasError)
{
return(res);
}
var check = await CheckPageBussines.GetAsync(CheckPageGuid);
check.CheckStatus = EnCheckSh.Mojoud;
check.DatePardakht = null;
check.DateSarresid = null;
check.Description = "";
check.Modified = DateTime.Now;
check.Price = 0;
check.ReceptorGuid = null;
res.AddReturnedValue(await check.SaveAsync());
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.PardakhtCheckAvalDore.RemoveAsync(Guid, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <ReturnedSaveFuncInfo> SaveAsync(string key, string value, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var sett = await GetAsync(key);
if (sett != null)
{
res.AddReturnedValue(await RemoveAsync(sett.Guid, tr));
if (res.HasError)
{
return(res);
}
}
var set = new SerializedDataBussines()
{
Guid = Guid.NewGuid(),
Name = key,
Data = value,
};
res.AddReturnedValue(await UnitOfWork.SerializedData.SaveAsync(set, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(bool status, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.Building.ChangeStatusAsync(this, status, tr));
if (res.HasError)
{
return(res);
}
var action = status ? EnLogAction.Enable : EnLogAction.Delete;
res.AddReturnedValue(await UserLogBussines.SaveAsync(action, EnLogPart.Building, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebBuilding.SaveAsync(this, Cache.Path));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> RemoveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UpdateAccounts(Details, true, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await SanadDetailBussines.RemoveRangeAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.Sanad.RemoveAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
//if (Cache.IsSendToServer)
// _ = Task.Run(() => WebRental.SaveAsync(list));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(CheckValidation());
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await CheckPageBussines.RemoveAllAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UnitOfWork.DasteCheck.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await CheckPageBussines.SaveRangeAsync(CheckPages, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <string> SetNaqzAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
NaqzBussines one = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var all = await GetAllAsync();
all = all.OrderBy(q => q.UseCount).ToList();
one = all.First();
if (one.UseCount >= 32000)
{
one.UseCount = 1;
}
else
{
one.UseCount += 1;
}
res.AddReturnedValue(await UnitOfWork.Naqz.SaveAsync(one, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res.HasError ? "" : one?.Message);
}
public static async Task <ReturnedSaveFuncInfo> SaveRangeAsync(List <BuildingRequestRegionBussines> list, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await UnitOfWork.BuildingRequestRegion.SaveRangeAsync(list, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebBuildingRequestRegion.SaveAsync(list));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <ReturnedSaveFuncInfo> SaveAsync(EnLogAction action, EnLogPart part, SqlTransaction tr)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var log = new UserLogBussines
{
Guid = Guid.NewGuid(),
UserGuid = UserBussines.CurrentUser.Guid,
Description =
$"انجام عملیات {action.GetDisplay()} در بخش {part.GetDisplay()} در تاریخ {Calendar.MiladiToShamsi(DateTime.Now)} در ساعت {DateTime.Now.ToShortTimeString()}",
Action = action,
Part = part
};
res.AddReturnedValue(await UnitOfWork.UserLog.SaveAsync(log, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task <ReturnedSaveFuncInfo> SaveRangeAsync(List <AdvertiseRelatedRegionBussines> list, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
var _list = await GetAllAsync(list.FirstOrDefault()?.OnlineRegionName);
if (_list != null && _list.Count > 0)
{
await RemoveRangeAsync(_list, tr);
}
res.AddReturnedValue(await UnitOfWork.AdvertiseRelatedRegion.SaveRangeAsync(list, tr));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await CheckValidationAsync());
if (res.HasError)
{
return(res);
}
if (OptionList.Count > 0)
{
res.AddReturnedValue(await BuildingRelatedOptionsBussines.RemoveRangeAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
foreach (var item in OptionList)
{
item.BuildinGuid = Guid;
}
res.AddReturnedValue(await BuildingRelatedOptionsBussines.SaveRangeAsync(OptionList, tr));
if (res.HasError)
{
return(res);
}
}
if (GalleryList.Count > 0)
{
res.AddReturnedValue(await BuildingGalleryBussines.RemoveRangeAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
foreach (var item in GalleryList)
{
item.BuildingGuid = Guid;
}
res.AddReturnedValue(await BuildingGalleryBussines.SaveRangeAsync(GalleryList, tr));
if (res.HasError)
{
return(res);
}
}
res.AddReturnedValue(await UnitOfWork.Building.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
var action = IsModified ? EnLogAction.Update : EnLogAction.Insert;
res.AddReturnedValue(await UserLogBussines.SaveAsync(action, EnLogPart.Building, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebBuilding.SaveAsync(this, Cache.Path));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(await CheckvalidationAsync());
if (res.HasError)
{
return(res);
}
var oldSanad = await GetAsync(Guid);
if (oldSanad != null)
{
res.AddReturnedValue(await UpdateAccounts(oldSanad.Details, true, tr));
if (res.HasError)
{
return(res);
}
}
res.AddReturnedValue(await UnitOfWork.Sanad.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
foreach (var item in Details)
{
item.MasterGuid = Guid;
}
res.AddReturnedValue(await SanadDetailBussines.RemoveRangeAsync(Guid, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await SanadDetailBussines.SaveRangeAsync(Details, tr));
if (res.HasError)
{
return(res);
}
res.AddReturnedValue(await UpdateAccounts(Details, false, tr));
if (res.HasError)
{
return(res);
}
if (Cache.IsSendToServer)
{
_ = Task.Run(() => WebSanad.SaveAsync(this));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
public static async Task InsertDefaultDataAsync()
{
var res = new ReturnedSaveFuncInfo();
SqlTransaction tr = null;
SqlConnection cn = null;
try
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
#region Kol
var allKol = await KolBussines.GetAllAsync(new CancellationToken());
if (allKol == null || allKol.Count <= 0)
{
var kol = DefaultKol.SetDef();
res.AddReturnedValue(await KolBussines.SaveRangeAsync(kol, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Moein
var allMoein = await MoeinBussines.GetAllAsync(new CancellationToken());
if (allMoein == null || allMoein.Count <= 0)
{
var moein = DefaultMoein.SetDef();
res.AddReturnedValue(await MoeinBussines.SaveRangeAsync(moein, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Tafsil
var allTafsil = await TafsilBussines.GetAllAsync(new CancellationToken());
if (allTafsil == null || allTafsil.Count <= 0)
{
var tafsil = DefaultTafsil.SetDef();
res.AddReturnedValue(await TafsilBussines.SaveRangeAsync(tafsil, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Bank
var allBank = await BankBussines.GetAllAsync(new CancellationToken());
if (allBank == null || allBank.Count <= 0)
{
var user = new BankBussines()
{
Guid = ParentDefaults.TafsilCoding.CLSTafsil1010101,
Name = "حساب بانکی مرکزی",
Code = "1010101",
};
res.AddReturnedValue(await user.SaveAsync(tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Bank Segest
var allbs = await BankSegestBussines.GetAllAsync();
if (allbs == null || allbs.Count <= 0)
{
var bs = DefaultBankSegest.SetDef();
res.AddReturnedValue(await BankSegestBussines.SaveRangeAsync(bs, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Users
var allusers = await UserBussines.GetAllAsync(new CancellationToken());
var access = new AccessLevel();
if (allusers == null || allusers.Count <= 0)
{
var user = new UserBussines()
{
Guid = ParentDefaults.TafsilCoding.CLSTafsil1030401,
Name = "کاربر پیش فرض",
UserName = "******",
SecurityQuestion = 0,
Access = Json.ToStringJson(access)
};
var ue = new UTF8Encoding();
var bytes = ue.GetBytes("2211");
var md5 = new MD5CryptoServiceProvider();
var hashBytes = md5.ComputeHash(bytes);
user.Password = System.Text.RegularExpressions.Regex.Replace(BitConverter.ToString(hashBytes), "-", "")
.ToLower();
res.AddReturnedValue(await user.SaveAsync(tr));
if (res.HasError)
{
return;
}
}
#endregion
#region States
var allStates = await StatesBussines.GetAllAsync(new CancellationToken());
if (allStates == null || allStates.Count <= 0)
{
var states = DefaultStates.SetDef();
res.AddReturnedValue(await StatesBussines.SaveRangeAsync(states, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Cities
var allCities = await CitiesBussines.GetAllAsync(new CancellationToken());
if (allCities == null || allCities.Count <= 0)
{
var city = DefaultCities.SetDef();
res.AddReturnedValue(await CitiesBussines.SaveRangeAsync(city, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Regions
var allRegions = await RegionsBussines.GetAllAsync(new CancellationToken());
if (allRegions == null || allRegions.Count <= 0)
{
var reg = DefaultRegions.SetDef();
res.AddReturnedValue(await RegionsBussines.SaveRangeAsync(reg, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Naqz
var allNaqz = await NaqzBussines.GetAllAsync();
if (allNaqz == null || allNaqz.Count <= 0)
{
var naqz = DefaultNaqz.SetDef();
res.AddReturnedValue(await NaqzBussines.SaveRangeAsync(naqz, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region BuildingOption
var allbo = await BuildingOptionsBussines.GetAllAsync(new CancellationToken());
if (allbo == null || allbo.Count <= 0)
{
var bo = DefaultBuildingOptions.SetDef();
res.AddReturnedValue(await BuildingOptionsBussines.SaveRangeAsync(bo, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region BuildingAccountType
var allbat = await BuildingAccountTypeBussines.GetAllAsync(new CancellationToken());
if (allbat == null || allbat.Count <= 0)
{
var bat = DefaultBuildingAccountType.SetDef();
res.AddReturnedValue(await BuildingAccountTypeBussines.SaveRangeAsync(bat, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region FloorCover
var allfc = await FloorCoverBussines.GetAllAsync(new CancellationToken());
if (allfc == null || allfc.Count <= 0)
{
var fc = DefaultFloorCover.SetDef();
res.AddReturnedValue(await FloorCoverBussines.SaveRangeAsync(fc, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region KitchenService
var allks = await KitchenServiceBussines.GetAllAsync(new CancellationToken());
if (allks == null || allks.Count <= 0)
{
var ks = DefaultKitchenService.SetDef();
res.AddReturnedValue(await KitchenServiceBussines.SaveRangeAsync(ks, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region DocumentType
var alldt = await DocumentTypeBussines.GetAllAsync(new CancellationToken());
if (alldt == null || alldt.Count <= 0)
{
var dt = DefaultDocumentType.SetDef();
res.AddReturnedValue(await DocumentTypeBussines.SaveRangeAsync(dt, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region RentalAuthority
var allra = await RentalAuthorityBussines.GetAllAsync(new CancellationToken());
if (allra == null || allra.Count <= 0)
{
var ra = DefaultRentalAuthority.SetDef();
res.AddReturnedValue(await RentalAuthorityBussines.SaveRangeAsync(ra, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region BuildingView
var allbv = await BuildingViewBussines.GetAllAsync(new CancellationToken());
if (allbv == null || allbv.Count <= 0)
{
var bv = DefaultBuildingView.SetDef();
res.AddReturnedValue(await BuildingViewBussines.SaveRangeAsync(bv, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region BuildingCondition
var allbc = await BuildingConditionBussines.GetAllAsync(new CancellationToken());
if (allbc == null || allbc.Count <= 0)
{
var bc = DefaultBuildingCondition.SetDef();
res.AddReturnedValue(await BuildingConditionBussines.SaveRangeAsync(bc, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region BuildingType
var allbt = await BuildingTypeBussines.GetAllAsync(new CancellationToken());
if (allbt == null || allbt.Count <= 0)
{
var bo = DefaultBuildingType.SetDef();
res.AddReturnedValue(await BuildingTypeBussines.SaveRangeAsync(bo, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region PeopleGroup
var allpg = await PeopleGroupBussines.GetAllAsync();
if (allpg == null || allpg.Count <= 0)
{
var reg = DefaultPeopleGroup.SetDef();
res.AddReturnedValue(await PeopleGroupBussines.SaveRangeAsync(reg, tr));
if (res.HasError)
{
return;
}
}
#endregion
#region Setting
var allSetting = await SettingsBussines.GetAllAsync();
if (allSetting == null || allSetting.Count <= 0)
{
res.AddReturnedValue(SettingsBussines.Save("ArzeshAfzoude", "9", tr));
res.AddReturnedValue(SettingsBussines.Save("Tabdil", "2", tr));
if (res.HasError)
{
return;
}
}
#endregion
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(bool isUpdateAccount, SqlTransaction tr = null)
{
var res = new ReturnedSaveFuncInfo();
var autoTran = tr == null;
SqlConnection cn = null;
try
{
if (autoTran)
{
cn = new SqlConnection(Cache.ConnectionString);
await cn.OpenAsync();
tr = cn.BeginTransaction();
}
res.AddReturnedValue(CheckValidation());
if (res.HasError)
{
return(res);
}
if (isUpdateAccount)
{
var oldSanad = await GetAsync(Guid);
if (oldSanad != null)
{
res.AddReturnedValue(await UpdateAccountsAsync(oldSanad, true, tr));
if (res.HasError)
{
return(res);
}
}
}
res.AddReturnedValue(await UnitOfWork.ReceptionCheckAvalDore.SaveAsync(this, tr));
if (res.HasError)
{
return(res);
}
if (isUpdateAccount)
{
res.AddReturnedValue(await UpdateAccountsAsync(this, false, tr));
if (res.HasError)
{
return(res);
}
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (autoTran)
{
res.AddReturnedValue(tr.TransactionDestiny(res.HasError));
res.AddReturnedValue(cn.CloseConnection());
}
}
return(res);
}
