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(); }