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 Selected_Job_And_Details()
{
selectedJob = new UserJobs();
DbServerParameters = new DbServerParameters();
dbNamesOnThisDbServers = new List <DbNameOnThisDbServer>();
Schedule = new Schedule();
Destination_Local = new Destination_Local();
Destination_Network = new Destination_Network();
Destination_Cloud = new Destination_Cloud();
}
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 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();
}
}
