private PeoplesBussines LoadData(SqlDataReader dr) { var item = new PeoplesBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.Status = (bool)dr["Status"]; item.Name = dr["Name"].ToString(); item.Code = dr["Code"].ToString(); item.Account = (decimal)dr["Account"]; item.AccountFirst = (decimal)dr["AccountFirst"]; item.NationalCode = dr["NationalCode"].ToString(); item.IdCode = dr["IdCode"].ToString(); item.FatherName = dr["FatherName"].ToString(); item.PlaceBirth = dr["PlaceBirth"].ToString(); item.DateBirth = dr["DateBirth"].ToString(); item.Address = dr["Address"].ToString(); item.IssuedFrom = dr["IssuedFrom"].ToString(); item.PostalCode = dr["PostalCode"].ToString(); item.GroupGuid = (Guid)dr["GroupGuid"]; item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; item.IsModified = true; item.BankList = AsyncContext.Run(() => PeoplesBankAccountBussines.GetAllAsync(item.Guid)); item.TellList = PhoneBookBussines.GetAll(item.Guid, true); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public static async Task <ReturnedSaveFuncInfo> SaveAsync(PhoneBookBussines cls) { var res = new ReturnedSaveFuncInfo(); try { var obj = new WebPhoneBook() { Guid = cls.Guid, Name = cls.Name, Modified = cls.Modified, Status = cls.Status, HardSerial = cls.HardSerial, ParentGuid = cls.ParentGuid, Tell = cls.Tell, Group = cls.Group, ServerStatus = cls.ServerStatus, ServerDeliveryDate = cls.ServerDeliveryDate }; await obj.SaveAsync(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
public async Task <PhoneBookBussines> GetAsync(string _connectionString, Guid guid) { PhoneBookBussines res = null; try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_PhoneBook_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); }
public async Task <ReturnedSaveFuncInfo> SaveAsync(PhoneBookBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_PhoneBook_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@st", item.Status); cmd.Parameters.AddWithValue("@name", item.Name); cmd.Parameters.AddWithValue("@tell", item.Tell ?? ""); cmd.Parameters.AddWithValue("@group", (short)item.Group); cmd.Parameters.AddWithValue("@parentGuid", item.ParentGuid); 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); }
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 { Invoke(new MethodInvoker(async() => { var list = await PhoneBookBussines.GetAllAsync(ParentGuid, search, (EnPhoneBookGroup)cmbGroup.SelectedIndex); phoneBookBindingSource.DataSource = list.Where(q => q.Status == _st).OrderBy(q => q.Name).ToSortableBindingList(); })); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private async Task LoadDataAsync(string search = "") { try { if (list.Count <= 0) { list = await PhoneBookBussines.GetAllAsync(parentGuid, search, (EnPhoneBookGroup)cmbGroup.SelectedIndex); } list = list.Where(q => q.Status).ToList(); LoadData_(parentGuid, search, (EnPhoneBookGroup)cmbGroup.SelectedIndex); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
public frmSendSms(List <Guid> lstGuid, string text) { InitializeComponent(); ucHeader.Text = "ارسال پیامک"; txtMessage.Text = text; var lstNumbers = new List <string>(); foreach (var guid in lstGuid) { var numbers = PhoneBookBussines.GetAll(guid, true); if (numbers.Count <= 0) { continue; } lstNumbers = numbers.Where(q => q.Tell.StartsWith("09") && q.Tell.Length > 10).Select(q => q.Tell) .ToList(); } AddItems(lstNumbers); }
private PhoneBookBussines LoadData(SqlDataReader dr) { var res = new PhoneBookBussines(); try { res.Guid = (Guid)dr["Guid"]; res.Modified = (DateTime)dr["Modified"]; res.Status = (bool)dr["Status"]; res.Name = dr["Name"].ToString(); res.Tell = dr["Tell"].ToString(); res.Group = (EnPhoneBookGroup)dr["Group"]; res.ParentGuid = (Guid)dr["ParentGuid"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(res); }
public async Task <ReturnedSaveFuncInfo> ChangeStatusAsync(PhoneBookBussines item, bool status, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_PhoneBook_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) { if (MessageBox.Show(this, $@"آیا از حذف {DGrid[dgName.Index, DGrid.CurrentRow.Index].Value} اطمینان دارید؟", "حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } var prd = await PhoneBookBussines.GetAsync(guid); res.AddReturnedValue(await prd.ChangeStatusAsync(false)); } else { if (MessageBox.Show(this, $@"آیا از فعال کردن {DGrid[dgName.Index, DGrid.CurrentRow.Index].Value} اطمینان دارید؟", "حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } var prd = await PhoneBookBussines.GetAsync(guid); res.AddReturnedValue(await prd.ChangeStatusAsync(true)); } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } finally { if (res.HasError) { var frm = new FrmShowErrorMessage(res, "خطا در تغییر وضعیت مخاطب"); frm.ShowDialog(this); frm.Dispose(); } 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); } }
public static async Task <ReturnedSaveFuncInfo> SendAsync(BuildingRequestBussines bu) { var res = new ReturnedSaveFuncInfo(); try { res.AddReturnedValue(await Utilities.PingHostAsync()); if (res.HasError) { return(res); } var text = Text(bu); if (string.IsNullOrEmpty(text)) { res.AddReturnedValue(ReturnedState.Error, "متن پیش فرض خالی می باشد"); return(res); } if (string.IsNullOrEmpty(Settings.Classes.Payamak.DefaultPanelGuid)) { res.AddReturnedValue(ReturnedState.Error, "پنل پبش فرض تعریف نشده است"); return(res); } var panel = SmsPanelsBussines.Get(Guid.Parse(Settings.Classes.Payamak.DefaultPanelGuid)); if (panel == null) { res.AddReturnedValue(ReturnedState.Error, "پنل پیش فرض معتبر نمی باشد"); return(res); } var sApi = new Sms.Api(panel.API.Trim()); var list = new List <string>(); var pe = await PhoneBookBussines.GetAllAsync(bu.AskerGuid, true); foreach (var item in pe) { list.Add(item.Tell); } var res_ = sApi.Send(panel.Sender, list, text); if (res_.Count <= 0) { res.AddReturnedValue(ReturnedState.Error, "ارتباط با پنل با شکست مواجه شد"); return(res); } foreach (var result in res_) { var smsLog = new SmsLogBussines() { Guid = Guid.NewGuid(), UserGuid = UserBussines.CurrentUser.Guid, Cost = result.Cost, Message = result.Message, MessageId = result.Messageid, Reciver = result.Receptor, Sender = result.Sender, StatusText = result.StatusText }; await smsLog.SaveAsync(); } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }