예제 #1
0
        /// <summary>
        /// Delete the specific EmployeeAile and update AILE table
        /// </summary>
        public void Delete()
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                string       query;

                m_Connection.Open();

                cmd.Connection = m_Connection;

                query = "DELETE FROM employeeaile WHERE employeeaileid = " + m_EmployeeAileID;

                cmd.CommandText = query;
                cmd.ExecuteNonQuery();

                m_Connection.Close();

                // update AILE table
                Aile oAile = new Aile();
                oAile.Update(m_EmplID, m_WkgID);
            }
            catch (Exception e)
            {
                m_Connection.Close();
                throw (e);
            }
        }
예제 #2
0
        /// <summary>
        /// Update the employee aile into database and update AILE table
        /// </summary>
        public void Update()
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                string       query;

                m_Connection.Open();

                cmd.Connection = m_Connection;

                query  = "UPDATE employeeaile SET ailecriteriaid =" + m_AileCriteriaID;
                query += " ,wkgid = " + m_WkgID;
                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 employeeaileID = " + m_EmployeeAileID;

                cmd.CommandText = query;
                cmd.ExecuteNonQuery();

                m_Connection.Close();

                // update AILE table
                Aile oAile = new Aile();
                oAile.Update(m_EmplID, m_WkgID);
            }
            catch (Exception e)
            {
                m_Connection.Close();
                throw (e);
            }
        }
예제 #3
0
        /// <summary>
        /// Add the current object in the database and update AILE table
        /// </summary>
        public void Add()
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                String       sql;

                m_Connection.Open();

                cmd.Connection = m_Connection;

                sql  = "insert into employeeaile(wkgid, emplid, ailecriteriaID, motif, taux, startdate, enddate) values(";
                sql += m_WkgID;
                sql += ",";
                sql += m_EmplID;
                sql += ",";
                sql += m_AileCriteriaID;
                sql += ",'";
                sql += SQL.escapeString(m_Motif);
                sql += "',";
                sql += m_Taux;
                sql += ",'";
                sql += m_StartDate.Year + "." + m_StartDate.Month + "." + m_StartDate.Day;
                sql += "','";
                sql += m_EndDate.Year + "." + m_EndDate.Month + "." + m_EndDate.Day;
                sql += "')";

                cmd.CommandText = sql;

                cmd.ExecuteNonQuery();

                m_Connection.Close();

                // update AILE table
                Aile oAile = new Aile();
                oAile.Update(m_EmplID, m_WkgID);
            }
            catch (Exception e)
            {
                m_Connection.Close();
                throw (e);
            }
        }