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