private void addChequeBtn_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt32(chequeNumCreditor.Value) > 0)
{
//create row
ddGrid.Rows.AddNew();
//create check and set amounts
Check c = new DAOs.CheckDAO(db).selectCheck(chk);
if(chequeStatus.Text.Equals("صادر شده") || chequeStatus.Text.Equals("خرج شده"))
ddGrid.CurrentRow.Cells["Creditor"].Value = new DAOs.CheckDAO(db).getAccCheque(c, chequeStatus.Text);
else
ddGrid.CurrentRow.Cells["Debtor"].Value = new DAOs.CheckDAO(db).getAccCheque(c, chequeStatus.Text);
ddGrid.CurrentRow.Cells["Price"].Value = c.amount;
if (c.number != null)
ddGrid.CurrentRow.Cells["Behlaf"].Value = " طی چک " + "به شمارهی " + c.number + " نزد بانک " + c.bank;
else
ddGrid.CurrentRow.Cells["Behlaf"].Value = " طی چک " + " نزد بانک " + c.bank;
setAmount();
ddGrid.CurrentRow.Cells["ChequeID"].Value = c.ID;
ddGrid.CurrentRow.Cells["ChequeStatus"].Value = chequeStatus.Text;
ChequesTurnOver chqto = new ChequesTurnOver();
chqto.Status = chequeStatus.Text;
chqto.DaybookDescription = ((DaybookDescription)daybookDescriptionsBindingSource.Current);
chqto.ChequeID = c.ID;
new DAOs.ChequesTurnOverDAO(db).insertOnSubmit(chqto);
calculateAmount();
}
}
catch
{
MainMenuHandler.showMsg("خطا در افزودن چک", msgType.Error);
}
}
internal void insertOnSubmit(ChequesTurnOver ac)
{
db.ChequesTurnOvers.InsertOnSubmit(ac);
}
private void updateDataBaseDayBooks()
{
DaybookDescription dbdeb = new DaybookDescription();
DaybookDescription dbcred = new DaybookDescription();
dbcred.Creditor = Creditor.Value;
dbdeb.Debtor = Debtor.Value;
dbdeb.Price = dbcred.Price = Convert.ToInt32(amountTb.Value);
dbdeb.Behlaf = dbcred.Behlaf = behalf.Text;
dbdeb.DayBookInfo = dbcred.DayBookInfo = (DayBookInfo)dibs[0];
DaybookDAO d = new DaybookDAO(db);
d.insertOnSubmitDaybookDes(dbdeb);
d.insertOnSubmitDaybookDes(dbcred);
d.update();
if (!hadCheque)
{
ChequesTurnOver cto = new ChequesTurnOver();
cto.ChequeID = Convert.ToInt32(ChequeNum.Text);
cto.DayBookDesID = dbcred.ID;//is right?
cto.Status = ChequeStatus.Text;
new DAOs.ChequesTurnOverDAO(db).insertOnSubmit(cto);
}
else
{
chq.ChequeID = Convert.ToInt32(ChequeNum.Text);
chq.Status = ChequeStatus.Text;
}
d.update();
}
