public async Task <ReturnedSaveFuncInfo> SaveAsync(SanadDetailBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_SanadDetail_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@moeinGuid", item.MoeinGuid); cmd.Parameters.AddWithValue("@desc", item.Description ?? ""); cmd.Parameters.AddWithValue("@tafsilGuid", item.TafsilGuid); cmd.Parameters.AddWithValue("@debit", item.Debit); cmd.Parameters.AddWithValue("@credit", item.Credit); cmd.Parameters.AddWithValue("@masterGuid", item.MasterGuid); 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 async Task <SanadDetailBussines> GetAsync(string _connectionString, Guid guid) { var list = new SanadDetailBussines(); try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_SanadDetail_Get", cn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", guid); await cn.OpenAsync(); var dr = await cmd.ExecuteReaderAsync(); if (dr.Read()) { list = LoadData(dr); } cn.Close(); } } catch (Exception exception) { WebErrorLog.ErrorInstence.StartErrorLog(exception); } return(list); }
private SanadBussines LoadData(SqlDataReader dr) { var item = new SanadBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.DateM = (DateTime)dr["DateM"]; item.Description = dr["Description"].ToString(); item.Number = (long)dr["Number"]; item.SanadStatus = (EnSanadStatus)dr["SanadStatus"]; item.UserGuid = (Guid)dr["UserGuid"]; item.SanadType = (EnSanadType)dr["SanadType"]; item.UserName = dr["UserName"].ToString(); item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; item.Details = AsyncContext.Run(() => SanadDetailBussines.GetAllAsync(item.Guid)); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
private SanadDetailBussines LoadData(SqlDataReader dr) { var item = new SanadDetailBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.MoeinGuid = (Guid)dr["MoeinGuid"]; item.MoeinCode = dr["MoeinCode"].ToString(); item.MoeinName = dr["MoeinName"].ToString(); item.TafsilGuid = (Guid)dr["TafsilGuid"]; item.TafsilCode = dr["TafsilCode"].ToString(); item.TafsilName = dr["TafsilName"].ToString(); item.Description = dr["Description"].ToString(); item.MasterGuid = (Guid)dr["MasterGuid"]; item.Debit = (decimal)dr["Debit"]; item.Credit = (decimal)dr["Credit"]; item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
private SanadDetailBussines GenerateDet() { try { var tafsil = TafsilBussines.Get(_tafsilGuid); var moein = MoeinBussines.Get(_moeinGuid); var res = new SanadDetailBussines { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = txtRowDesc.Text, Debit = txtDebit.TextDecimal, Credit = txtCredit.TextDecimal, TafsilGuid = (tafsil?.Guid ?? Guid.Empty), MoeinGuid = (moein?.Guid ?? Guid.Empty), MoeinCode = moein?.Code, MoeinName = moein?.Name, TafsilCode = tafsil?.Code, TafsilName = tafsil?.Name }; return(res); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); return(null); } }
public static async Task <ReturnedSaveFuncInfo> SaveAsync(SanadDetailBussines cls) { var res = new ReturnedSaveFuncInfo(); try { var obj = new WebSanadDetail() { Guid = cls.Guid, Modified = cls.Modified, HardSerial = cls.HardSerial, ServerStatus = cls.ServerStatus, ServerDeliveryDate = cls.ServerDeliveryDate, Description = cls.Description, Debit = cls.Debit, Credit = cls.Credit, TafsilGuid = cls.TafsilGuid, MoeinGuid = cls.MoeinGuid, MasterGuid = cls.MasterGuid }; await obj.SaveAsync(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
private async Task LoadDataAsync() { try { _token?.Cancel(); _token = new CancellationTokenSource(); _list = await SanadDetailBussines.GetAllTarazAzmayeshiAsync(_token.Token); Invoke(new MethodInvoker(() => TarazBindingSource.DataSource = _list.ToSortableBindingList())); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private async Task LoadDataAsync(string search = "") { try { while (!IsHandleCreated) { if (_token.IsCancellationRequested || IsDisposed) { return; } await Task.Delay(100); } _token?.Cancel(); _token = new CancellationTokenSource(); _list = await SanadDetailBussines.GetAllTarazHesabAsync(_token.Token, _date1, _date2, _code1, _code2); Search(_token.Token, search); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
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); } }