public static bool addWorkstationDetails(WorkstationDetails wd)
{
DBConnector dbcon = new DBConnector();
//try
//{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO workstation_details (rank, division, post, date_of_post, salary_station, responsibility, power, employee_idemployee) VALUES (N'" + wd.rank + "', N'" + wd.division + "', N'" + wd.post + "', '" + wd.getDate_of_post().ToString("yyyy-MM-dd") + "', N'" + wd.salary_station + "', N'" + wd.responsibility + "', N'" + wd.power + "', " + Employee.employee_id + ")";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
dbcon.closeConnection();
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//dbcon.closeConnection();
//return false;
//}
}
public static WorkstationDetails getWorkstationDetails()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM workstation_details WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Console.Write(Employee.employee_id + "\n");
WorkstationDetails wd = null;
if (reader.Read())
{
wd = new WorkstationDetails();
wd.ws_id = int.Parse(reader["idworkstation_details"].ToString());
wd.division = reader["division"].ToString();
wd.post = reader["post"].ToString();
wd.power = reader["power"].ToString();
wd.rank = reader["rank"].ToString();
wd.responsibility = reader["responsibility"].ToString();
wd.salary_station = reader["salary_station"].ToString();
wd.setDate_of_post(Convert.ToDateTime(reader["date_of_post"]));
}
reader.Close();
dbcon.closeConnection();
return wd;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public void updateWorkstation()
{
WorkstationDetails wd = new WorkstationDetails();
wd.ws_id = this.ws_id;
wd.division = this.wsd_division.Text;
wd.post = this.wsd_post.Text;
wd.power = this.wsd_power.Text;
wd.rank = this.wsd_rank.Text;
wd.responsibility = this.wsd_responsibility.Text;
wd.salary_station = this.wsd_salary_station.Text;
wd.setDate_of_post(this.wsd_date_of_post_date.Value.Date);
bool state = WorkstationDetailsHandler.updateWorkstationDetails(wd);
Console.Write(state + "\n");
}
public static bool updateWorkstationDetails(WorkstationDetails ws)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE workstation_details SET rank=N'" + ws.rank + "', division=N'" + ws.division + "', post=N'" + ws.post + "', date_of_post='" + ws.getDate_of_post().ToString("yyyy-MM-dd") + "', salary_station=N'" + ws.salary_station + "', responsibility=N'" + ws.responsibility + "', power=N'" + ws.power + "' WHERE employee_idemployee=" + Employee.employee_id + " AND idworkstation_details=" + ws.ws_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
private void btnSave5_Click(object sender, EventArgs e)
{
//Save Workstation details
WorkstationDetails wd = new WorkstationDetails();
wd.division = wsd_division.Text;
wd.post = wsd_post.Text;
wd.power = wsd_power.Text;
wd.rank = wsd_rank.Text;
wd.responsibility = wsd_responsibility.Text;
wd.salary_station = wsd_salary_station.Text;
wd.setDate_of_post(wsd_date_of_post_date.Value.Date);
bool status = WorkstationDetailsHandler.addWorkstationDetails(wd);
if (status)
{
MessageBox.Show("Workstation details added successfully...!");
btnNext.Enabled = true;
}
else { MessageBox.Show("Failed to add workstation details...!"); }
}
