/// <summary> /// Delete the specific EmployeeAip and update AIP table /// </summary> public void Delete() { try { MySqlCommand cmd = new MySqlCommand(); string query; m_Connection.Open(); cmd.Connection = m_Connection; query = "DELETE FROM employeeaip WHERE employeeaipid = " + m_EmployeeAipID; cmd.CommandText = query; cmd.ExecuteNonQuery(); m_Connection.Close(); // update AIP table Aip oAip = new Aip(); oAip.Update(m_EmplID); } catch (Exception e) { m_Connection.Close(); throw (e); } }
/// <summary> /// Update the employeeAIP into database and update AIP table /// </summary> public void Update() { try { MySqlCommand cmd = new MySqlCommand(); string query; m_Connection.Open(); cmd.Connection = m_Connection; query = "UPDATE employeeaip SET aipcriteriaid =" + m_AipCriteriaID; query += " ,motif = '" + SQL.escapeString(m_Motif) + "'"; query += " ,taux = " + m_Taux; query += " ,startdate = '" + m_StartDate.Year + "." + m_StartDate.Month + "." + m_StartDate.Day + "'"; query += " ,enddate = '" + m_EndDate.Year + "." + m_EndDate.Month + "." + m_EndDate.Day + "'"; query += " WHERE employeeaipID = " + m_EmployeeAipID; cmd.CommandText = query; cmd.ExecuteNonQuery(); m_Connection.Close(); // update AIP table Aip oAip = new Aip(); oAip.Update(m_EmplID); } catch (Exception e) { m_Connection.Close(); throw (e); } }