private void btnSave_Click(object sender, EventArgs e) { DbServerParameters dbServerParameters = new DbServerParameters(); dbServerParameters.AuthType = chckBoxDbServerLogInType.Checked; dbServerParameters.ServerName = txtBoxDbServerName.Text.ToString(); dbServerParameters.UserName = txtBoxDbServerUserName.Text.ToString(); dbServerParameters.Password = txtBoxDbServerPass.Text.ToString(); ////List<ListItem> selected = new List<ListItem>(); //foreach (var item in chckdLstBoxDbNamesOnDbServer.Items) // dbNameOnThisDbServer.Name = item.name; List <DbNameOnThisDbServer> dbNameOnThisDbServerList = new List <DbNameOnThisDbServer>(); foreach (var item in chckdLstBoxDbNamesOnDbServer.CheckedItems) { DbNameOnThisDbServer dbNameOnThisDbServer = new DbNameOnThisDbServer { Name = item.ToString(), IsSelected = true }; dbNameOnThisDbServerList.Add(dbNameOnThisDbServer); } dbServerParameters.DatabasesOnThisServer = dbNameOnThisDbServerList; using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { foreach (var uj in dbContext.UserJobs) { if (uj.name == _vM_Main_Form_DTO.SelectedJob_And_Details.selectedJob.name) { if (uj.DbServerParameters is null) { uj.DbServerParameters = dbServerParameters; //dbContext.SaveChanges(); } else { //uj.DbServerParameters = null; dbContext.DbServerParameters.Remove(uj.DbServerParameters); //uj.DbServerParameters = null; dbContext.SaveChanges(); uj.DbServerParameters = dbServerParameters; //dbContext.SaveChanges(); } } } dbContext.SaveChanges(); } string name = _vM_Main_Form_DTO.UserSqlBackup.AccountName.ToString(); string pass = _vM_Main_Form_DTO.UserSqlBackup.Password.ToString(); string jName = _vM_Main_Form_DTO.SelectedJob_And_Details.selectedJob.name; _vM_Main_Form_DTO.update_VM_with_accountName_pass(name, pass.decryption(), jName); this._mainFormSqlBackup.update_main_form_full_with_VM_Main_Form_DTO(); this._mainFormSqlBackup.Show(); this.Hide(); }
public List <UserJobs> UserJobs_GET_for_a_user(UserSqlBackup usr) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_jobs = dbContext.UserJobs.Where(x => x.UserSqlBackupId == usr.Id).ToList(); return(usr_jobs); } }
public void schedule_Delete_for_a_job(Schedule schedule) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { dbContext.Schedule.Remove(schedule); dbContext.SaveChanges(); } }
public UserSqlBackup UserSqlBackup_GET_from_name_and_pass_(string name, string pass) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr = dbContext.User.Where(x => x.AccountName == name && x.Password == pass.encryption()).FirstOrDefault(); return(usr); } }
public UserJobs UserJobs_GET_for_a_user_and_jobName(UserSqlBackup usr, string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_selected_job = dbContext.UserJobs.Where(x => x.UserSqlBackupId == usr.Id && x.name == jobName).FirstOrDefault(); return(usr_selected_job); } }
public void UserSqlBackup_CREATE_(UserSqlBackup usr) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { dbContext.User.Add(usr); dbContext.SaveChanges(); } }
public void UserJobs_REMOVE_for_a_user(UserSqlBackup _usr, UserJobs uj) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr = dbContext.User.Find(_usr.Id); usr.UserJobs.Add(uj); dbContext.SaveChanges(); } }
public void update_a_job_for_a_user(int userJobID, string uj_name) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserJobs usr_j = dbContext.UserJobs.Find(userJobID); usr_j.name = uj_name; dbContext.SaveChanges(); } }
public Schedule schedule_GET_for_job(string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_selected_job = dbContext.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); var schedule = dbContext.Schedule.Where(x => x.UserJobsId == usr_selected_job.Id).FirstOrDefault(); return(schedule); } }
public void delete_a_job_from_a_usr(string jName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserJobs usr_j = dbContext.UserJobs.Where(x => x.name == jName).FirstOrDefault(); dbContext.UserJobs.Remove(usr_j); dbContext.SaveChanges(); } }
public DbServerParameters DB_Server_Parameters_CREATE_for_job(DbServerParameters dbServerParameters, UserJobs usrJob) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { dbServerParameters.UserJobsId = usrJob.Id; dbContext.DbServerParameters.Add(dbServerParameters); dbContext.SaveChanges(); } return(dbServerParameters); }
public Schedule schedule_Create_for_a_job(Schedule schedule, UserJobs userJob) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { schedule.UserJobsId = userJob.Id; dbContext.Schedule.Add(schedule); dbContext.SaveChanges(); return(schedule); } }
public List <DbNameOnThisDbServer> dBNames_GET_for_job(string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_selected_job = dbContext.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); var jobDatabaseServerParameter = dbContext.DbServerParameters.Where(x => x.UserJobsId == usr_selected_job.Id).FirstOrDefault(); var dBNames = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == jobDatabaseServerParameter.Id).ToList(); return(dBNames); } }
public DbServerParameters DB_Server_Parameters_Remove_for_job(string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_selected_job = dbContext.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); var jobDatabaseServerParameter = dbContext.DbServerParameters.Where(x => x.UserJobsId == usr_selected_job.Id).FirstOrDefault(); return(jobDatabaseServerParameter); } }
public void create_a_job_for_a_user(int usr_ID, string uj_name) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserJobs uj = new UserJobs(); uj.name = uj_name; uj.UserSqlBackupId = usr_ID; dbContext.UserJobs.Add(uj); dbContext.SaveChanges(); } }
public void UserSqlBackup_DELETE(UserSqlBackup _usr) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr = dbContext.User.Find(_usr.Id); dbContext.User.Remove(usr); dbContext.SaveChanges(); } }
public void dBNames_Remove_for_job(List <DbNameOnThisDbServer> dbNames, string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr_selected_job = dbContext.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); var jobDatabaseServerParameter = dbContext.DbServerParameters.Where(x => x.UserJobsId == usr_selected_job.Id).FirstOrDefault(); foreach (var dbn in dbNames) { dbn.DbServerParametersId = jobDatabaseServerParameter.Id; dbContext.DbNameOnThisDbServer.Add(dbn); } dbContext.SaveChanges(); } }
public void update_VM_with_jobName(string jobName = "") { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { if (this.UserJobs.Count > 0) { this.SelectedJob_And_Details.selectedJob = this.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); if (!(this.SelectedJob_And_Details.selectedJob is null)) { this.SelectedJob_And_Details.DbServerParameters = dbContext.DbServerParameters.Where(x => x.UserJobsId == SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } this.SelectedJob_And_Details.Schedule = dbContext.Schedule.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Local = dbContext.Destination_Local.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Network = dbContext.Destination_Network.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Cloud = dbContext.Destination_Cloud.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); } } else { this.SelectedJob_And_Details.selectedJob = null; } } //if (!(this.SelectedJob_And_Details.selectedJob is null)) //{ // this.SelectedJob_And_Details.DbServerParameters = dbContext.DbServerParameters.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); // if (!(this.SelectedJob_And_Details.DbServerParameters is null)) // this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == this.SelectedJob_And_Details.DbServerParameters.Id).ToList<DbNameOnThisDbServer>(); // if (!(this.SelectedJob_And_Details.DbServerParameters is null)) // this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == this.SelectedJob_And_Details.DbServerParameters.Id).ToList<DbNameOnThisDbServer>(); // this.SelectedJob_And_Details.Schedule = dbContext.Schedule.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); // this.SelectedJob_And_Details.Destination_Local = dbContext.Destination_Local.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); // this.SelectedJob_And_Details.Destination_Network = dbContext.Destination_Network.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); // this.SelectedJob_And_Details.Destination_Cloud = dbContext.Destination_Cloud.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); //} }
public void delete_a_DbServerAndDbNames_from_a_job(string jobName) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserJobs usr_j = dbContext.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); DbServerParameters dbServerParameters = dbContext.DbServerParameters.Where(x => x.UserJobsId == usr_j.Id).FirstOrDefault(); ICollection <DbNameOnThisDbServer> dbNames = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == dbServerParameters.Id).ToList(); foreach (DbNameOnThisDbServer dbn in dbNames) { dbContext.DbNameOnThisDbServer.Remove(dbn); } dbContext.DbServerParameters.Remove(dbServerParameters); dbContext.SaveChanges(); } }
public void UserSqlBackup_update(UserSqlBackup _usr) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { var usr = dbContext.User.Find(_usr.Id); usr.Name = _usr.Name; usr.AccountName = _usr.AccountName; usr.Password = _usr.Password; usr.Lastname = _usr.Lastname; dbContext.SaveChanges(); } }
private void button1_Click(object sender, EventArgs e) { //utility utility = new utility(); UserSqlBackup UserSqlBackup = new UserSqlBackup(); UserSqlBackup.Name = txtBoxName.Text.ToString(); UserSqlBackup.Lastname = txtBoxLastName.Text.ToString(); UserSqlBackup.AccountName = txtBoxNickName.Text.ToString(); UserSqlBackup.Password = utility.encryption(txtBoxUserPass.Text.ToString()); //UserSqlBackup.CompanyName = txtCompanyName.Text.ToString(); using (var dbContext = new DbContextSqlBackup()) { dbContext.User.Add(UserSqlBackup); dbContext.SaveChanges(); } MessageBox.Show(" kayıt yapıldı ..."); }
public void update_VM_with_schedule_with_jobName(Schedule schedule, string jN) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserJobs uj = new UserJobs(); uj = dbContext.UserJobs.Where(x => x.name == jN).FirstOrDefault(); var sc = dbContext.Schedule.Where(x => x.UserJobsId == uj.Id).FirstOrDefault(); if (sc == null) { schedule.UserJobsId = uj.Id; dbContext.Schedule.Add(schedule); } else { uj.Schedule = sc; } dbContext.SaveChanges(); } }
public Schedule schedule_Update_for_job(Schedule schedule, UserJobs userJob) { using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { Schedule _schedule = dbContext.Schedule.Where(x => x.UserJobsId == userJob.Id).FirstOrDefault(); _schedule.IsMonday = schedule.IsMonday; _schedule.IsThursday = schedule.IsThursday; _schedule.IsWednesday = schedule.IsWednesday; _schedule.IsTuesday = schedule.IsTuesday; _schedule.IsFriday = schedule.IsFriday; _schedule.IsSaturday = schedule.IsSaturday; _schedule.IsSunday = schedule.IsSunday; _schedule.howmanyBackup = schedule.howmanyBackup; _schedule.interval = schedule.interval; _schedule.StartDateTime = schedule.StartDateTime; dbContext.Schedule.Update(_schedule); dbContext.SaveChanges(); return(_schedule); } }
public void update_VM_with_accountName_pass(string name = "", string pass = "", string jobName = "") { //try //{ using (DbContextSqlBackup dbContext = new DbContextSqlBackup()) { UserSqlBackup = dbContext.User.Where(x => x.AccountName == name && x.Password == pass.encryption()).FirstOrDefault(); if (!(UserSqlBackup is null)) { UserJobs = dbContext.UserJobs.Where(x => x.UserSqlBackupId == UserSqlBackup.Id).ToList <UserJobs>(); } if (jobName == "") { if (this.UserJobs.Count > 0) { this.SelectedJob_And_Details.selectedJob = UserJobs[0]; } else { this.SelectedJob_And_Details.selectedJob = null; } } else { if (this.UserJobs.Count > 0) { this.SelectedJob_And_Details.selectedJob = this.UserJobs.Where(x => x.name == jobName).FirstOrDefault(); if (!(this.SelectedJob_And_Details.selectedJob is null)) { this.SelectedJob_And_Details.DbServerParameters = dbContext.DbServerParameters.Where(x => x.UserJobsId == SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } this.SelectedJob_And_Details.Schedule = dbContext.Schedule.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Local = dbContext.Destination_Local.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Network = dbContext.Destination_Network.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Cloud = dbContext.Destination_Cloud.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); } } else { this.SelectedJob_And_Details.selectedJob = null; } } if (!(this.SelectedJob_And_Details.selectedJob is null)) { this.SelectedJob_And_Details.DbServerParameters = dbContext.DbServerParameters.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == this.SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } if (!(this.SelectedJob_And_Details.DbServerParameters is null)) { this.SelectedJob_And_Details.dbNamesOnThisDbServers = dbContext.DbNameOnThisDbServer.Where(x => x.DbServerParametersId == this.SelectedJob_And_Details.DbServerParameters.Id).ToList <DbNameOnThisDbServer>(); } this.SelectedJob_And_Details.Schedule = dbContext.Schedule.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Local = dbContext.Destination_Local.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Network = dbContext.Destination_Network.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); this.SelectedJob_And_Details.Destination_Cloud = dbContext.Destination_Cloud.Where(x => x.UserJobsId == this.SelectedJob_And_Details.selectedJob.Id).FirstOrDefault(); } } //} //catch //{ //} //return vM_Main_Form_DTO; }