public async Task <PardakhtCheckAvalDoreBussines> GetAsync(string _connectionString, Guid guid) { PardakhtCheckAvalDoreBussines res = null; try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_PardakhtCheckAvalDore_Get", 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); }
public async Task <ReturnedSaveFuncInfo> SaveAsync(PardakhtCheckAvalDoreBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_PardakhtCheckAvalDore_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@checkPageGuid", item.CheckPageGuid); cmd.Parameters.AddWithValue("@dasteCheckName", item.DasteCheckName ?? ""); cmd.Parameters.AddWithValue("@tafsilGuid", item.TafsilGuid); cmd.Parameters.AddWithValue("@userGuid", item.UserGuid); cmd.Parameters.AddWithValue("@sarmayeTafsilGuid", ParentDefaults.TafsilCoding.CLSTafsil5011001); cmd.Parameters.AddWithValue("@sarmayeMoeinGuid", ParentDefaults.MoeinCoding.CLSMoein50110); cmd.Parameters.AddWithValue("@tafsilCreditMoeinGuid", ParentDefaults.MoeinCoding.CLSMoein10304); cmd.Parameters.AddWithValue("@bankCreditMoeinGuid", ParentDefaults.MoeinCoding.CLSMoein10101); cmd.Parameters.AddWithValue("@sandouqCreditMoeinGuid", ParentDefaults.MoeinCoding.CLSMoein10102); 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 PardakhtCheckAvalDoreBussines LoadData(SqlDataReader dr) { var item = new PardakhtCheckAvalDoreBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.CheckPageGuid = (Guid)dr["CheckPageGuid"]; item.TafsilGuid = (Guid)dr["TafsilGuid"]; item.UserGuid = (Guid)dr["UserGuid"]; item.DasteCheckName = dr["DasteCheckName"].ToString(); item.Description = dr["Description"].ToString(); item.Price = (decimal)dr["Price"]; if (dr["DateSarresid"] != DBNull.Value) { item.DateSarresid = (DateTime)dr["DateSarresid"]; } item.Number = dr["Number"].ToString(); item.TafsilName = dr["TafsilName"].ToString(); item.UserName = dr["UserName"].ToString(); item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
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); } } }
public frmPardakhtCheckAvalDore(Guid guid, bool isShowMode) { InitializeComponent(); cls = PardakhtCheckAvalDoreBussines.Get(guid); ucHeader.Text = !isShowMode ? $"ویرایش چک پرداختی اول دوره" : $"مشاهده چک پرداختی اول دوره"; ucHeader.IsModified = true; grp.Enabled = !isShowMode; btnFinish.Enabled = !isShowMode; }
private static async Task <ReturnedSaveFuncInfo> NaqdBargashtAvalDoreAsync(PardakhtCheckAvalDoreBussines 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 girande = await TafsilBussines.GetAsync(cls.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 = cls.TafsilGuid, MasterGuid = sanad.Guid, MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein30103 }); res.AddReturnedValue(await sanad.SaveAsync()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
public frmPardakhtCheckAvalDore() { InitializeComponent(); cls = new PardakhtCheckAvalDoreBussines(); ucHeader.Text = "افزودن چک پرداختی اول دوره جدید"; }
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); }