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