void HistoryData(string userAdmin, string tableName, TypeDIU typeDIU, string connectionString, Itemz itemDelete)
{
if (typeDIU == TypeDIU.Delete)
{
diuz = "Delete";
}
else if (typeDIU == TypeDIU.Insert)
{
diuz = "Insert";
}
else if (typeDIU == TypeDIU.Update)
{
diuz = "Update";
}
using (var command = new MySqlCommand())
{
command.Connection = new MySqlConnection(connectionString);
command.Connection.Open();
command.CommandText = $"insert into historyOfData(userAdmin,diu,tableName,id,namez,timeLine,pathImage) " +
$"values(@userAdmin,@diu,@tableName,@id,@namez,@timeLine,@pathImage)";
command.Parameters.AddWithValue("@pathImage", itemDelete.pathImage);
command.Parameters.AddWithValue("@userAdmin", AdminName);
command.Parameters.AddWithValue("@diu", $"{diuz}");
command.Parameters.AddWithValue("@tableName", tableName);
command.Parameters.AddWithValue("@id", itemDelete.id);
command.Parameters.AddWithValue("@namez", itemDelete.namez);
command.Parameters.AddWithValue("@timeLine", DateTime.Now.ToString());
command.ExecuteNonQuery();
command.Connection.Close();
}
}
void DeleteFilePathImage(string userAdmin, string tableName, TypeDIU typeDIU, string connectionString)
{
if (typeDIU == TypeDIU.Delete)
{
using (var command = new MySqlCommand())
{
command.Connection = new MySqlConnection(connectionString);
command.Connection.Open();
command.CommandText = $"select pathImage from {tableName} where userAdmin=@userAdmin and diu=@diu";
command.Parameters.AddWithValue("@userAdmin", userAdmin);
command.Parameters.AddWithValue("@diu", "Delete");
var result = command.ExecuteReader();
ObservableCollection <string> l = new ObservableCollection <string>();
if (result.HasRows)
{
while (result.Read())
{
l.Add(result.GetString("pathImage"));
}
result.Close();
}
command.Connection.Close();
foreach (var item in l)
{
try
{
if (System.IO.File.Exists(item))
{
System.IO.File.Delete(item);
}
}
catch
{
}
}
}
}
}
