private void Form3_Load(object sender, EventArgs e) { int lenght = connectform2.getDBBackedUp.Length; StringBuilder databases = new StringBuilder(); for(int i = 0; i < lenght; i++) { if (i == lenght - 1) { if ((i % 2 == 0) && (i != 0)) { flag = true; databases.Append( "\n" + " " + connectform2.getDBBackedUp[i]); } else { if (flag) { databases.Append(connectform2.getDBBackedUp[i]); } else { databases.Append(connectform2.getDBBackedUp[i]); } } } else { if ((i % 2 == 0) && (i != 0)) { flag = true; databases.Append( "\n" + " " + connectform2.getDBBackedUp[i] +","); } else { if (flag) { databases.Append(connectform2.getDBBackedUp[i]); } else { databases.Append(connectform2.getDBBackedUp[i]+","); } } } } if (connectform2.getConnection) { label1.Text = "Hostname: " + connectform2.getHostname + "\n" + "Username: "******"\n" + "DataBase(s): "+Convert.ToString(databases) + "\n" + "Day: " + connectform2.getDate + "\n" + "Time: " + connectform2.getTime+"\n"+ "---------------------------------------------------------------------"; } else { label1.Text = "Hostname: " + connectform2.getHostname2 + "\n" + "Username: "******"\n" + "DataBase(s): " + Convert.ToString(databases) + "\n" + "Day: "+connectform2.getDate + "\n" + "Time: " + connectform2.getTime + "\n" + "---------------------------------------------------------------------"; } if (connectform2.getConnection) { savelogfile = new Save(label1.Text); savelogfile.logFile(logfile); }else if (connectform2.getConnection2) { savelogfile = new Save(label1.Text); savelogfile.logFile(logfile); } }
//gia to Save otan to remember me einai pathmeno private void SaveCheckBox_CheckedChanged(object sender, EventArgs e) { if (SaveCheckBox.Checked) { Save save = new Save(hostnametextbox.Text, porttextbox.Text, usernametextbox.Text, passwordtextbox.Text); save.SaveME(); if (save.Exist()) { savedlabel.Text = "Already Exist"; wheresaved.Text = save.PathToShow(); } else if (save.Saved()) { savedlabel.Text = "Saved To ->"; wheresaved.Text = save.PathToShow(); } else SaveCheckBox.Checked = false; } }
private void Runbutton_Click(object sender, EventArgs e) { if ((((this.connectForm.getConnection) || (this.connectForm.getConnection2)))) { string path2 = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)+"\\CurrentFile.txt"; string path =(Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.FullName +@"\sqlBackup\ScheduleFile\"); StreamWriter write = new StreamWriter(path2); write.Write(path); write.Close(); try { int selectedDbNum = DatabasesCheckedListBox.CheckedItems.Count; //array with selected databases number length, for store all selected databases string[] dbForBackup = new string[selectedDbNum]; //get names of selected databases int i = 0; foreach (object itemChecked in DatabasesCheckedListBox.CheckedItems) { dbForBackup[i] = itemChecked.ToString(); i++; } if (SchedulecheckBox.Checked) { TimeSpan time = ScheduleTime.Value.TimeOfDay; if (this.connectForm.getConnection) { saveschedulefile = new Save(time, this.connectForm.getHostname, this.connectForm.getPort, connectForm.getUsername, connectForm.getPassword, this.FTPHost, this.FTPusername, this.FTPpasswd, emailtextBox.Text, dbForBackup); saveschedulefile.ScheduleFile(schedulefile); ErrorScheduleLabel.Text = "Schedule completed sucessfully"; } else if (this.connectForm.getConnection2) { saveschedulefile = new Save(time, this.connectForm.getHostname2, this.connectForm.getPort2, this.connectForm.getUsername2, this.connectForm.getPassword2, this.FTPHost, this.FTPusername, this.FTPpasswd, emailtextBox.Text, dbForBackup); saveschedulefile.ScheduleFile(schedulefile); ErrorScheduleLabel.Text = "Schedule completed sucessfully"; } } } catch (Exception x) { ErrorScheduleLabel.Text = "Choose a database first"; } try { //MessageBox.Show(Convert.ToString(IsUserAdministrator())); TimeSpan time = ScheduleTime.Value.TimeOfDay; using (TaskService ts = new TaskService()) { TaskDefinition td = ts.NewTask(); //δημηουργια ονοματος και description για το schedule td.RegistrationInfo.Description = "This task will backup the database that the user has chosen "; td.Principal.DisplayName = "sqlBckup" + counter; td.Principal.RunLevel = TaskRunLevel.Highest; //δημιουργια triiger ο οποίος θα τρέχει κάθε μέρα DailyTrigger dt = new DailyTrigger(); dt.StartBoundary = DateTime.Today + TimeSpan.FromHours(Convert.ToDouble(time.Hours)) + TimeSpan.FromMinutes(Convert.ToDouble(time.Minutes)); dt.DaysInterval = 1; dt.Enabled = true; td.Triggers.Add(dt); //προσθεση ρυθμiσeων για το πως θα τρέχει το schedule td.Settings.MultipleInstances = TaskInstancesPolicy.Parallel; td.Settings.ExecutionTimeLimit = TimeSpan.FromHours(23); td.Settings.DisallowStartIfOnBatteries = false; td.Settings.WakeToRun = true; td.Settings.Hidden = true; td.Settings.StartWhenAvailable = true; td.Settings.Priority = ProcessPriorityClass.High; //προσθηκη exe action που δείχνει πιο exe θα τρεχει οταν ερθει η ωρα του schedule td.Actions.Add(new ExecAction(schedulerexe, null, null)); //ExecAction et = new ExecAction(schedulerexe, null, null); //td.Actions.Add(et); //δημιουργία του schedule ts.RootFolder.RegisterTaskDefinition("sqlBackup" + counter, td); counter++; ErrorScheduleLabel.Text = "Schedule sucessfull created"; } } catch (Exception exk) { MessageBox.Show(exk.Source); MessageBox.Show(exk.Message); MessageBox.Show(exk.StackTrace); } } }
private void Form3_Load(object sender, EventArgs e) { int lenght = connectform2.getDBBackedUp.Length; StringBuilder databases = new StringBuilder(); for (int i = 0; i < lenght; i++) { if (i == lenght - 1) { if ((i % 2 == 0) && (i != 0)) { flag = true; databases.Append("\n" + " " + connectform2.getDBBackedUp[i]); } else { if (flag) { databases.Append(connectform2.getDBBackedUp[i]); } else { databases.Append(connectform2.getDBBackedUp[i]); } } } else { if ((i % 2 == 0) && (i != 0)) { flag = true; databases.Append("\n" + " " + connectform2.getDBBackedUp[i] + ","); } else { if (flag) { databases.Append(connectform2.getDBBackedUp[i]); } else { databases.Append(connectform2.getDBBackedUp[i] + ","); } } } } if (connectform2.getConnection) { label1.Text = "Hostname: " + connectform2.getHostname + "\n" + "Username: "******"\n" + "DataBase(s): " + Convert.ToString(databases) + "\n" + "Day: " + connectform2.getDate + "\n" + "Time: " + connectform2.getTime + "\n" + "---------------------------------------------------------------------"; } else { label1.Text = "Hostname: " + connectform2.getHostname2 + "\n" + "Username: "******"\n" + "DataBase(s): " + Convert.ToString(databases) + "\n" + "Day: " + connectform2.getDate + "\n" + "Time: " + connectform2.getTime + "\n" + "---------------------------------------------------------------------"; } if (connectform2.getConnection) { savelogfile = new Save(label1.Text); savelogfile.logFile(logfile); } else if (connectform2.getConnection2) { savelogfile = new Save(label1.Text); savelogfile.logFile(logfile); } }