public Form_ApproveExpense(Form1 form, DBinterface dbInterface, List <string> id)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("en-US"));
localInterface = dbInterface;
mainForm = form;
this.ids = id;
DataTable dt = localInterface.Select("SELECT approved,date,amount FROM expenses WHERE id=" + ids[0]).Tables[0];
approved = (bool)dt.Rows[0][0];
comboBox1.SelectedIndex = 0;
if (approved)
{
comboBox1.SelectedIndex = 1;
}
date = MyUtills.dateFromSQL(dt.Rows[0][1].ToString());
dateTimePicker1.Value = date;
if (this.ids.Count > 1)
{
checkBoxDate.Checked = false;
textBox1.Visible = false;
label1.Visible = false;
}
else
{
textBox1.Text = String.Format("{0:0,0.00}", double.Parse(dt.Rows[0][2].ToString()));
}
}
public Form_EditIncome(Form1 form, DBinterface dbInterface, string id, bool def)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("en-US"));
localInterface = dbInterface;
mainForm = form;
this.id = id;
this.definite = def;
if (definite)
{
dateTimePicker1.Value = MyUtills.dateFromSQL(localInterface.Select("SELECT payDate FROM bills WHERE id=" + this.id).Tables[0].Rows[0][0].ToString());
}
else
{
dateTimePicker1.Value = MyUtills.dateFromSQL(localInterface.Select("SELECT toPayDate FROM bills WHERE id=" + this.id).Tables[0].Rows[0][0].ToString());
}
}