public Form_Settings(DBinterface dbInterface)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("en-US"));
localInterface = dbInterface;
}
public Form_Suppliers(DBinterface db)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = db;
}
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_ShowNote(string noteId, string inputText, DBinterface inter, Form1 form)
{
InitializeComponent();
text = inputText;
id = noteId;
interf = inter;
this.mainForm = form;
}
public MyLastSearch(Form1 form, DBinterface dbInterface)
{
this.isSearch = true;
this.panel = 0;
this.idQuery = "";
this.mainForm = form;
this.localInterface = dbInterface;
}
public Form_Expenses(Form1 form, DBinterface dbInterface)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
mainForm = form;
}
public Form_SelectCustomer(DBinterface dbInterface, Form1 form)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
formMain = form;
}
public Form_SelectProject(DBinterface dbInterface, Form_NewBill form)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
this.formNewBill = form;
this.projectIds = formNewBill.projectIds;
}
public Form_NewProject(Form1 form, DBinterface dbInterface, string customerName, string customerId)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
insertCustomer(customerName, customerId);
mainForm = form;
}
public Form_NewNote(DBinterface dbInterface, string billId, string billNumber, Form1 form)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
idBill = billId;
numberBill = billNumber;
mainForm = form;
}
public Form_NewBill(Form1 form, DBinterface dbInterface)
{
InitializeComponent();
projectIds = new List <int>();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
mainForm = form;
textBoxBillPart.Text = "1";
labelAmountNotes.Visible = false;
textBoxProjectAmountInfo.Visible = false;
}
public Form_Summery(DBinterface dbInterface)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
dateTimePickerYear.Format = DateTimePickerFormat.Custom;
dateTimePickerYear.CustomFormat = "yyyy";
localInterface = dbInterface;
ShowResults(dateTimePickerYear.Value.Year.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());
}
}
public Form_NewBill(Form1 form, DBinterface dbInterface, List <int> idProjects)
{
InitializeComponent();
projectIds = idProjects;
this.StartPosition = FormStartPosition.CenterScreen;
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("he-IL"));
localInterface = dbInterface;
updateProject(projectIds);
mainForm = form;
if (true)//(amountInfo == String.Empty)
{
labelAmountNotes.Visible = false;
textBoxProjectAmountInfo.Visible = false;
}
else
{
labelAmountNotes.Visible = true;
textBoxProjectAmountInfo.Visible = true;
}
}
