public async Task <ReturnedSaveFuncInfo> SaveAsync(AdvisorBussines item, SqlTransaction tr)
{
var res = new ReturnedSaveFuncInfo();
try
{
var cmd = new SqlCommand("sp_Advisor_Save", tr.Connection, tr)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@guid", item.Guid);
cmd.Parameters.AddWithValue("@st", item.Status);
cmd.Parameters.AddWithValue("@name", item.Name ?? "");
cmd.Parameters.AddWithValue("@address", item.Address ?? "");
cmd.Parameters.AddWithValue("@serverSt", (short)item.ServerStatus);
cmd.Parameters.AddWithValue("@serverDate", item.ServerDeliveryDate);
await cmd.ExecuteNonQueryAsync();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return(res);
}
public static async Task<ReturnedSaveFuncInfo> SaveAsync(AdvisorBussines cls)
{
var res = new ReturnedSaveFuncInfo();
try
{
var obj = new WebAdvisor()
{
Guid = cls.Guid,
Name = cls.Name,
Modified = cls.Modified,
Status = cls.Status,
HardSerial = cls.HardSerial,
ServerStatus = cls.ServerStatus,
ServerDeliveryDate = cls.ServerDeliveryDate,
Address = cls.Address
};
await obj.SaveAsync();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return res;
}
public async Task <AdvisorBussines> GetAsync(string connectionString, Guid guid)
{
AdvisorBussines res = null;
try
{
using (var cn = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("sp_Advisor_Get", cn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@guid", guid);
await cn.OpenAsync();
var dr = await cmd.ExecuteReaderAsync();
if (dr.Read())
{
res = LoadData(dr);
}
dr.Close();
cn.Close();
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
return(res);
}
private AdvisorBussines LoadData(SqlDataReader dr)
{
var item = new AdvisorBussines();
try
{
item.Guid = (Guid)dr["Guid"];
item.Modified = (DateTime)dr["Modified"];
item.Status = (bool)dr["Status"];
item.Name = dr["Name"].ToString();
item.Account = (decimal)dr["Account"];
item.AccountFirst = (decimal)dr["AccountFirst"];
item.Address = dr["Address"].ToString();
item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"];
item.ServerStatus = (ServerStatus)dr["ServerStatus"];
var tellList = PhoneBookBussines.GetAll(item.Guid, true);
if (tellList?.Count == 1)
{
item.Mobile1 = tellList[0]?.Tell;
}
if (tellList?.Count > 1)
{
item.Mobile1 = tellList[0]?.Tell;
item.Mobile2 = tellList[1]?.Tell;
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
return(item);
}
private async Task LoadDataAsync(string search = "")
{
try
{
_token?.Cancel();
_token = new CancellationTokenSource();
var list = await AdvisorBussines.GetAllAsync(search, _token.Token);
Invoke(new MethodInvoker(() => BankBindingSource.DataSource =
list.OrderBy(q => q.Name).Where(q => q.Status == _st).ToSortableBindingList()));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private async Task LoadBazaryabAsync(CancellationToken token)
{
try
{
var list = await AdvisorBussines.GetAllAsync(token);
list.Add(new AdvisorBussines()
{
Guid = Guid.Empty,
Name = "[هیچکدام]",
Status = true
});
bazaryabBindingSource.DataSource = list.Where(q => q.Status).OrderBy(q => q.Name).ToList();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private async void mnuEdit_Click(object sender, EventArgs e)
{
try
{
if (DGrid.RowCount <= 0)
{
return;
}
if (DGrid.CurrentRow == null)
{
return;
}
if (!_st)
{
frmNotification.PublicInfo.ShowMessage(
"شما مجاز به ویرایش داده حذف شده نمی باشید \r\n برای این منظور، ابتدا فیلد موردنظر را از حالت حذف شده به فعال، تغییر وضعیت دهید");
return;
}
var guid = (Guid)DGrid[dgGuid.Index, DGrid.CurrentRow.Index].Value;
var tafsil = await AdvisorBussines.GetAsync(guid);
if (tafsil == null)
{
frmNotification.PublicInfo.ShowMessage("حساب انتخاب شده معتبر نمی باشد");
return;
}
var frm = new frmAdvisorMain(guid, false);
if (frm.ShowDialog(this) == DialogResult.OK)
{
await LoadDataAsync(txtSearch.Text);
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(AdvisorBussines item, bool status, SqlTransaction tr)
{
var res = new ReturnedSaveFuncInfo();
try
{
var cmd = new SqlCommand("sp_Advisor_ChangeStatus", tr.Connection, tr)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@Guid", item.Guid);
cmd.Parameters.AddWithValue("@st", status);
await cmd.ExecuteNonQueryAsync();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return(res);
}
private async void mnuDelete_Click(object sender, EventArgs e)
{
var res = new ReturnedSaveFuncInfo();
try
{
if (DGrid.RowCount <= 0)
{
return;
}
if (DGrid.CurrentRow == null)
{
return;
}
var guid = (Guid)DGrid[dgGuid.Index, DGrid.CurrentRow.Index].Value;
if (_st)
{
var hazine = await AdvisorBussines.GetAsync(guid);
if (hazine == null)
{
return;
}
if (hazine.Account != 0)
{
res.AddError("به دلیل داشتن گردش حساب، شما مجاز به حذف مشاور نمی باشید");
return;
}
if (MessageBox.Show(this,
$@"آیا از حذف {DGrid[dgName.Index, DGrid.CurrentRow.Index].Value} اطمینان دارید؟", "حذف",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
res.AddReturnedValue(await hazine.ChangeStatusAsync(false));
}
else
{
if (MessageBox.Show(this,
$@"آیا از فعال کردن {DGrid[dgName.Index, DGrid.CurrentRow.Index].Value} اطمینان دارید؟",
"حذف",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
var prd = await AdvisorBussines.GetAsync(guid);
res.AddReturnedValue(await prd.ChangeStatusAsync(true));
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
finally
{
if (res.HasError)
{
this.ShowError(res, "خطا در تغییر وضعیت حساب مشاور");
}
else
{
await LoadDataAsync(txtSearch.Text);
}
}
}
private static async Task StartSendToServerAsync()
{
try
{
var list = await TempBussines.GetAllAsync();
while (true)
{
if (list == null || list.Count <= 0)
{
await Task.Delay(2000);
continue;
}
foreach (var item in list)
{
switch (item.Type)
{
case EnTemp.States:
var states = await StatesBussines.GetAsync(item.ObjectGuid);
if (states != null)
{
await WebStates.SaveAsync(states);
}
break;
case EnTemp.Cities:
var city = await CitiesBussines.GetAsync(item.ObjectGuid);
if (city != null)
{
await WebCity.SaveAsync(city);
}
break;
case EnTemp.Region:
var region = await RegionsBussines.GetAsync(item.ObjectGuid);
if (region != null)
{
await WebRegion.SaveAsync(region);
}
break;
case EnTemp.Users:
var user = await UserBussines.GetAsync(item.ObjectGuid);
if (user != null)
{
await WebUser.SaveAsync(user);
}
break;
case EnTemp.PeopleGroups:
var pg = await PeopleGroupBussines.GetAsync(item.ObjectGuid);
if (pg != null)
{
await WebPeopleGroup.SaveAsync(pg);
}
break;
case EnTemp.Peoples:
var p = await PeoplesBussines.GetAsync(item.ObjectGuid);
if (p != null)
{
await WebPeople.SaveAsync(p);
}
break;
case EnTemp.BuildingAccountType:
var acc = await BuildingAccountTypeBussines.GetAsync(item.ObjectGuid);
if (acc != null)
{
await WebBuildingAccountType.SaveAsync(acc);
}
break;
case EnTemp.BuildingCondition:
var co = await BuildingConditionBussines.GetAsync(item.ObjectGuid);
if (co != null)
{
await WebBuildingCondition.SaveAsync(co);
}
break;
case EnTemp.BuildingType:
var type = await BuildingTypeBussines.GetAsync(item.ObjectGuid);
if (type != null)
{
await WebBuildingType.SaveAsync(type);
}
break;
case EnTemp.BuildingView:
var view = await BuildingViewBussines.GetAsync(item.ObjectGuid);
if (view != null)
{
await WebBuildingView.SaveAsync(view);
}
break;
case EnTemp.DocumentType:
var doc = await DocumentTypeBussines.GetAsync(item.ObjectGuid);
if (doc != null)
{
await WebDocumentType.SaveAsync(doc);
}
break;
case EnTemp.FloorCover:
var fc = await FloorCoverBussines.GetAsync(item.ObjectGuid);
if (fc != null)
{
await WebFloorCover.SaveAsync(fc);
}
break;
case EnTemp.KitchenService:
var ks = await KitchenServiceBussines.GetAsync(item.ObjectGuid);
if (ks != null)
{
await WebKitchenService.SaveAsync(ks);
}
break;
case EnTemp.RentalAuthority:
var ra = await RentalAuthorityBussines.GetAsync(item.ObjectGuid);
if (ra != null)
{
await WebRental.SaveAsync(ra);
}
break;
case EnTemp.BuildingOptions:
var o = await BuildingOptionsBussines.GetAsync(item.ObjectGuid);
if (o != null)
{
await WebBuildingOptions.SaveAsync(o);
}
break;
case EnTemp.Building:
var bu = await BuildingBussines.GetAsync(item.ObjectGuid);
if (bu != null)
{
await WebBuilding.SaveAsync(bu, Application.StartupPath);
}
break;
case EnTemp.Contract:
var con = await ContractBussines.GetAsync(item.ObjectGuid);
if (con != null)
{
await WebContract.SaveAsync(con);
}
break;
case EnTemp.Requests:
var req = await BuildingRequestBussines.GetAsync(item.ObjectGuid);
if (req != null)
{
await WebBuildingRequest.SaveAsync(req);
}
break;
case EnTemp.Reception:
var rec = await ReceptionBussines.GetAsync(item.ObjectGuid);
if (rec != null)
{
await WebReception.SaveAsync(rec);
}
break;
case EnTemp.Pardakht:
var pa = await PardakhtBussines.GetAsync(item.ObjectGuid);
if (pa != null)
{
await WebPardakht.SaveAsync(pa);
}
break;
case EnTemp.BuildingRelatedOptions:
var re = await BuildingRelatedOptionsBussines.GetAsync(item.ObjectGuid);
if (re != null)
{
await WebBuildingRelatedOptions.SaveAsync(re);
}
break;
case EnTemp.RequestRegions:
var rr = await BuildingRequestRegionBussines.GetAsync(item.ObjectGuid);
if (rr != null)
{
await WebBuildingRequestRegion.SaveAsync(rr);
}
break;
case EnTemp.PhoneBook:
var ph = await PhoneBookBussines.GetAsync(item.ObjectGuid);
if (ph != null)
{
await WebPhoneBook.SaveAsync(ph);
}
break;
case EnTemp.Advisor:
var ad = await AdvisorBussines.GetAsync(item.ObjectGuid);
if (ad != null)
{
await WebAdvisor.SaveAsync(ad);
}
break;
case EnTemp.Bank:
var ba = await BankBussines.GetAsync(item.ObjectGuid);
if (ba != null)
{
await WebBank.SaveAsync(ba);
}
break;
case EnTemp.Kol:
var kol = await KolBussines.GetAsync(item.ObjectGuid);
if (kol != null)
{
await WebKol.SaveAsync(kol);
}
break;
case EnTemp.Moein:
var moein = await MoeinBussines.GetAsync(item.ObjectGuid);
if (moein != null)
{
await WebMoein.SaveAsync(moein);
}
break;
case EnTemp.Tafsil:
var tafsil = await TafsilBussines.GetAsync(item.ObjectGuid);
if (tafsil != null)
{
await WebTafsil.SaveAsync(tafsil);
}
break;
case EnTemp.Sanad:
var sa = await SanadBussines.GetAsync(item.ObjectGuid);
if (sa != null)
{
await WebSanad.SaveAsync(sa);
}
break;
case EnTemp.SanadDetail:
var saD = await SanadDetailBussines.GetAsync(item.ObjectGuid);
if (saD != null)
{
await WebSanadDetail.SaveAsync(saD);
}
break;
}
await item.RemoveAsync();
}
await Task.Delay(2000);
list = await TempBussines.GetAllAsync();
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private async Task ResendDataToHost()
{
try
{
if (chbState.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebStates.SaveAsync(await StatesBussines.GetAllAsync(_token.Token));
}
if (chbCity.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebCity.SaveAsync(await CitiesBussines.GetAllAsync(_token.Token));
}
if (chbRegion.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebRegion.SaveAsync(await RegionsBussines.GetAllAsync(_token.Token));
}
if (chbUsers.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebUser.SaveAsync(await UserBussines.GetAllAsync(_token.Token));
}
if (chbPeopleGroup.Checked)
{
await WebPeopleGroup.SaveAsync(await PeopleGroupBussines.GetAllAsync());
}
if (chbPeople.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebPeople.SaveAsync(await PeoplesBussines.GetAllAsync(_token.Token));
}
if (chbAccountType.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingAccountType.SaveAsync(await BuildingAccountTypeBussines.GetAllAsync(_token.Token));
}
if (chbCondition.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingCondition.SaveAsync(await BuildingConditionBussines.GetAllAsync(_token.Token));
}
if (chbType.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingType.SaveAsync(await BuildingTypeBussines.GetAllAsync(_token.Token));
}
if (chbView.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingView.SaveAsync(await BuildingViewBussines.GetAllAsync(_token.Token));
}
if (chbDocType.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebDocumentType.SaveAsync(await DocumentTypeBussines.GetAllAsync(_token.Token));
}
if (chbFloor.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebFloorCover.SaveAsync(await FloorCoverBussines.GetAllAsync(_token.Token));
}
if (chbKitchen.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebKitchenService.SaveAsync(await KitchenServiceBussines.GetAllAsync(_token.Token));
}
if (chbRental.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebRental.SaveAsync(await RentalAuthorityBussines.GetAllAsync(_token.Token));
}
if (chbOptions.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingOptions.SaveAsync(await BuildingOptionsBussines.GetAllAsync(_token.Token));
}
if (chbBuilding.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuilding.SaveAsync(await BuildingBussines.GetAllAsync(_token.Token), Application.StartupPath);
}
if (chbRequest.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBuildingRequest.SaveAsync(await BuildingRequestBussines.GetAllAsync(_token.Token));
}
if (chbContract.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebContract.SaveAsync(await ContractBussines.GetAllAsync(_token.Token));
}
if (chbReception.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebReception.SaveAsync(await ReceptionBussines.GetAllAsync(_token.Token));
}
if (chbPardakht.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebPardakht.SaveAsync(await PardakhtBussines.GetAllAsync(_token.Token));
}
if (chbAdvisor.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebAdvisor.SaveAsync(await AdvisorBussines.GetAllAsync(_token.Token));
}
if (chbBank.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebBank.SaveAsync(await BankBussines.GetAllAsync(_token.Token));
}
if (chbKol.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebKol.SaveAsync(await KolBussines.GetAllAsync(_token.Token));
}
if (chbMoein.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebMoein.SaveAsync(await MoeinBussines.GetAllAsync(_token.Token));
}
if (chbTafsil.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebTafsil.SaveAsync(await TafsilBussines.GetAllAsync(_token.Token));
}
if (chbSanad.Checked)
{
_token?.Cancel();
_token = new CancellationTokenSource();
await WebSanad.SaveAsync(await SanadBussines.GetAllAsync(_token.Token));
}
Invoke(new MethodInvoker(() => MessageBox.Show("انتقال داده ها به سرور با موفقیت انجام شد")));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
finally
{
Invoke(new MethodInvoker(() =>
{
btnSend.Enabled = true;
Cursor = Cursors.Default;
}));
}
}
