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 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 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 UserSqlBackup_DELETE(UserSqlBackup _usr)
{
using (DbContextSqlBackup dbContext = new DbContextSqlBackup())
{
var usr = dbContext.User.Find(_usr.Id);
dbContext.User.Remove(usr);
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 VM_Main_Form_DTO()
{
UserSqlBackup = new UserSqlBackup();
UserJobs = new List <UserJobs>();
SelectedJob_And_Details = new Selected_Job_And_Details();
}
