public List <MealTypeDTO> GetAll()
{
List <MealTypeDTO> mealTypes;
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("select * from meal_type", connection))
{
SqlDataReader reader = command.ExecuteReader();
mealTypes = new List <MealTypeDTO>();
while (reader.Read())
{
MealTypeDTO client = new MealTypeDTO
{
Id = (int)reader["id"],
Name = (string)reader["name"],
};
mealTypes.Add(client);
}
}
return(mealTypes);
}
}
public MealTypeDTO getById(int Id)
{
MealTypeDTO mealTypeDTO;
string query =
"SELECT * FROM meal_type gt WHERE gt.id=@id ";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", Id);
SqlDataReader reader = command.ExecuteReader();
mealTypeDTO = new MealTypeDTO();
while (reader.Read())
{
MealTypeDTO newMealTypeDTO = new MealTypeDTO()
{
Id = (int)reader["id"],
Name = (string)reader["name"]
};
mealTypeDTO = newMealTypeDTO;
}
}
connection.Close();
}
return(mealTypeDTO);
}
public void UpdateMealType_Should_Return_Valid_Data()
{
//Arrange
var mock = new Mock <IMealTypeRepository>();
var myMealType = new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
};
mock.Setup(x => x.Update(myMealType)).Returns(
new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
}
);
MealTypeUC target = new MealTypeUC(mock.Object);
//Act
var result = target.UpdateMealType(new MealTypeBTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoBTO()
});
//Assert
mock.Verify(u => u.Update(It.IsAny <MealTypeDTO>()), Times.Once());
}
public void UpdateMealType_Should_Return_Null_If_No_Result_Found_In_Db()
{
//Arrange
var mock = new Mock <IMealTypeRepository>();
var myMealType = new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
};
mock.Setup(x => x.Update(myMealType));
MealTypeUC target = new MealTypeUC(mock.Object);
//Act
var result = target.UpdateMealType(new MealTypeBTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoBTO()
});
//Assert
Assert.IsNull(result);
}
public void CreateMealType_Should_Return_Null_If_Dto_Is_Null()
{
//Arrange
var mock = new Mock <IMealTypeRepository>();
var myMealType = new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
};
mock.Setup(x => x.Create(myMealType)).Returns(
new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
}
);
MealTypeUC target = new MealTypeUC(mock.Object);
//Act
var result = target.AddMealType(null);
//Assert
Assert.IsNull(result);
}
public void GetMealTypeById_Should_Return_Valid_Data()
{
//Arrange
var mock = new Mock <IMealTypeRepository>();
var myMealType = new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
};
mock.Setup(x => x.GetById(1)).Returns(
new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
}
);
MealTypeUC target = new MealTypeUC(mock.Object);
//Act
var result = target.GetMealTypeById(1);
//Assert
Assert.AreEqual(result.Id, 1);
Assert.AreEqual(result.Name, "Starter");
}
public MealTypeDTO Create(MealTypeDTO obj)
{
var mealType = obj.DtoToMealType();
contextDB.Restaurants.First(x => x.Id == obj.Restaurant.Id);
contextDB.MealTypes.Add(mealType);
contextDB.SaveChanges();
return(mealType.MealTypeToDTO());
}
public MealTypeBTO AddMealType(MealTypeBTO mealTypeBto)
{
MealTypeDTO mealType = new MealTypeDTO();
if (mealTypeBto != null)
{
mealType = mealTypeRepository.Create(mealTypeBto.BTOToMealTypeDomain().MealTypeDomainToDTO());
return(mealType.DTOToMealTypeDomain().MealTypeDomainToBTO());
}
return(null);
}
public MealTypeBTO UpdateMealType(MealTypeBTO mealTypeBto)
{
MealTypeDTO mealType = new MealTypeDTO();
if (mealTypeBto != null)
{
mealType = mealTypeRepository.Update(mealTypeBto.BTOToMealTypeDomain().MealTypeDomainToDTO());
return(mealType?.DTOToMealTypeDomain().MealTypeDomainToBTO() ?? null);
}
return(null);
}
public MealTypeDTO Update(MealTypeDTO obj)
{
var mealType = contextDB.MealTypes.FirstOrDefault(x => x.Id == obj.Id);
if (mealType == null)
{
return(null);
}
else
{
mealType.Name = obj.Name;
mealType.Restaurant = obj.Restaurant.ToRestaurant();
contextDB.SaveChanges();
return(mealType.MealTypeToDTO());
}
}
public static MealTypeDomain DTOToMealTypeDomain(this MealTypeDTO mealTypeDto)
{
if (mealTypeDto != null)
{
return new MealTypeDomain
{
Id = mealTypeDto.Id,
Name = mealTypeDto.Name,
RestaurantId = mealTypeDto.RestaurantId,
Restaurant = mealTypeDto.Restaurant.DTOToDomain(),
Meals = mealTypeDto.Meals?.Select(x => x.DTOToMealDomain()).ToList() ?? null
}
}
;
else
{
return(null);
}
}
public static MealType DtoToMealType(this MealTypeDTO dto)
{
if (dto != null)
{
return new MealType
{
Id = dto.Id,
Name = dto.Name,
RestaurantId = dto.RestaurantId,
Restaurant = dto.Restaurant.ToRestaurant(),
Meals = dto.Meals?.Select(x => x.DtoToMeal()).ToList() ?? null
}
}
;
else
{
return(null);
}
}
public void DeleteMealType_Should_Work()
{
//Arrange
var mock = new Mock <IMealTypeRepository>();
var myMealType = new MealTypeDTO
{
Id = 1,
Name = "Starter",
Restaurant = new RestoDTO()
};
mock.Setup(x => x.Delete(1));
MealTypeUC target = new MealTypeUC(mock.Object);
//Act
target.DeleteMealType(1);
//Assert
mock.Verify(u => u.Delete(It.IsAny <int>()), Times.Once());
}
