/// <summary> /// Edits a new user depending if the uderID already exists /// </summary> /// <param name="user">the user that is being added</param> /// <param name="sector">the sector that is being added</param> /// <returns>a new user</returns> public tblUser AddUser(tblUser user, tblSector sector) { InputCalculator iv = new InputCalculator(); try { using (WorkerContext context = new WorkerContext()) { if (user.UserID == 0) { user.DateOfBirth = iv.CountDateOfBirth(user.JMBG); tblUser newUser = new tblUser(); newUser.FirstName = user.FirstName; newUser.LastName = user.LastName; newUser.JMBG = user.JMBG; newUser.IDCard = user.IDCard; newUser.DateOfBirth = user.DateOfBirth; newUser.Gender = user.Gender; newUser.PhoneNumber = user.PhoneNumber; newUser.SectorID = sector.SectorID; newUser.LocationID = user.LocationID; newUser.MenagerID = user.MenagerID; context.tblUsers.Add(newUser); context.SaveChanges(); user.UserID = newUser.UserID; return(user); } else { tblUser usersToEdit = (from ss in context.tblUsers where ss.UserID == user.UserID select ss).First(); // Get the date of birth user.DateOfBirth = iv.CountDateOfBirth(user.JMBG); usersToEdit.FirstName = user.FirstName; usersToEdit.LastName = user.LastName; usersToEdit.JMBG = user.JMBG; usersToEdit.IDCard = user.IDCard; usersToEdit.DateOfBirth = user.DateOfBirth; usersToEdit.Gender = user.Gender; usersToEdit.PhoneNumber = user.PhoneNumber; usersToEdit.SectorID = sector.SectorID; usersToEdit.LocationID = user.LocationID; usersToEdit.MenagerID = user.MenagerID; usersToEdit.UserID = user.UserID; context.SaveChanges(); return(user); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Calcualtes the birth date and places it in the textbox /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TextBox_TextChanged(object sender, EventArgs e) { InputCalculator iv = new InputCalculator(); string text = ""; if (txtJMBG.Text.Length >= 7) { text = iv.CountDateOfBirth(txtJMBG.Text).ToString("dd.MM.yyy."); } else { text = ""; } txtDateOfBirth.Text = text; }
/// <summary> /// Creates or edits a manager /// </summary> /// <param name="manager">the manager that is esing added</param> /// <returns>a new or edited manager</returns> public vwManager AddManager(vwManager manager) { InputCalculator iv = new InputCalculator(); try { using (ReportDBEntities context = new ReportDBEntities()) { if (manager.UserID == 0) { manager.DateOfBirth = iv.CountDateOfBirth(manager.JMBG); tblUser newManager = new tblUser { FirstName = manager.FirstName, LastName = manager.LastName, JMBG = manager.JMBG, DateOfBirth = manager.DateOfBirth, BankAccount = manager.BankAccount, Email = manager.Email, Position = manager.Position, Salary = manager.Salary, Username = manager.Username, UserPassword = manager.UserPassword, Sector = manager.Sector, Access = manager.Access }; context.tblUsers.Add(newManager); context.SaveChanges(); manager.UserID = newManager.UserID; return(manager); } else { tblUser managerToEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First(); // Get the date of birth manager.DateOfBirth = iv.CountDateOfBirth(manager.JMBG); managerToEdit.FirstName = manager.FirstName; managerToEdit.LastName = manager.LastName; managerToEdit.JMBG = manager.JMBG; managerToEdit.DateOfBirth = manager.DateOfBirth; managerToEdit.BankAccount = manager.BankAccount; managerToEdit.Email = manager.Email; managerToEdit.Salary = manager.Salary; managerToEdit.Username = manager.Username; managerToEdit.Position = manager.Position; managerToEdit.UserPassword = manager.UserPassword; managerToEdit.Sector = manager.Sector; managerToEdit.Access = manager.Access; managerToEdit.UserID = manager.UserID; tblUser managerEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First(); context.SaveChanges(); return(manager); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Creates or edits a worker /// </summary> /// <param name="worker">the worker that is esing added</param> /// <returns>a new or edited worker</returns> public vwUser AddWorker(vwUser worker) { InputCalculator iv = new InputCalculator(); try { using (ReportDBEntities context = new ReportDBEntities()) { if (worker.UserID == 0) { worker.DateOfBirth = iv.CountDateOfBirth(worker.JMBG); tblUser newWorker = new tblUser { FirstName = worker.FirstName, LastName = worker.LastName, JMBG = worker.JMBG, DateOfBirth = worker.DateOfBirth, BankAccount = worker.BankAccount, Email = worker.Email, Position = worker.Position, Salary = worker.Salary, Username = worker.Username, UserPassword = worker.UserPassword }; context.tblUsers.Add(newWorker); context.SaveChanges(); worker.UserID = newWorker.UserID; return(worker); } else { tblUser workerToEdit = (from ss in context.tblUsers where ss.UserID == worker.UserID select ss).First(); // Get the date of birth worker.DateOfBirth = iv.CountDateOfBirth(worker.JMBG); workerToEdit.FirstName = worker.FirstName; workerToEdit.LastName = worker.LastName; workerToEdit.JMBG = worker.JMBG; workerToEdit.DateOfBirth = worker.DateOfBirth; workerToEdit.BankAccount = worker.BankAccount; workerToEdit.Email = worker.Email; workerToEdit.Salary = worker.Salary; workerToEdit.Username = worker.Username; workerToEdit.Position = worker.Position; workerToEdit.UserPassword = worker.UserPassword; workerToEdit.UserID = worker.UserID; tblUser workerEdit = (from ss in context.tblUsers where ss.UserID == worker.UserID select ss).First(); context.SaveChanges(); return(worker); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }