private DasteCheckBussines LoadData(SqlDataReader dr, CancellationToken token) { var item = new DasteCheckBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.Status = (bool)dr["Status"]; item.SerialNumber = dr["SerialNumber"].ToString(); item.BankGuid = (Guid)dr["BankGuid"]; item.FromNumber = (long)dr["FromNumber"]; item.ToNumber = (long)dr["ToNumber"]; item.Description = dr["Description"].ToString(); item.BankName = dr["BankName"].ToString(); item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; item.CheckPages = AsyncContext.Run(() => CheckPageBussines.GetAllAsync(item.Guid, token)); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public async Task <CheckPageBussines> GetAsync(string _connectionString, Guid guid) { CheckPageBussines res = null; try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_CheckPage_SelectRow", cn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", guid); await cn.OpenAsync(); var dr = await cmd.ExecuteReaderAsync(); if (dr.Read()) { res = LoadData(dr); } cn.Close(); } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(res); }
private CheckPageBussines LoadData(SqlDataReader dr) { var item = new CheckPageBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.CheckGuid = (Guid)dr["CheckGuid"]; if (dr["DatePardakht"] != DBNull.Value) { item.DatePardakht = (DateTime?)dr["DatePardakht"]; } item.Number = (long)dr["Number"]; if (dr["ReceptorGuid"] != DBNull.Value) { item.ReceptorGuid = (Guid?)dr["ReceptorGuid"]; } if (dr["DateSarresid"] != DBNull.Value) { item.DateSarresid = (DateTime?)dr["DateSarresid"]; } item.Description = dr["Description"].ToString(); item.Price = (decimal)dr["Price"]; item.CheckStatus = (EnCheckSh)dr["CheckStatus"]; item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public async Task <ReturnedSaveFuncInfo> SaveAsync(CheckPageBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_CheckPage_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@CheckGuid", item.CheckGuid); cmd.Parameters.AddWithValue("@datePardakht", item.DatePardakht); cmd.Parameters.AddWithValue("@number", item.Number); cmd.Parameters.AddWithValue("@receptorGuid", item.ReceptorGuid); cmd.Parameters.AddWithValue("@sarresid", item.DateSarresid); cmd.Parameters.AddWithValue("@desc", item.Description ?? ""); cmd.Parameters.AddWithValue("@price", item.Price); cmd.Parameters.AddWithValue("@st", (int)item.CheckStatus); 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 static async Task <ReturnedSaveFuncInfo> NaqdBargashtAsync(PardakhtCheckShakhsiBussines cls, SanadBussines sanad) { var res = new ReturnedSaveFuncInfo(); try { var checkPage = await CheckPageBussines.GetAsync(cls.CheckPageGuid); var dasteCheck = await DasteCheckBussines.GetAsync(checkPage.CheckGuid); var bank = await TafsilBussines.GetAsync(dasteCheck.BankGuid); var pardakht = await PardakhtBussines.GetAsync(cls.MasterGuid); var girande = await TafsilBussines.GetAsync(pardakht.TafsilGuid); //بستانکار--اسناد sanad.AddToListSanad(new SanadDetailBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"استرداد چک پرداختنی * شماره: {checkPage.Number} بانک صادرکننده: {bank.Name} * گیرنده: {girande.Name}", Debit = 0, Credit = cls.Price, TafsilGuid = bank.Guid, MasterGuid = sanad.Guid, MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein30101 }); //بدهکار--شخص sanad.AddToListSanad(new SanadDetailBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"استرداد چک پرداختنی * شماره: {checkPage.Number} بانک صادرکننده: {bank.Name} * گیرنده: {girande.Name}", Debit = cls.Price, Credit = 0, TafsilGuid = pardakht.TafsilGuid, MasterGuid = sanad.Guid, MoeinGuid = pardakht.MoeinGuid }); res.AddReturnedValue(await sanad.SaveAsync()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
private async Task SetDataAsync() { try { await FillDasteCheckAsync(); await SetTafilAsync(cls?.TafsilGuid ?? Guid.Empty); txtPrice.TextDecimal = cls?.Price ?? 0; txtDesc.Text = cls?.Description; txtDate.Text = cls?.DateSarresidSh; if (cls.Guid == Guid.Empty && CheckBookBindingSource.Count > 0) { cmbCheckBook.SelectedIndex = 0; cmbCheckBook_SelectedIndexChanged(null, null); } else { var checkPage = await CheckPageBussines.GetAsync(cls.CheckPageGuid); if (checkPage == null) { return; } var check = await DasteCheckBussines.GetAsync(checkPage.CheckGuid); if (check == null) { return; } cmbCheckBook.SelectedValue = check.Guid; cmbCheckBook_SelectedIndexChanged(null, null); } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private async void cmbCheckBook_SelectedIndexChanged(object sender, EventArgs e) { try { if (CheckBookBindingSource.Count <= 0 || cmbCheckBook.SelectedValue == null) { return; } _token?.Cancel(); _token = new CancellationTokenSource(); var list = await CheckPageBussines.GetAllAsync((Guid)cmbCheckBook.SelectedValue, _token.Token); CheckPageBindingSource.DataSource = list?.OrderBy(q => q.Number).ToList(); if (cls.Guid != Guid.Empty) { cmbCheckPage.SelectedValue = cls.CheckPageGuid; } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
public static async Task <ReturnedSaveFuncInfo> NaqdAvalDoreAsync(PardakhtCheckAvalDoreBussines cls) { var res = new ReturnedSaveFuncInfo(); try { var checkPage = await CheckPageBussines.GetAsync(cls.CheckPageGuid); var dasteCheck = await DasteCheckBussines.GetAsync(checkPage.CheckGuid); var bank = await TafsilBussines.GetAsync(dasteCheck.BankGuid); var girande = await TafsilBussines.GetAsync(cls.TafsilGuid); var sanad = new SanadBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"نقد کردن چک پرداختنی * شماره: {checkPage.Number} بانک صادر کننده: {bank.Name} * گیرنده: {girande.Name}", DateM = DateTime.Now, Number = await SanadBussines.NextNumberAsync(), SanadStatus = EnSanadStatus.Temporary, SanadType = EnSanadType.Auto, UserGuid = UserBussines.CurrentUser.Guid }; if (checkPage.CheckStatus == EnCheckSh.Bargashti) { res.AddReturnedValue(await NaqdBargashtAvalDoreAsync(cls, sanad)); if (res.HasError) { return(res); } } //بستانکار--موجودی sanad.AddToListSanad(new SanadDetailBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"نقد کردن چک {checkPage.Number} {bank.Name} * گیرنده: {girande.Name}", Debit = 0, Credit = cls.Price, TafsilGuid = bank.Guid, MasterGuid = sanad.Guid, MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein10101 }); //بدهکار--اسناد sanad.AddToListSanad(new SanadDetailBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"نقد کردن چک {checkPage.Number} {bank.Name} * گیرنده: {girande.Name}", Debit = cls.Price, Credit = 0, TafsilGuid = bank.Guid, MasterGuid = sanad.Guid, MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein30101 }); res.AddReturnedValue(await sanad.SaveAsync()); checkPage.CheckStatus = EnCheckSh.Pass; checkPage.Modified = DateTime.Now; res.AddReturnedValue(await checkPage.SaveAsync()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }