public void lista_planos_copiaseguranca()
{
init();
AdmBEPlanosCopiasSeg lista = _admBs.PlanosCopiasSeguranca.ListaPlanos();
foreach (AdmBEPlanoCopiasSeg pl in lista)
{
string id = pl.get_Id();
Console.WriteLine("PlanoCopiasSeg_id: " + id);
string xmlPlano = pl.get_Plano();
// Console.WriteLine(" xml: " + xmlPlano);
XmlReader xmlreader = XmlReader.Create(new StringReader(xmlPlano));
//xmlreader.Read();
xmlreader.ReadToFollowing("backupPlan");
Console.WriteLine(" id: " + xmlreader.GetAttribute("id"));
Console.WriteLine(" name: " + xmlreader.GetAttribute("name"));
Console.WriteLine(" verify: " + xmlreader.GetAttribute("verify"));
Console.WriteLine(" incremental: " + xmlreader.GetAttribute("incremental"));
Console.WriteLine(" overwrite: " + xmlreader.GetAttribute("overwrite"));
Console.WriteLine(" destination: " + xmlreader.GetAttribute("destination"));
// Console.WriteLine(" schedule: " + xmlreader.GetAttribute("schedule"));
Console.WriteLine(" date: " + xmlreader.GetAttribute("date"));
Console.WriteLine(" lastExecution: " + xmlreader.GetAttribute("lastExecution"));
Console.WriteLine(" nextExecution: " + xmlreader.GetAttribute("nextExecution"));
string schedule_id = xmlreader.GetAttribute("schedule");
Console.WriteLine(" schedule id: " + schedule_id);
AdmBECalendario pcal = _admBs.Calendario.Edita(schedule_id);
// Console.WriteLine(" schedule_id: " + pcal.Id );
Console.WriteLine(" schedule_periodo: " + pcal.get_Periodo().ToString());
xmlreader.ReadToFollowing("companies");
while (xmlreader.ReadToFollowing("company"))
{
xmlreader.ReadToFollowing("properties");
Console.WriteLine(" company_key: " + xmlreader.GetAttribute("key"));
Console.WriteLine(" company_name: " + xmlreader.GetAttribute("name"));
}
}
}
public void insere_plano_copiaseguranca(string name, string verify, string incremental, string overwrite, string companiesByComma, string periodo)
{
init();
string newid = System.Guid.NewGuid().ToString();
AdmBEPlanoCopiasSeg newPC = new AdmBEPlanoCopiasSeg();
AdmBECalendario objCal = new AdmBECalendario();
newPC.set_Id(newid);
objCal.Id = newid;
if (periodo.Equals("mensal"))
objCal.set_Periodo(EnumPeriodoExecucao.prMensal);
else if (periodo.Equals("semanal"))
objCal.set_Periodo(EnumPeriodoExecucao.prSemanal);
else
objCal.set_Periodo(EnumPeriodoExecucao.prDiario);
// Exec 23h (TODO change this by arg)
objCal.set_FreqUnicaHora(new DateTime(1900, 1, 1, 23, 0, 0));
adm.Calendario.Actualiza(objCal);
StringWriter stringwriter = new StringWriter();
XmlWriterSettings xmlsettings = new XmlWriterSettings();
xmlsettings.OmitXmlDeclaration = true;
xmlsettings.Indent = false;
XmlWriter xmlwriter = XmlWriter.Create(stringwriter, xmlsettings);
xmlwriter.WriteStartElement("backupPlan");
xmlwriter.WriteAttributeString("id", "{" + newPC.get_Id() + "}");
xmlwriter.WriteAttributeString("name", name);
xmlwriter.WriteAttributeString("verify", verify);
xmlwriter.WriteAttributeString("incremental", incremental);
xmlwriter.WriteAttributeString("overwrite", overwrite);
string backupsdir = Backupsdir;
if( backupsdir==null ) backupsdir = adm.SQLServer.DirectoriaBackup();
xmlwriter.WriteAttributeString("destination", backupsdir);
xmlwriter.WriteAttributeString("schedule", "{" + objCal.Id + "}");
//Common.WriteToConsoleOut(" date: " + xmlreader.GetAttribute("date"));
DateTime datenow = DateTime.Now;
xmlwriter.WriteAttributeString("date", datenow.ToString("dd-MM-yyyy HH:mm:ss"));
//Common.WriteToConsoleOut(" lastExecution: " + xmlreader.GetAttribute("lastExecution"));
DateTime lastdate = objCal.UltimaOcorrencia;
xmlwriter.WriteAttributeString("lastExecution", lastdate.ToString("dd-MM-yyyy HH:mm:ss"));
//Common.WriteToConsoleOut(" nextExecution: " + xmlreader.GetAttribute("nextExecution"));
//DateTime nextdate = new DateTime(datenow.Year,datenow.Month,datenow.Day);
DateTime nextdate = objCal.ProximaOcorrencia;
xmlwriter.WriteAttributeString("nextExecution", nextdate.ToString("dd-MM-yyyy HH:mm:ss"));
// companies
xmlwriter.WriteStartElement("companies");
//string companiesByComma = "DEMO,PRIDEMO;DEMOX,PRIDEMOX";
string[] companies = companiesByComma.Split(new char[] { ';' });
foreach (string company in companies)
{
string[] cfields = company.Split(new char[] { ',' });
if (cfields.Length == 2)
{
xmlwriter.WriteStartElement("company");
xmlwriter.WriteStartElement("properties");
xmlwriter.WriteAttributeString("key", cfields[0]);
xmlwriter.WriteAttributeString("name", cfields[1]);
xmlwriter.WriteEndElement(); // properties
xmlwriter.WriteEndElement(); // company
}
}
xmlwriter.WriteEndElement(); // companies
xmlwriter.WriteEndElement(); // backupPlan
xmlwriter.Flush();
//Common.WriteToConsoleOut("xml string: " + stringwriter.ToString());
//string strBackupPlan = "<backupPlan id=\"" + newpc_id + "\" name=\"teste all\" verify=\"False\" incremental=\"False\" overwrite=\"False\" destination=\"C:\\PROGRAM FILES\\MICROSOFT SQL SERVER\\MSSQL10.PRIMAVERA\\MSSQL\\BACKUP\\\" schedule=\"" + newpc_id + "\" date=\"" + DateTime.Now.ToString() + "\" lastExecution=\"undefined\" nextExecution=\"" + DateTime.Now.ToString("dd-MM-yyyy") + " 23:00:00\"><companies><company><properties key=\"OBIADM\" name=\"BIADM\"/></company><company><properties key=\"EDEMO\" name=\"PRIDEMO\"/></company><company><properties key=\"EDEMOX\" name=\"PRIDEMOX\"/></company><company><properties key=\"OPRIEMPRE\" name=\"PRIEMPRE\"/></company></companies></backupPlan>";
newPC.set_Plano(stringwriter.ToString());
adm.PlanosCopiasSeguranca.Actualiza(newPC);
adm.PlanosCopiasSeguranca.ListaPlanos().Insere(newPC);
Common.WriteToConsoleOut(" Plano de Copia Seguranca inserido com id: " + newPC.get_Id());
}
public void insere_plano_copiaseguranca(string name, string verify, string incremental, string overwrite, string companiesByComma, string periodo)
{
init();
string newid = System.Guid.NewGuid().ToString();
AdmBEPlanoCopiasSeg newPC = new AdmBEPlanoCopiasSeg();
AdmBECalendario objCal = new AdmBECalendario();
newPC.set_Id(newid);
objCal.Id = newid;
if (periodo.Equals("mensal"))
{
objCal.set_Periodo(EnumPeriodoExecucao.prMensal);
}
else if (periodo.Equals("semanal"))
{
objCal.set_Periodo(EnumPeriodoExecucao.prSemanal);
}
else
{
objCal.set_Periodo(EnumPeriodoExecucao.prDiario);
}
// Exec 23h (TODO change this by arg)
objCal.set_FreqUnicaHora(new DateTime(1900, 1, 1, 23, 0, 0));
_admBs.Calendario.Actualiza(objCal);
StringWriter stringwriter = new StringWriter();
XmlWriterSettings xmlsettings = new XmlWriterSettings();
xmlsettings.OmitXmlDeclaration = true;
xmlsettings.Indent = false;
XmlWriter xmlwriter = XmlWriter.Create(stringwriter, xmlsettings);
xmlwriter.WriteStartElement("backupPlan");
xmlwriter.WriteAttributeString("id", "{" + newPC.get_Id() + "}");
xmlwriter.WriteAttributeString("name", name);
xmlwriter.WriteAttributeString("verify", verify);
xmlwriter.WriteAttributeString("incremental", incremental);
xmlwriter.WriteAttributeString("overwrite", overwrite);
string backupsdir = Backupsdir;
if (backupsdir == null)
{
backupsdir = _admBs.SQLServer.DirectoriaBackup();
}
xmlwriter.WriteAttributeString("destination", backupsdir);
xmlwriter.WriteAttributeString("schedule", "{" + objCal.Id + "}");
// Console.WriteLine(" date: " + xmlreader.GetAttribute("date"));
DateTime datenow = DateTime.Now;
xmlwriter.WriteAttributeString("date", datenow.ToString("dd-MM-yyyy HH:mm:ss"));
// Console.WriteLine(" lastExecution: " + xmlreader.GetAttribute("lastExecution"));
DateTime lastdate = objCal.UltimaOcorrencia;
xmlwriter.WriteAttributeString("lastExecution", lastdate.ToString("dd-MM-yyyy HH:mm:ss"));
// Console.WriteLine(" nextExecution: " + xmlreader.GetAttribute("nextExecution"));
//DateTime nextdate = new DateTime(datenow.Year,datenow.Month,datenow.Day);
DateTime nextdate = objCal.ProximaOcorrencia;
xmlwriter.WriteAttributeString("nextExecution", nextdate.ToString("dd-MM-yyyy HH:mm:ss"));
// companies
xmlwriter.WriteStartElement("companies");
//string companiesByComma = "DEMO,PRIDEMO;DEMOX,PRIDEMOX";
string[] companies = companiesByComma.Split(new char[] { ';' });
foreach (string company in companies)
{
string[] cfields = company.Split(new char[] { ',' });
if (cfields.Length == 2)
{
xmlwriter.WriteStartElement("company");
xmlwriter.WriteStartElement("properties");
xmlwriter.WriteAttributeString("key", cfields[0]);
xmlwriter.WriteAttributeString("name", cfields[1]);
xmlwriter.WriteEndElement(); // properties
xmlwriter.WriteEndElement(); // company
}
}
xmlwriter.WriteEndElement(); // companies
xmlwriter.WriteEndElement(); // backupPlan
xmlwriter.Flush();
// Console.WriteLine("xml string: " + stringwriter.ToString());
//string strBackupPlan = "<backupPlan id=\"" + newpc_id + "\" name=\"teste all\" verify=\"False\" incremental=\"False\" overwrite=\"False\" destination=\"C:\\PROGRAM FILES\\MICROSOFT SQL SERVER\\MSSQL10.PRIMAVERA\\MSSQL\\BACKUP\\\" schedule=\"" + newpc_id + "\" date=\"" + DateTime.Now.ToString() + "\" lastExecution=\"undefined\" nextExecution=\"" + DateTime.Now.ToString("dd-MM-yyyy") + " 23:00:00\"><companies><company><properties key=\"OBIADM\" name=\"BIADM\"/></company><company><properties key=\"EDEMO\" name=\"PRIDEMO\"/></company><company><properties key=\"EDEMOX\" name=\"PRIDEMOX\"/></company><company><properties key=\"OPRIEMPRE\" name=\"PRIEMPRE\"/></company></companies></backupPlan>";
newPC.set_Plano(stringwriter.ToString());
_admBs.PlanosCopiasSeguranca.Actualiza(newPC);
_admBs.PlanosCopiasSeguranca.ListaPlanos().Insere(newPC);
Console.WriteLine(" Plano de Copia Seguranca inserido com id: " + newPC.get_Id());
}
