public void updateJobTypes()
{
GData.jobTypes = DatabaseControl.getJobTypes();
jobType_Cmb.Items.Clear();
foreach (JobType job in GData.jobTypes)
{
jobType_Cmb.Items.Add(job.typeName);
}
jobType_Cmb.Text = "";
}
public void showJobTypes()
{
BindingSource bs = new BindingSource();
GData.jobTypes = DatabaseControl.getJobTypes();
bs.DataSource = GData.jobTypes.Select(j => new FilteredJobType()
{
id = j.id,
typeName = j.typeName,
background = j.background
}).ToList();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = bs;
UIControl.newBookingForm.updateJobTypes();
UIControl.editBookingForm.updateJobTypes();
}
private void connect_Bt_Click(object sender, EventArgs e)
{
GData.hostAddress = hostAddress_Txt.Text;
if (GData.hostAddress == "")
{
MessageBox.Show("Please input Host Address");
hostAddress_Txt.Focus();
return;
}
GData.userID = user_Txt.Text;
if (GData.userID == "")
{
MessageBox.Show("Please input User ID");
user_Txt.Focus();
return;
}
GData.password = password_Txt.Text;
GData.port = port_Txt.Text;
GData.conStr = "Data Source=" + GData.hostAddress + "\\SQLEXPRESS," + GData.port +
";Network Library=DBMSSOCN;User ID=" + GData.userID + ";Password="******"Data Source=" + GData.hostAddress + "\\SQLEXPRESS," + GData.port +
";Network Library=DBMSSOCN;;Initial Catalog=HordernsDB;User ID=" + GData.userID + ";Password="******"Data Source=" + Info.hostAddress +
// ";Integrated Security=SSPI;Initial Catalog=" + Info.database + ";";
// Connect to Database and get data of Booking, JobType, and Technicians
if (DatabaseControl.CreateDBIfNotExists())
{
GData.bookings = DatabaseControl.getBookings();
GData.jobTypes = DatabaseControl.getJobTypes();
GData.technicians = DatabaseControl.getTechnicians();
GData.customers = DatabaseControl.getCustomers();
UIControl.mainForm.Show();
this.Hide();
}
}
