private async void mnuViewSanad_Click(object sender, EventArgs e) { try { if (DGrid.RowCount <= 0 || DGrid.CurrentRow == null) { return; } var guid = (Guid)DGrid[dgGuid.Index, DGrid.CurrentRow.Index].Value; var avalDore = (bool)DGrid[dgAvalDore.Index, DGrid.CurrentRow.Index].Value; if (!avalDore) { var str = await PardakhtCheckShakhsiBussines.GetAsync(guid); var rec = await PardakhtBussines.GetAsync(str.MasterGuid); var sanad = await SanadBussines.GetAsync(rec.SanadNumber); var frm_ = new frmSanadMain(sanad.Guid, true); frm_.ShowDialog(this); return; } var frm = new frmPardakhtCheckAvalDore(guid, true); frm.ShowDialog(this); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private PardakhtBussines LoadData(SqlDataReader dr) { var item = new PardakhtBussines(); 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.TafsilGuid = (Guid)dr["TafsilGuid"]; item.MoeinGuid = (Guid)dr["MoeinGuid"]; item.UserGuid = (Guid)dr["UserGuid"]; item.SanadNumber = (long)dr["SanadNumber"]; item.TafsilName = dr["TafsilName"].ToString(); item.UserName = dr["UserName"].ToString(); item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; item.IsModified = true; item.CheckMoshtariList = AsyncContext.Run(() => PardakhtCheckMoshtariBussines.GetAllAsync(item.Guid)); item.CheckShakhsiList = AsyncContext.Run(() => PardakhtCheckShakhsiBussines.GetAllAsync(item.Guid)); item.HavaleList = AsyncContext.Run(() => PardakhtHavaleBussines.GetAllAsync(item.Guid)); item.NaqdList = AsyncContext.Run(() => PardakhtNaqdBussines.GetAllAsync(item.Guid)); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public async Task <PardakhtCheckShakhsiBussines> GetAsync(string _connectionString, Guid guid) { PardakhtCheckShakhsiBussines item = null; try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_PardakhtCheckShakhsi_Get", cn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Guid", guid); await cn.OpenAsync(); var dr = await cmd.ExecuteReaderAsync(); if (dr.Read()) { item = LoadData(dr); } cn.Close(); } } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public async Task <ReturnedSaveFuncInfo> SaveAsync(PardakhtCheckShakhsiBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_PardakhtCheckSh_Insert", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@desc", item.Description ?? ""); cmd.Parameters.AddWithValue("@masterGuid", item.MasterGuid); cmd.Parameters.AddWithValue("@checkGuid", item.CheckPageGuid); cmd.Parameters.AddWithValue("@sarresid", item.DateSarResid); cmd.Parameters.AddWithValue("@price", item.Price); cmd.Parameters.AddWithValue("@dateM", item.DateM); cmd.Parameters.AddWithValue("@number", item.Number); 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 PardakhtCheckShakhsiBussines LoadData(SqlDataReader dr) { var item = new PardakhtCheckShakhsiBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.MasterGuid = (Guid)dr["MasterGuid"]; item.Description = dr["Description"].ToString(); item.Price = (decimal)dr["Price"]; item.Number = dr["Number"].ToString(); item.DateSarResid = (DateTime)dr["DateSarResid"]; item.DateM = (DateTime)dr["DateM"]; item.CheckPageGuid = (Guid)dr["CheckPageGuid"]; item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
public frmPardakhtCheckSh(Guid guid) { InitializeComponent(); cls = PardakhtCheckShakhsiBussines.Get(guid); ucHeader.Text = "پرداخت چک شخصی"; grp.Enabled = false; btnFinish.Enabled = false; }
private async void mnuBatel_Click(object sender, EventArgs e) { var res = new ReturnedSaveFuncInfo(); try { if (DGrid.RowCount <= 0 || DGrid.CurrentRow == null) { return; } var st = (EnCheckSh)DGrid[dgStatus.Index, DGrid.CurrentRow.Index].Value; if (st == EnCheckSh.Bargashti) { frmNotification.PublicInfo.ShowMessage($"شما مجاز به ابطال چک {st.GetDisplay()} نمی باشید"); return; } var guid = (Guid)DGrid[dgGuid.Index, DGrid.CurrentRow.Index].Value; var avalDore = (bool)DGrid[dgAvalDore.Index, DGrid.CurrentRow.Index].Value; if (MessageBox.Show("آیا از ابطال چک اطمینان دارید؟", "پیغام سیستم", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } if (!avalDore) { var str = await PardakhtCheckShakhsiBussines.GetAsync(guid); var rec = await PardakhtBussines.GetAsync(str.MasterGuid); rec.RemoveFromDetList(str); res.AddReturnedValue(await rec.SaveAsync()); return; } var cls = await PardakhtCheckAvalDoreBussines.GetAsync(guid); res.AddReturnedValue(await cls.RemoveAsync()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } finally { if (res.HasError) { this.ShowError(res, "خطا در ابطال چک پرداختنی"); } else { await LoadDataAsync(txtSearch.Text); } } }
private async Task LoadDataAsync(string search = "") { try { var list = await PardakhtCheckShakhsiBussines.GetAllViewModeAsync(search); Invoke(new MethodInvoker(() => CheckBindingSource.DataSource = list.ToSortableBindingList())); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
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 object GetRowInfo(int index) { try { var o = new object(); if (index > DGrid.RowCount - 1) { return(null); } if (DGrid[DGType.Index, index].Value.ToString() == "نقد") { var temp = new PardakhtNaqdBussines() { Guid = (Guid)(DGrid[DgGuid.Index, index].Value), Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()), SandouqTafsilGuid = (Guid)(DGrid[DGTafsilGuid.Index, index].Value), Description = DGrid[DG_TempDescription.Index, index].Value.ToString() }; o = temp; } else if (DGrid[DGType.Index, index].Value.ToString() == "چک دریافتی") { var temp = new PardakhtCheckMoshtariBussines() { Guid = (Guid)(DGrid[DgGuid.Index, index].Value), Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()), Description = DGrid[DG_TempDescription.Index, index].Value.ToString(), CheckGuid = (Guid)(DGrid[dgCheckGuid.Index, index].Value) }; o = temp; } else if (DGrid[DGType.Index, index].Value.ToString() == "حواله") { var temp = new PardakhtHavaleBussines() { Guid = (Guid)(DGrid[DgGuid.Index, index].Value), Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()), BankTafsilGuid = (Guid)(DGrid[DGTafsilGuid.Index, index].Value), Number = DGrid[DGNumber.Index, index].Value.ToString(), Description = DGrid[DG_TempDescription.Index, index].Value.ToString() }; o = temp; } else if (DGrid[DGType.Index, index].Value.ToString() == "چک شخصی") { var temp = new PardakhtCheckShakhsiBussines() { Guid = (Guid)(DGrid[DgGuid.Index, index].Value), Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()), Description = DGrid[DG_TempDescription.Index, index].Value.ToString(), CheckPageGuid = (Guid)(DGrid[dgCheckGuid.Index, index].Value), Number = DGrid[DGNumber.Index, index].Value.ToString(), DateSarResid = (DateTime)DGrid[DGDateSarresid.Index, index].Value }; o = temp; } return(o); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); return(null); } }
public static async Task <ReturnedSaveFuncInfo> BargashtAsync(PardakhtCheckShakhsiBussines 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 pardakht = await PardakhtBussines.GetAsync(cls.MasterGuid); var girande = await TafsilBussines.GetAsync(pardakht.TafsilGuid); checkPage.CheckStatus = EnCheckSh.Bargashti; checkPage.Modified = DateTime.Now; res.AddReturnedValue(await checkPage.SaveAsync()); 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 }; //بستانکار--شخص sanad.AddToListSanad(new SanadDetailBussines() { Guid = Guid.NewGuid(), Modified = DateTime.Now, Description = $"برگشت زدن چک {checkPage.Number} {bank.Name} * گیرنده: {girande.Name}", Debit = 0, Credit = cls.Price, TafsilGuid = pardakht.TafsilGuid, MasterGuid = sanad.Guid, MoeinGuid = pardakht.MoeinGuid }); //بدهکار--اسناد 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()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
public frmPardakhtCheckSh(PardakhtCheckShakhsiBussines temp) { InitializeComponent(); cls = temp ?? new PardakhtCheckShakhsiBussines(); ucHeader.Text = "پرداخت چک شخصی"; }