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); } }