private void Dev_Load(object sender, EventArgs e)
{
DatabaseHandler dbDev = new DatabaseHandler();
dg_Infotab_Dev1.DataSource = dbDev.GetDataView(DataDict.TBL10);
dg_ProjectsTab_Dev1.DataSource = dbDev.GetDataView(DataDict.TBL20);
dg_AppointmentsTab_Dev1.DataSource = dbDev.GetDataView(DataDict.TBL30);
dg_InvoicesTab_Dev1.DataSource = dbDev.GetDataView(DataDict.TBL40);
dg_infotab_Dev2.DataSource = dbDev.GetDataView(DataDict.TBL10);
dg_ProjectsTab_Dev2.DataSource = dbDev.GetDataView(DataDict.TBL20);
dg_AppointmentsTab_Dev2.DataSource = dbDev.GetDataView(DataDict.TBL30);
dg_InvoicesTab_Dev2.DataSource = dbDev.GetDataView(DataDict.TBL40);
}
private void finance_Load(object sender, EventArgs e)
{
DatabaseHandler dbFin = new DatabaseHandler();
dg_InfoTab_Finance1.DataSource = dbFin.GetDataView(DataDict.TBL10);
dg_ProjectsTab_Finance1.DataSource = dbFin.GetDataView(DataDict.TBL20);
dg_AppointmentsTab_Finance1.DataSource = dbFin.GetDataView(DataDict.TBL30);
dg_InvoicesTab_Finance1.DataSource = dbFin.GetDataView(DataDict.TBL40);
dg_InfoTab_Finance2.DataSource = dbFin.GetDataView(DataDict.TBL10);
dg_ProjectsTab_Finance2.DataSource = dbFin.GetDataView(DataDict.TBL20);
dg_AppointmentsTab_Finance2.DataSource = dbFin.GetDataView(DataDict.TBL30);
dg_InvoicesTab_Finance2.DataSource = dbFin.GetDataView(DataDict.TBL40);
}
private void btn_edit_Infotab_Dev_Click(object sender, EventArgs e)
{
DatabaseHandler dbDev = new DatabaseHandler();
if (btn_edit_Infotab_Dev.Text == "Edit")
{
btn_edit_Infotab_Dev.Text = "Save";
dg_Infotab_Dev1.ForeColor = Color.Gray;
dg_Infotab_Dev1.Enabled = false;
dg_infotab_Dev2.DataSource = dbDev.GetDataView(DataDict.TBL10);
dg_infotab_Dev2.Show();
}
else
{
dbDev.Update("SELECT * FROM tbl_customers;", "tbl_customers");
btn_edit_Infotab_Dev.Text = "Edit";
dg_Infotab_Dev1.Enabled = true;
dg_infotab_Dev2.Hide();
}
}
public client_list_Finance()
{
InitializeComponent();
DatabaseHandler dbFin = new DatabaseHandler();
dg_Client_list_Finance1.DataSource = dbFin.GetDataView(DataDict.TBL10, DataDict.FLD12);
}
public client_list_Dev()
{
InitializeComponent();
DatabaseHandler dbDev = new DatabaseHandler();
dg_Client_list_Dev1.DataSource = dbDev.GetDataView(DataDict.TBL10, DataDict.FLD12);
}