public static string Sauvegarde(BaseDonnee myDatabase, bool download = false)
{
string cheminFile = string.Empty;
if (File.Exists(Param.MysqlBinPath) && myDatabase != null)
{
string repPath = string.Empty;
if (download)
{
repPath = Param.TMP;
}
else
{
repPath = myDatabase.cheminSauvegarde;
}
cheminFile = Path.Combine(repPath, "bdd-" + myDatabase.databaseName + "-" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".sql");
//string args = " -h " + myDatabase.host + " -u " + myDatabase.user + " -p" + myDatabase.password + " -r \"" + cheminFile + "\" " + myDatabase.databaseName;
//Process.Start(Param.MysqlBinPath, args);
//On lance le processus
ProcessStartInfo myProcessStartInfo = new ProcessStartInfo();
myProcessStartInfo.FileName = "cmd";
myProcessStartInfo.Arguments = "/c \"\"" + Param.MysqlBinPath + "\" -h " + myDatabase.host + " -u " + myDatabase.user + " -p" + myDatabase.password + " --quick -B " + myDatabase.databaseName + " > \"" + cheminFile + "\"\"";
myProcessStartInfo.WindowStyle = ProcessWindowStyle.Hidden;
Process myProcess = new Process();
myProcess.StartInfo = myProcessStartInfo;
myProcess.Start();
myProcess.WaitForExit();
if (File.Exists(cheminFile))
{
string zipfile = Path.Combine(repPath, Path.GetFileNameWithoutExtension(cheminFile) + ".zip");
if (File.Exists(zipfile))
{
File.Delete(zipfile);
}
using (ZipArchive zip = ZipFile.Open(zipfile, ZipArchiveMode.Create))
{
zip.CreateEntryFromFile(cheminFile, Path.GetFileName(cheminFile));
File.Delete(cheminFile);
cheminFile = Path.Combine(repPath, zipfile);
}
}
}
return(cheminFile);
}
public static string Sauvegarde(BaseDonnee myDatabase, bool download = false)
{
string cheminFile = string.Empty;
if (File.Exists(Param.MysqlBinPath) && myDatabase != null)
{
string repPath = string.Empty;
if (download)
repPath = Param.TMP;
else
repPath = myDatabase.cheminSauvegarde;
cheminFile = Path.Combine(repPath, "bdd-" + myDatabase.databaseName + "-" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".sql");
//string args = " -h " + myDatabase.host + " -u " + myDatabase.user + " -p" + myDatabase.password + " -r \"" + cheminFile + "\" " + myDatabase.databaseName;
//Process.Start(Param.MysqlBinPath, args);
//On lance le processus
ProcessStartInfo myProcessStartInfo = new ProcessStartInfo();
myProcessStartInfo.FileName = "cmd";
myProcessStartInfo.Arguments = "/c \"\"" + Param.MysqlBinPath + "\" -h " + myDatabase.host + " -u " + myDatabase.user + " -p" + myDatabase.password + " --quick -B " + myDatabase.databaseName + " > \"" + cheminFile + "\"\"";
myProcessStartInfo.WindowStyle = ProcessWindowStyle.Hidden;
Process myProcess = new Process();
myProcess.StartInfo = myProcessStartInfo;
myProcess.Start();
myProcess.WaitForExit();
if (File.Exists(cheminFile))
{
string zipfile = Path.Combine(repPath, Path.GetFileNameWithoutExtension(cheminFile) + ".zip");
if (File.Exists(zipfile))
{
File.Delete(zipfile);
}
using (ZipArchive zip = ZipFile.Open(zipfile, ZipArchiveMode.Create))
{
zip.CreateEntryFromFile(cheminFile, Path.GetFileName(cheminFile));
File.Delete(cheminFile);
cheminFile = Path.Combine(repPath, zipfile);
}
}
}
return cheminFile;
}
public static BaseDonnee Update(BaseDonnee myItem)
{
return BaseDonneeDB.Update(myItem);
}
public static BaseDonnee Insert(BaseDonnee myItem)
{
return BaseDonneeDB.Insert(myItem);
}
protected void btnEditDatabaseSave_Click(object sender, EventArgs e)
{
Projet myProjet = GetProjet();
if (myProjet != null)
{
bool isModif = false;
BaseDonnee myDatabase = new BaseDonnee();
if (!string.IsNullOrEmpty(hfDatabseId.Value))
{
myDatabase = BaseDonneeManager.Load(iZyInt.ConvertStringToInt(hfDatabseId.Value));
if (myDatabase != null) isModif = true;
else myDatabase = new BaseDonnee();
}
myDatabase.host = tbEditDatabaseHost.Text;
myDatabase.databaseName = tbEditDatabaseName.Text;
myDatabase.user = tbEditDatabaseUser.Text;
myDatabase.password = tbEditDatabasePassword.Text;
myDatabase.cheminSauvegarde = tbEditDatabaseChemin.Text;
myDatabase.idProjet = myProjet.id;
myDatabase.libelle = tbEditDatabaseLibelle.Text;
if (isModif) BaseDonneeManager.Update(myDatabase);
else BaseDonneeManager.Insert(myDatabase);
ListeBaseDonnees_Init();
ResetDatabaseForm();
btnAddDatabase.Enabled = true;
pnlEditDatabase.Visible = false;
// Sauvegarde
upDatabase.Update();
}
}
public static BaseDonnee Update(BaseDonnee myItem)
{
return(BaseDonneeDB.Update(myItem));
}
public static BaseDonnee Insert(BaseDonnee myItem)
{
return(BaseDonneeDB.Insert(myItem));
}
