public bool Delete(AutoloadDTO Autoload) { try { // connecting _conn.Open(); // Query string string sql = "DELETE FROM " + _Table + " WHERE ID={0} "; string Query = string.Format(sql, Autoload.autoloadID); MySqlCommand Sqlcmd = new MySqlCommand(Query, _conn); // Query and check if (Sqlcmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception ex) { // xử lý ngoại lệ Console.WriteLine(ex.ToString()); } finally { // Close connect _conn.Close(); } return(false); }
// add item public bool Add(AutoloadDTO Autoload) { try { // connecting _conn.Open(); // Query string string sql = "INSERT INTO " + _Table + "(DATE_YMD, TIME_HH, STATUS, LOGDATA, FUNC) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')"; string Query = string.Format(sql, Autoload.autoloadDateYMD, Autoload.autoloadTimeHH, Autoload.autoloadStatus, Autoload.autoloadLogData, Autoload.autoloadFunc); MySqlCommand Sqlcmd = new MySqlCommand(Query, _conn); // Query and check if (Sqlcmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception ex) { // xử lý ngoại lệ Console.WriteLine(ex.ToString()); } finally { // Close connect _conn.Close(); } return(false); }
public bool Edit(AutoloadDTO Autoload) { try { // connecting _conn.Open(); // Query string string sql = "UPDATE " + _Table + " SET DATE_YMD={0}, TIME_HH={1}, STATUS={2}, LOGDATA={3}, FUNC={4} WHERE ID={5} "; string Query = string.Format(sql, Autoload.autoloadDateYMD, Autoload.autoloadTimeHH, Autoload.autoloadStatus, Autoload.autoloadLogData, Autoload.autoloadFunc); MySqlCommand Sqlcmd = new MySqlCommand(Query, _conn); // Query and check if (Sqlcmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception ex) { // xử lý ngoại lệ Console.WriteLine(ex.ToString()); } finally { // Close connect _conn.Close(); } return(false); }
// Add data (Autoload table) public bool AddAutoload() { bool Result = false; try { // Get data for Autoload AutoloadDTO Autoload = getAutoloadData(); // Add data to Autoload table Result = Auto.Add(Autoload); } catch (Exception ex) { Console.WriteLine("An exception of type " + ex.GetType()); } return(Result); }
// get data for Autoload public AutoloadDTO getAutoloadData() { AutoloadDTO Autoload = new AutoloadDTO(); try { string DateYMD = DateTime.Now.ToString("yyyy-MM-dd"); string TimeHH = DateTime.Now.ToString("HH:mm"); string Status = "OK"; //// lay file zip mới nhất (tên file) var LogData = this.getZipName(); string DataFunc = "AUTOMAIL"; // set AutoloadDTO Autoload = new AutoloadDTO(0, DateYMD, TimeHH, Status, LogData, DataFunc); } catch (Exception ex) { Console.WriteLine("An exception of type " + ex.GetType()); } // return return(Autoload); }