public bool Post(Ansat ansat)
{
bool status = false;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand(Insert, connection);
command.Parameters.AddWithValue("@Initialer", ansat.Initial);
command.Parameters.AddWithValue("@Navn", ansat.Navn);
command.Parameters.AddWithValue("@ID", ansat.Id);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
status = true;
}
connection.Close();
return(status);
}
/// <summary>
/// Formålet er at gemme en ansat i databasen
/// </summary>
/// <param name="ansatToPost"> Ansat der skal gemmes i databasen</param>
/// <returns>Returnerer en bool</returns>
public async Task <bool> PostAsync(Ansat ansatToPost)
{
bool status = false;
using (HttpClient client = new HttpClient())
{
string jsonString = JsonConvert.SerializeObject(ansatToPost);
StringContent content = new StringContent(jsonString, Encoding.UTF8, "application/json");
HttpResponseMessage response = await client.PostAsync($"{URI}Ansats", content);
if (response.IsSuccessStatusCode)
{
string jsonStringRead = response.Content.ReadAsStringAsync().Result;
status = JsonConvert.DeserializeObject <bool>(jsonStringRead);
}
else
{
status = false;
}
}
return(status);
}
private Ansat ReadAnsat(SqlDataReader reader)
{
Ansat tempAnsat = new Ansat();
tempAnsat.Initial = reader.GetString(0);
tempAnsat.Navn = reader.GetString(1);
tempAnsat.Id = reader.GetInt32(2);
return(tempAnsat);
}
public Ansat GetOne(string initialer)
{
Ansat tempAnsat = new Ansat();
using (HttpClient client = new HttpClient())
{
Task <string> task = client.GetStringAsync($"{URI}Ansats/{initialer}");
string jsonString = task.Result;
tempAnsat = JsonConvert.DeserializeObject <Ansat>(jsonString);
}
return(tempAnsat);
}
public void Get_AnExistingUser_True()
{
//Arrange
_manager.Post(_trialAnsat);
//Act
Ansat tempAnsat = _manager.Get(_trialAnsat.Initial);
//Assert
Assert.AreEqual(_trialAnsat.Initial, tempAnsat.Initial);
Assert.AreEqual(_trialAnsat.Navn, tempAnsat.Navn);
Assert.AreEqual(_trialAnsat.Id, tempAnsat.Id);
_manager.Delete(_trialAnsat.Initial);
}
public Ansat Get(string initialer)
{
Ansat tempAnsat = new Ansat();
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand(GetOne, connection);
command.Parameters.AddWithValue("@Initialer", initialer);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
tempAnsat = ReadAnsat(reader);
}
connection.Close();
return(tempAnsat);
}
public List <Ansat> Get()
{
List <Ansat> tempList = new List <Ansat>();
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand(GetAll, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Ansat tempAnsat = ReadAnsat(reader);
tempList.Add(tempAnsat);
}
connection.Close();
return(tempList);
}
public bool Put(string initialer, [FromBody]Ansat ansat)
{
return _manager.Put(initialer, ansat);
}
// POST: api/Ansats
public bool Post([FromBody]Ansat ansat)
{
return _manager.Post(ansat);
}
public void TestInitialize()
{
_manager = new AnsatManager();
_trialAnsat = new Ansat("ABBB", "Anders Bunde Bande Bunds", 25);
}
/// <summary>
/// Hent ansatte og send en notification til vores messenger om at ansatte er hentet
/// </summary>
private void LoadAnsatteMetode()
{
ansatte = Ansat.GetEksempelAnsatte();
this.RaisePropertyChanged(() => this.AnsatteList);
Messenger.Default.Send <NotificationMessage>(new NotificationMessage("Ansatte hentet."));
}
