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 = "پرداخت چک شخصی";
}
