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