private void buttonShowMyJobs_Click(object sender, EventArgs e)
{
string csstatus = "";
string workerid = textBoxUserid.Text;
if (checkBoxMyOpen.Checked && !checkBoxMyClose.Checked)
{
csstatus = "open";
}
else if (!checkBoxMyOpen.Checked && checkBoxMyClose.Checked)
{
csstatus = "closed";
}
else if (checkBoxMyOpen.Checked && checkBoxMyClose.Checked)
{
csstatus = "";
}
dataGridView_W_Jobs.DataSource = CarService.GetJobsOfAWorker(workerid, csstatus);
}
private void buttonShowJobs_Click(object sender, EventArgs e)
{
OpenDB();
string csstatus = "";
string workerid = textBox_M_WorkerID.Text.Length == 0 ? "" : textBox_M_WorkerID.Text;
if (checkBoxAllOpen.Checked && !checkBoxAllClose.Checked)
{
csstatus = "open";
}
else if (!checkBoxAllOpen.Checked && checkBoxAllClose.Checked)
{
csstatus = "closed";
}
else if (checkBoxAllOpen.Checked && checkBoxAllClose.Checked)
{
csstatus = "";
}
if (workerid == "")
{
dataGridViewOpen.DataSource = CarService.GetAllJobs();
}
else
{
dataGridViewOpen.DataSource = CarService.GetJobsOfAWorker("", csstatus);
}
//string selectqry = "select * from cars_services where cars_servicesstatus like '%" +
// csstatus + "%' and cars_servicesworkerid like '%" + workerid + "%' order by cars_servicespriority";
//SQLiteCommand cmd = new SQLiteCommand(selectqry, m_dbConnection);
//SQLiteDataAdapter sql_data_adap = new SQLiteDataAdapter();
//sql_data_adap.SelectCommand = cmd;
//DataTable ManagerTable = new DataTable();
//ManagerTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
//sql_data_adap.Fill(ManagerTable);
//dataGridViewOpen.DataSource = ManagerTable;
//m_dbConnection.Close();
}
