public void InitTest()
{
UserController userController = new UserController();
TaskController taskController = new TaskController();
string username = "******";
string name = "Mock";
string surname = "User";
string password = "******";
User.ContactInformationAttribute contactInfo = new User.ContactInformationAttribute("*****@*****.**", "05398376436", "Rumelifeneri Mahallesi");
userController.AddNewUser(username, password, name, surname, contactInfo);
taskOwner = userController.ReturnUserWithGivenUsername(username);
string usernameForTasker = "Mock-User-2";
string nameForTasker = "Mock2";
string surnameForTasker = "User";
string passwordForTasker = "123";
User.ContactInformationAttribute contactInfoForTasker = new User.ContactInformationAttribute("*****@*****.**", "05398376436", "Rumelifeneri Mahallesi");
userController.AddNewUser(usernameForTasker, passwordForTasker, nameForTasker, surnameForTasker, contactInfoForTasker);
tasker = userController.ReturnUserWithGivenUsername(usernameForTasker);
AddNewAd newAdForm = new AddNewAd();
newAdForm.TaskOwnerUsername = username;
newAdForm.TitleField = "Mock Task 1";
newAdForm.DescriptionField = "Mock Test for Update ad controller";
newAdForm.LocationField = "Bursa";
newAdForm.AddressField = "Rumelifeneri";
newAdForm.PaymentAmountField = "20";
newAdForm.Category = "Mock";
newAdForm.Currency = "TL";
taskController.ProcessNewAdData(newAdForm);
taskOwner = userController.ReturnUserWithGivenUsername(username);
ad = taskController.ReturnTaskWithGivenTaskId(taskOwner.Ads[1]);
}
public int AddNewUser(string username, string password, string name, string surname, User.ContactInformationAttribute contactInfo)
{
_Connection.Open();
string queryString = $"INSERT INTO users (username, name, surname, email, phone, address, tasks, ads, rating, photo, password, ratingnumber, jobtypes)"
+ $"VALUES(\'{username}\',\'{name}\',\'{surname}\',\'{contactInfo.Email}\',\'{contactInfo.PhoneNumber}\',\'{contactInfo.Address}\'," + "\'{-1}\' , \'{-1}\'" + $", 5.0,\'-1\',\'{password}\', 1, ARRAY[\'-1\'])";
NpgsqlCommand command = new NpgsqlCommand(queryString, _Connection);
int numberOfRowsAffected = command.ExecuteNonQuery();
_Connection.Close();
return(numberOfRowsAffected);
}
