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);
}
