private void button1_Click(object sender, EventArgs e)
{
try
{
bool isvalidated = validatefields();
if (isvalidated)
{
int workiid = Convert.ToInt32(Hidelabel6.Text);
WorkingDateAndTime workingDateAndTime = new WorkingDateAndTime();
workingDateAndTime.WorkingDateAndTimeID = workiid;
workingDateAndTime.EmployeeID = UpdatetextBoxEmployeeID.Text;
workingDateAndTime.EmployeeName = UpdatetextBoxEmployeeName.Text;
workingDateAndTime.StartDate = UpdatetextBoxStartDate.Text;
workingDateAndTime.EndDate = UpdatetextBoxEndDate.Text;
string message = WorkingDateAndTimeController.UpdateWorkingDateAndTime(workingDateAndTime);
MessageBox.Show(message);
loadgrid();
clear();
}
else
{
MessageBox.Show("please fill in all fields!");
}
}
catch (FormatException fe)
{
MessageBox.Show("please select a specific Working Dates and Times");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static string UpdateWorkingDateAndTime(WorkingDateAndTime workingDateAndTime)
{
string query = "UPDATE workingdateandtime SET `EmployeeID`='" + workingDateAndTime.EmployeeID + "', " +
"`EmployeeName`='" + workingDateAndTime.EmployeeName + "', " +
"`StartDate`='" + workingDateAndTime.StartDate + "', " +
"`EndDate`='" + workingDateAndTime.EndDate + "' " +
" WHERE `WorkingDateAndTimeID` = " + workingDateAndTime.WorkingDateAndTimeID;
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
MySqlDataReader reader;
try
{
databaseConnection.Open();
reader = commandDatabase.ExecuteReader();
databaseConnection.Close();
return("User succesfully updated");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static WorkingDateAndTime SelectedWorkingDateAndTime(int workingDateAndTimeid)
{
string query = "SELECT EmployeeID, EmployeeName, StartDate, EndDate " +
" FROM workingdateandtime where workingDateAndTimeid = " + workingDateAndTimeid;
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
MySqlDataReader reader;
try
{
databaseConnection.Open();
reader = commandDatabase.ExecuteReader();
if (reader.HasRows)
{
WorkingDateAndTime workingDateAndTime = new WorkingDateAndTime();
if (reader.Read())
{
workingDateAndTime.EmployeeID = reader.GetString(0);
workingDateAndTime.EmployeeName = reader.GetString(1);
workingDateAndTime.StartDate = reader.GetString(2);
workingDateAndTime.EndDate = reader.GetString(3);
}
return(workingDateAndTime);
}
else
{
Console.WriteLine("No rows found.");
}
databaseConnection.Close();
return(null);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
public static string AddWorkingDateAndTime(WorkingDateAndTime workingDateAndTime)
{
string query = "INSERT INTO workingdateandtime(`EmployeeID`,`EmployeeName`,`StartDate`,`EndDate`) " +
"VALUES " +
"('" + workingDateAndTime.EmployeeID + "', '" + workingDateAndTime.EmployeeName + "', '" + workingDateAndTime.StartDate + "', " +
"'" + workingDateAndTime.EndDate + "')";
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
try
{
databaseConnection.Open();
MySqlDataReader myReader = commandDatabase.ExecuteReader();
databaseConnection.Close();
return("User succesfully registered");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = dataGridView2.Rows[e.RowIndex];
int WorkingDateAndTimeID = Convert.ToInt32(row.Cells[0].Value.ToString());
WorkingDateAndTime workingDateAndTime = WorkingDateAndTimeController.SelectedWorkingDateAndTime(WorkingDateAndTimeID);
if (workingDateAndTime != null)
{
Hidelabel6.Text = workingDateAndTime.WorkingDateAndTimeID.ToString();
UpdatetextBoxEmployeeID.Text = workingDateAndTime.EmployeeID;
UpdatetextBoxEmployeeName.Text = workingDateAndTime.EmployeeName;
UpdatetextBoxStartDate.Text = workingDateAndTime.StartDate;
UpdatetextBoxEndDate.Text = workingDateAndTime.EndDate;
}
else
{
Hidelabel6.Text = string.Empty;
UpdatetextBoxEmployeeID.Text = string.Empty;
UpdatetextBoxEmployeeName.Text = string.Empty;
UpdatetextBoxEndDate.Text = string.Empty;
UpdatetextBoxEndDate.Text = string.Empty;
}
}
}
catch (FormatException fe)
{
MessageBox.Show("no data selected");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
