/// <summary> /// Adding Contractor details into Contractors Table /// </summary> /// <param name="usertables"></param> public void AddUser(ContractorRegistrationViewModel usertables) { try { // AspNetUserRoles asp = new AspNetUserRoles { }; UserTables njp = new UserTables { IsActive = true, CreatedBy = usertables.ContractorName }; usertableRepository.Add(njp); unitOfWork.Commit(); Contractors cts = new Contractors { UserTableId = usertables.UserTableId, StateId = usertables.StateId, CityId = usertables.CityId, ContractorName = usertables.ContractorName, ContractorAge = usertables.ContractorAge, ContractorPhone = usertables.ContractorPhone, IsActive = true, CreatedBy = usertables.CreatedBy }; contractorRepository.Add(cts); unitOfWork.Commit(); } catch (Exception) { throw; } }
public TableViewModel() { _ServiceProxy = new DataAccess(); UserCredentials = new User(); AllUserTables = new ObservableCollection <UserTables>(); SelectedUserTable = new UserTables(); GetUserCredentials(); SignOutCommand = new RelayCommand(ExecuteSignOut); DisplayConfigurationCommand = new RelayCommand(ExecuteDisplayCOnfiguration); }
public UnitOfWork() { _database = new Entities(); User = new UserTables(_database.Users); SecurityQuestion = new SecurityQuestionTables(_database.SecurityQuestions); Role = new RoleTable(_database.Roles); OrganisationTable = new OrganisationTable(_database.OrganisationDetails); BranchTable = new BranchTable(_database.BrancheDetails); BankTable = new BankTable(_database.BankDetails); EmployeeTable = new EmployeeTable(_database.Employees); EmployeeLocationTable = new EmployeeLocationTable(_database.EmployeeLocations); CustomerTable = new CustomerTable(_database.Customers); AccountTable = new AccountTable(_database.Accounts); AccountTypeTable = new AccountTypeTable(_database.AccountTypes); AccessLevelTable = new AccountAccessLevelTable(_database.AccessLevels); UserAccountAccessTable = new UserAccountAccessTable(_database.UserAccountAccesses); AccoutTransactionTable = new AccoutTransactionTable(_database.Transactions); }
//метод для создания новоого юзера.то есть должно быть добавелние в бд public string NewUser(string lastName, string firstName, DateTime dob, string password, string accountNumber, string groupName, string email) { //bike bool passValid = pass_regex.IsMatch(password); bool accountValid = account_regex.IsMatch(accountNumber); bool lastNameValid = name_regex.IsMatch(lastName); bool firstNameValid = name_regex.IsMatch(firstName); //на мыло @ bool emailValid = (email.Contains('@')) ? true : false; if (!passValid || !accountValid || !lastNameValid || !firstNameValid || !emailValid) { return("{\"ok\":false}"); } else { UserTables ut = new UserTables(); try { ut.AccountNumber = accountNumber; ut.Dob = dob; ut.Email = email; ut.FirstName = firstName; ut.LastName = lastName; ut.Password = password; ut.GroupName = groupName; } catch (DbUpdateException ex) { Console.WriteLine(ex.StackTrace); return("{\"ok\":false}"); } //вот тут мне не нравится проверочка. тип если в бд уже такой есть, то не писать снова. //но ведь др может совпадать. хотя. он же проверяет объект с объектом. одно поле не сошлось значит не тру if (!Startup.db.UserTables.All(it => it.Equals(ut))) { //try Startup.db.UserTables.Add(ut); Startup.db.SaveChanges(); } return("{\"ok\":true}"); } }
//получение джейсона пользователя public string getUser(string accountNumber, string password) { tempUser = new UserTables(); tempUser = Startup.db.UserTables.Where(t => t.AccountNumber == accountNumber && t.Password == password).First(); return(JsonConvert.SerializeObject(tempUser)); }