public async Task <ReceptionCheckBussines> GetAsync(string _connectionString, Guid guid)
{
ReceptionCheckBussines item = null;
try
{
using (var cn = new SqlConnection(_connectionString))
{
var cmd = new SqlCommand("sp_ReceptionCheck_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);
}
private ReceptionCheckBussines LoadData(SqlDataReader dr)
{
var item = new ReceptionCheckBussines();
try
{
item.Guid = (Guid)dr["Guid"];
item.Modified = (DateTime)dr["Modified"];
item.BankName = dr["BankName"].ToString();
item.DateM = (DateTime)dr["DateM"];
if (dr["MasterGuid"] != DBNull.Value)
{
item.MasterGuid = (Guid)dr["MasterGuid"];
}
item.Description = dr["Description"].ToString();
item.CheckNumber = dr["CheckNumber"].ToString();
item.PoshtNomre = dr["PoshtNomre"].ToString();
item.Price = (decimal)dr["Price"];
item.CheckStatus = (EnCheckM)dr["CheckStatus"];
item.DateSarResid = (DateTime)dr["DateSarResid"];
item.SandouqTafsilGuid = (Guid)dr["SandouqTafsilGuid"];
item.SandouqMoeinGuid = (Guid)dr["SandouqMoeinGuid"];
item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"];
item.ServerStatus = (ServerStatus)dr["ServerStatus"];
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
return(item);
}
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 ReceptionNaqdBussines()
{
Guid = (Guid)(DGrid[DgGuid.Index, index].Value),
Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()),
SandouqTafsilGuid = (Guid)(DGrid[DGTafsilGuid.Index, index].Value),
DateM = (DateTime)(DGrid[DGDate.Index, index].Value),
Description = DGrid[DG_TempDescription.Index, index].Value.ToString()
};
o = temp;
}
else if (DGrid[DGType.Index, index].Value.ToString() == "چک")
{
var temp = new ReceptionCheckBussines()
{
Guid = (Guid)(DGrid[DgGuid.Index, index].Value),
Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()),
BankName = DGrid[DGCheckBankName.Index, index].Value.ToString(),
DateM = (DateTime)(DGrid[DGDate.Index, index].Value),
CheckNumber = DGrid[DGNumber.Index, index].Value.ToString(),
CheckStatus = (EnCheckM)(DGrid[DGCheckStatus.Index, index].Value),
PoshtNomre = DGrid[DGPoshtNomre.Index, index].Value.ToString(),
Description = DGrid[DG_TempDescription.Index, index].Value.ToString(),
SandouqTafsilGuid = (Guid)(DGrid[DGTafsilGuid.Index, index].Value),
DateSarResid = (DateTime)(DGrid[DGDateSarresid.Index, index].Value)
};
o = temp;
}
else if (DGrid[DGType.Index, index].Value.ToString() == "حواله")
{
var temp = new ReceptionHavaleBussines()
{
Guid = (Guid)(DGrid[DgGuid.Index, index].Value),
Price = (DGrid[DGPrice.Index, index].Value.ToString().ParseToDecimal()),
BankTafsilGuid = (Guid)(DGrid[DGTafsilGuid.Index, index].Value),
DateM = (DateTime)(DGrid[DGDate.Index, index].Value),
PeygiriNumber = DGrid[DGNumber.Index, index].Value.ToString(),
Description = DGrid[DG_TempDescription.Index, index].Value.ToString(),
};
o = temp;
}
return(o);
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
return(null);
}
}
private ReceptionBussines LoadData(SqlDataReader dr)
{
var item = new ReceptionBussines();
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.CheckList = AsyncContext.Run(() => ReceptionCheckBussines.GetAllAsync(item.Guid));
item.HavaleList = AsyncContext.Run(() => ReceptionHavaleBussines.GetAllAsync(item.Guid));
item.NaqdList = AsyncContext.Run(() => ReceptionNaqdBussines.GetAllAsync(item.Guid));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
return(item);
}
public static async Task <ReturnedSaveFuncInfo> BargashtAsync(ReceptionCheckBussines cls)
{
var res = new ReturnedSaveFuncInfo();
try
{
cls.CheckStatus = EnCheckM.Bargashti;
cls.Modified = DateTime.Now;
res.AddReturnedValue(await cls.SaveAsync());
var reception = await ReceptionBussines.GetAsync(cls.MasterGuid.Value);
var pardazande = await TafsilBussines.GetAsync(reception.TafsilGuid);
var sanad = new SanadBussines()
{
Guid = Guid.NewGuid(),
Modified = DateTime.Now,
Description = $"برگشت زدن چک دریافتنی * شناره: {cls.CheckNumber} بانک صادرکننده: {cls.BankName} * پردازنده: {pardazande.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 = $"برگشت زدن چک {cls.CheckNumber} {cls.BankName} * پردازنده: {pardazande.Name}",
Debit = 0,
Credit = cls.Price,
TafsilGuid = cls.SandouqTafsilGuid,
MasterGuid = sanad.Guid,
MoeinGuid = cls.SandouqMoeinGuid
});
//بدهکار--شخص
sanad.AddToListSanad(new SanadDetailBussines()
{
Guid = Guid.NewGuid(),
Modified = DateTime.Now,
Description = $"برگشت زدن چک {cls.CheckNumber} {cls.BankName} * پردازنده: {pardazande.Name}",
Debit = cls.Price,
Credit = 0,
TafsilGuid = pardazande.Guid,
MasterGuid = sanad.Guid,
MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein10304
});
res.AddReturnedValue(await sanad.SaveAsync());
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return(res);
}
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 ReceptionCheckBussines.GetAsync(guid);
var rec = await ReceptionBussines.GetAsync(str.MasterGuid.Value);
var sanad = await SanadBussines.GetAsync(rec.SanadNumber);
var frm_ = new frmSanadMain(sanad.Guid, true);
frm_.ShowDialog(this);
return;
}
var frm = new frmCheckM_AvalDore(guid, true);
frm.ShowDialog(this);
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
public frmReceptionCheck(Guid guid)
{
InitializeComponent();
cls = ReceptionCheckBussines.Get(guid);
ucHeader.Text = "دریافت چک";
grp.Enabled = false;
btnFinish.Enabled = false;
}
public frmCheckM_Vagozar(ReceptionCheckBussines cls, HesabType hType)
{
InitializeComponent();
_oldTafsil = TafsilBussines.Get(cls.SandouqTafsilGuid);
_isAvalDore = false;
_newHesabType = hType;
rec = cls;
}
private async void mnuBatel_Click(object sender, EventArgs e)
{
var res = new ReturnedSaveFuncInfo();
try
{
if (DGrid.RowCount <= 0 || DGrid.CurrentRow == null)
{
return;
}
var st = (EnCheckM)DGrid[dgStatus.Index, DGrid.CurrentRow.Index].Value;
if (st == EnCheckM.Bargashti || st == EnCheckM.Naqd)
{
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 ReceptionCheckBussines.GetAsync(guid);
var rec = await ReceptionBussines.GetAsync(str.MasterGuid.Value);
rec.RemoveFromDetList(str);
res.AddReturnedValue(await rec.SaveAsync());
return;
}
var cls = await ReceptionCheckAvalDoreBussines.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 ReceptionCheckBussines.GetAllViewModeAsync(search);
Invoke(new MethodInvoker(() => CheckBindingSource.DataSource = list.ToSortableBindingList()));
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private async void mnuVagozarBank_Click(object sender, EventArgs e)
{
try
{
if (DGrid.RowCount <= 0 || DGrid.CurrentRow == null)
{
return;
}
var st = (EnCheckM)DGrid[dgStatus.Index, DGrid.CurrentRow.Index].Value;
if (st == EnCheckM.Kharj || st == EnCheckM.Naqd)
{
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 ReceptionCheckBussines.GetAsync(guid);
var frm = new frmCheckM_Vagozar(str, HesabType.Bank);
if (frm.ShowDialog(this) == DialogResult.OK)
{
await LoadDataAsync(txtSearch.Text);
}
return;
}
var cls = await ReceptionCheckAvalDoreBussines.GetAsync(guid);
var frm_ = new frmCheckM_Vagozar(cls, HesabType.Bank);
if (frm_.ShowDialog(this) == DialogResult.OK)
{
await LoadDataAsync(txtSearch.Text);
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private static async Task <ReturnedSaveFuncInfo> NaqdBargashtAsync(ReceptionCheckBussines cls, SanadBussines sanad)
{
var res = new ReturnedSaveFuncInfo();
try
{
var reception = await ReceptionBussines.GetAsync(cls.MasterGuid.Value);
var pardazande = await TafsilBussines.GetAsync(reception.TafsilGuid);
//بستانکار--شخص
sanad.AddToListSanad(new SanadDetailBussines()
{
Guid = Guid.NewGuid(),
Modified = DateTime.Now,
Description = $"استرداد چک {cls.CheckNumber} {cls.BankName} * پردازنده: {pardazande.Name}",
Debit = 0,
Credit = cls.Price,
TafsilGuid = pardazande.Guid,
MasterGuid = sanad.Guid,
MoeinGuid = ParentDefaults.MoeinCoding.CLSMoein10304
});
//بدهکار--اسناد
sanad.AddToListSanad(new SanadDetailBussines()
{
Guid = Guid.NewGuid(),
Modified = DateTime.Now,
Description = $"استرداد چک {cls.CheckNumber} {cls.BankName} * پردازنده: {pardazande.Name}",
Debit = cls.Price,
Credit = 0,
TafsilGuid = cls.SandouqTafsilGuid,
MasterGuid = sanad.Guid,
MoeinGuid = cls.SandouqMoeinGuid
});
res.AddReturnedValue(await sanad.SaveAsync());
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return(res);
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(ReceptionCheckBussines item, SqlTransaction tr)
{
var res = new ReturnedSaveFuncInfo();
try
{
var cmd = new SqlCommand("sp_ReceptionCheck_Insert", tr.Connection, tr)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@guid", item.Guid);
cmd.Parameters.AddWithValue("@modif", item.Modified);
cmd.Parameters.AddWithValue("@bankName", item.BankName ?? "");
cmd.Parameters.AddWithValue("@desc", item.Description ?? "");
cmd.Parameters.AddWithValue("@dateM", item.DateM);
cmd.Parameters.AddWithValue("@masterGuid", item.MasterGuid);
cmd.Parameters.AddWithValue("@checkNumber", item.CheckNumber ?? "");
cmd.Parameters.AddWithValue("@poshtNomre", item.PoshtNomre ?? "");
cmd.Parameters.AddWithValue("@price", item.Price);
cmd.Parameters.AddWithValue("@checkStatus", (int)item.CheckStatus);
cmd.Parameters.AddWithValue("@sarResid", item.DateSarResid);
cmd.Parameters.AddWithValue("@sandouqTafsilGuid", item.SandouqTafsilGuid);
if (item.SandouqMoeinGuid == Guid.Empty)
{
item.SandouqMoeinGuid = ParentDefaults.MoeinCoding.CLSMoein10104;
}
cmd.Parameters.AddWithValue("@sandouqMoeinGuid", item.SandouqMoeinGuid);
cmd.Parameters.AddWithValue("@isAvalDore", item.isAvalDore);
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 frmReceptionCheck(ReceptionCheckBussines temp)
{
InitializeComponent();
cls = temp ?? new ReceptionCheckBussines();
ucHeader.Text = "دریافت چک";
}