public RecordTreasury()
{
InitializeComponent();
this.BackgroundImageLayout = ImageLayout.Stretch;
this.Icon = Properties.Resources.merp1_ExR_icon;
Varibles.setConnection();
cmd = Varibles.getCommand();
te = new TreasuryEntry();
fillTreasuryEntryTypes();
}
private void collectPaper(int paperID, int SuppID, double amount)
{
try
{
TreasuryEntry treasury = new TreasuryEntry();
updatePaper(paperID, 1);
Double supplBlnc = getSuppBalance(SuppID);
treasury.addToTreasury(0, amount, DateTime.Now, "دفع ورقة دفع", " مدفوعات", 2, SuppID, 0, supplBlnc);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void addSupplierPayables()
{
double suppBalance = getSuppBalance(suppID);
TreasuryEntry tresuereEntry = new TreasuryEntry();
tresuereEntry.addToTreasury(0, paymentAmount, paymentDate, notes, " مدفوعات مورد : " + suppName, TreasuryEntry.TE_OUT, suppID, 0, suppBalance);
/*
* string query = "INSERT INTO `merp`.`treasuryentries` (`TE_IN`, `TE_DATE`, `TE_OPTITLE`, `TE_CMMTS`, `TE_SPLR_ID`, `TE_OPTYPE_ID`, `TE_BLNCE`) " +
* " VALUES ('" + paymentAmount + "', '" + paymentDate + "'," +
* " 'مدفوعات عميل : " + suppName + "', '" + notes + "', '" + suppID + "', '1', '" + suppBalance + "')";
* cmd.CommandText = query;
* cmd.ExecuteNonQuery();
*/
}
public ShowRecPapers()
{
InitializeComponent();
this.Icon = Properties.Resources.merp1_ExR_icon;
this.BackgroundImageLayout = ImageLayout.Stretch;
states = new List <ComboboxItem>();
cmb_state.DisplayMember = "Text";
cmb_state.ValueMember = "Value";
states.Add(new ComboboxItem("تحت التحصيل", 0));
states.Add(new ComboboxItem("محصل", 1));
states.Add(new ComboboxItem("مرفوض", 2));
cmb_state.DataSource = states;
treasury = new TreasuryEntry();
calcTotal();
}
private void addClientPayables()
{
double clientBalance = getClientBalance(clientID);
TreasuryEntry tresuereEntry = new TreasuryEntry();
tresuereEntry.addToTreasury(paymentAmount, 0, paymentDate, notes, " مدفوعات عميل : " + clientName, TreasuryEntry.TE_IN, 0, clientID, clientBalance);
/*
* Varibles.setConnection();
* cmd = Varibles.getCommand();
*
* string query = "INSERT INTO `merp`.`treasuryentries` (`TE_IN`, `TE_DATE`, `TE_OPTITLE`, `TE_CMMTS`, `TE_CLNT_ID`, `TE_OPTYPE_ID`, `TE_BLNCE`) " +
* " VALUES ('" + paymentAmount + "', '" + paymentDate + "'," +
* " 'مدفوعات عميل : " + clientName + "', '" + notes + "', '" + clientID + "', '1', '" + clientBalance + "')";
* cmd.CommandText = query;
* cmd.ExecuteNonQuery();
*
* Varibles.closeConnection();
*/
}