public static List <CategoryDisease> GetAll()
{
List <CategoryDisease> AllCategoryDisease = new List <CategoryDisease> {
};
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM categories_diseases;", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int id = rdr.GetInt32(0);
string name = rdr.GetString(1);
CategoryDisease newCategoryDisease = new CategoryDisease(name, id);
AllCategoryDisease.Add(newCategoryDisease);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(AllCategoryDisease);
}
public static CategoryDisease Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM categories_diseases WHERE id = @id;", conn);
SqlParameter IdPara = new SqlParameter("@id", id.ToString());
cmd.Parameters.Add(IdPara);
SqlDataReader rdr = cmd.ExecuteReader();
int foundid = 0;
string name = null;
while (rdr.Read())
{
foundid = rdr.GetInt32(0);
name = rdr.GetString(1);
}
CategoryDisease foundCategoryDisease = new CategoryDisease(name, foundid);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundCategoryDisease);
}
public void Test_CategoryDiseaseEmptyAtFirst()
{
//Arrange, Act
int result = CategoryDisease.GetAll().Count;
//Assert
Assert.Equal(0, result);
}
public void Test_Find_FindsCategoryDiseaseInDatabase()
{
//Arrange
CategoryDisease testCategoryDisease = new CategoryDisease("flu");
testCategoryDisease.Save();
//Act
CategoryDisease foundCategoryDisease = CategoryDisease.Find(testCategoryDisease.GetId());
//Assert
Assert.Equal(testCategoryDisease, foundCategoryDisease);
}
public override bool Equals(System.Object otherCategoryDisease)
{
if (!(otherCategoryDisease is CategoryDisease))
{
return(false);
}
else
{
CategoryDisease newCategoryDisease = (CategoryDisease)otherCategoryDisease;
bool idEquality = (this.GetId() == newCategoryDisease.GetId());
bool nameEquality = (this.GetName() == newCategoryDisease.GetName());
return(idEquality && nameEquality);
}
}
public void Test_Update_UpdatesCategoryDiseaseInDatabase()
{
//Arrange
string name = "physical injuries";
CategoryDisease testCategoryDisease = new CategoryDisease(name);
testCategoryDisease.Save();
string newName = "cancer";
//Act
testCategoryDisease.Update("cancer");
string result = testCategoryDisease.GetName();
//Assert
Assert.Equal(newName, result);
}
public void Test_Save_SaveCategoryDiseaseToDatabase()
{
//Arrange
CategoryDisease testCategoryDisease = new CategoryDisease("flu");
testCategoryDisease.Save();
//Act
List <CategoryDisease> result = CategoryDisease.GetAll();
List <CategoryDisease> testList = new List <CategoryDisease> {
testCategoryDisease
};
//Assert
Assert.Equal(testList, result);
}
public void Test_GetDisease_RetrieveAllDiseaseWithinCategoryDisease()
{
//Arrange
CategoryDisease testCategoryDisease = new CategoryDisease("flu");
testCategoryDisease.Save();
Disease firstDisease = new Disease("cold", "running nose", "image1", testCategoryDisease.GetId());
firstDisease.Save();
Disease secondDisease = new Disease("fever", "hot", "image2", testCategoryDisease.GetId());
secondDisease.Save();
//Act
List <Disease> testDiseaseList = new List <Disease> {
firstDisease, secondDisease
};
List <Disease> resultDiseaseList = testCategoryDisease.GetDisease();
//Assert
Assert.Equal(testDiseaseList, resultDiseaseList);
}
public void Test_Delete_DeleteCategoryDiseaseFromDatabase()
{
//Arrange
string name1 = "flu";
CategoryDisease testCategoryDisease1 = new CategoryDisease(name1);
testCategoryDisease1.Save();
string name2 = "cancer";
CategoryDisease testCategoryDisease2 = new CategoryDisease(name2);
testCategoryDisease2.Save();
Disease Disease1 = new Disease("cold", "running nose", "image1", testCategoryDisease1.GetId());
Disease1.Save();
Disease Disease2 = new Disease("fever", "hot", "image2", testCategoryDisease2.GetId());
Disease2.Save();
//Act
testCategoryDisease1.Delete();
List <CategoryDisease> resultCategoryDisease = CategoryDisease.GetAll();
List <CategoryDisease> testCategoryDisease = new List <CategoryDisease> {
testCategoryDisease2
};
List <Disease> resultDisease = Disease.GetAll();
List <Disease> DiseaseList = new List <Disease> {
Disease2
};
//Assert
Assert.Equal(testCategoryDisease, resultCategoryDisease);
Assert.Equal(DiseaseList, resultDisease);
}
public void Dispose()
{
CategoryDisease.DeleteAll();
Remedy.DeleteAll();
Disease.DeleteAll();
}
public HomeModule()
{
Get["/"] = _ => {
return(View["index.cshtml"]);
};
Get["/ailments"] = _ => {
List <Disease> AllAilments = Disease.GetAll();
return(View["ailments.cshtml", AllAilments]);
};
Get["/remedies"] = _ => {
List <Remedy> AllRemedies = Remedy.GetAll();
return(View["remedies.cshtml", AllRemedies]);
};
Get["/admin"] = _ => {
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Post["/admin/remedy"] = _ => {
string name = Request.Form["remedy-name"];
string description = Request.Form["remedy-description"];
string side_effect = Request.Form["remedy-side-effect"];
string image = Request.Form["remedy-image"];
int category_id = int.Parse(Request.Form["remedy-category-id"]);
Remedy newRemedy = new Remedy(name, description, side_effect, image, category_id);
Console.WriteLine(newRemedy.GetImage());
newRemedy.Save();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Post["/admin/disease"] = _ => {
string name = Request.Form["disease-name"];
string symptom = Request.Form["disease-symptom"];
string image = Request.Form["disease-image"];
int category_id = int.Parse(Request.Form["disease-category-id"]);
Disease newDisease = new Disease(name, symptom, image, category_id);
newDisease.Save();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Post["/admin/remedy/category"] = _ => {
string name = Request.Form["remedy-category-name"];
CategoryRemedy newCategoryRemedy = new CategoryRemedy(name);
newCategoryRemedy.Save();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Post["/admin/disease/category"] = _ => {
string name = Request.Form["disease-category-name"];
CategoryDisease newCategoryDisease = new CategoryDisease(name);
newCategoryDisease.Save();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Post["/admin/addRemediesToDisease"] = _ => {
string disease_id = Request.Form["disease_id"];
Disease foundDisease = Disease.Find(int.Parse(disease_id));
string remedies = Request.Form["treatment"];
string[] remedyArray = remedies.Split(',');
foreach (string remedy_id in remedyArray)
{
Remedy foundRemedy = Remedy.Find(int.Parse(remedy_id));
foundDisease.AddRemedy(foundRemedy);
}
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/diseaseCategory/delete/{id}"] = parameters => {
CategoryDisease category = CategoryDisease.Find(parameters.id);
return(View["category_disease_delete.cshtml", category]);
};
Delete["/admin/diseaseCategory/delete/{id}"] = parameters => {
CategoryDisease chosenCategoryDisease = CategoryDisease.Find(parameters.id);
chosenCategoryDisease.Delete();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/remedyCategory/delete/{id}"] = parameters => {
CategoryRemedy category = CategoryRemedy.Find(parameters.id);
return(View["category_remedy_delete.cshtml", category]);
};
Delete["/admin/remedyCategory/delete/{id}"] = parameters => {
CategoryRemedy chosenCategoryRemedy = CategoryRemedy.Find(parameters.id);
chosenCategoryRemedy.Delete();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/remedy/delete/{id}"] = parameters => {
Remedy chosen = Remedy.Find(parameters.id);
return(View["remedy_delete.cshtml", chosen]);
};
Delete["/admin/remedy/delete/{id}"] = parameters => {
Remedy chosenRemedy = Remedy.Find(parameters.id);
chosenRemedy.Delete();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/disease/delete/{id}"] = parameters => {
Disease chosen = Disease.Find(parameters.id);
return(View["disease_delete.cshtml", chosen]);
};
Delete["/admin/disease/delete/{id}"] = parameters => {
Disease chosenDisease = Disease.Find(parameters.id);
chosenDisease.Delete();
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/diseaseCategory/edit/{id}"] = parameter => {
CategoryDisease SelectedCategoryDisease = CategoryDisease.Find(parameter.id);
return(View["edit_category_disease.cshtml", SelectedCategoryDisease]);
};
Patch["/admin/diseaseCategory/edit/{id}"] = parameter => {
CategoryDisease SelectedCategoryDisease = CategoryDisease.Find(parameter.id);
SelectedCategoryDisease.Update(Request.Form["edit-name"]);
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/remedyCategory/edit/{id}"] = parameter => {
CategoryRemedy SelectedCategoryRemedy = CategoryRemedy.Find(parameter.id);
return(View["edit_category_remedy.cshtml", SelectedCategoryRemedy]);
};
Patch["/admin/remedyCategory/edit/{id}"] = parameter => {
CategoryRemedy SelectedCategoryRemedy = CategoryRemedy.Find(parameter.id);
SelectedCategoryRemedy.Update(Request.Form["edit-name"]);
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/disease/edit/{id}"] = parameter => {
Dictionary <string, object> model = new Dictionary <string, object>();
Disease SelectedDisease = Disease.Find(parameter.id);
var AllCategoryDisease = CategoryDisease.GetAll();
model.Add("SelectedDisease", SelectedDisease);
model.Add("AllCategoryDisease", AllCategoryDisease);
return(View["edit_disease.cshtml", model]);
};
Patch["/admin/disease/edit/{id}"] = parameter => {
Disease SelectedDisease = Disease.Find(parameter.id);
SelectedDisease.Update(Request.Form["edit-name"], Request.Form["edit-symptom"], Request.Form["edit-image"], Request.Form["edit-category-id"]);
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/admin/remedy/edit/{id}"] = parameter => {
Dictionary <string, object> model = new Dictionary <string, object>();
Remedy SelectedRemedy = Remedy.Find(parameter.id);
var AllCategoryRemedy = CategoryRemedy.GetAll();
model.Add("SelectedRemedy", SelectedRemedy);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
return(View["edit_remedy.cshtml", model]);
};
Patch["/admin/remedy/edit/{id}"] = parameter => {
Remedy SelectedRemedy = Remedy.Find(parameter.id);
SelectedRemedy.Update(Request.Form["edit-name"], Request.Form["edit-description"], Request.Form["edit-sideEffect"], Request.Form["edit-image"], Request.Form["edit-category-id"]);
Dictionary <string, object> model = new Dictionary <string, object>();
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
List <Disease> AllAilments = Disease.GetAll();
List <Remedy> AllRemedies = Remedy.GetAll();
model.Add("AllCategoryDisease", AllCategoryDisease);
model.Add("AllCategoryRemedy", AllCategoryRemedy);
model.Add("AllDiseases", AllAilments);
model.Add("AllRemedies", AllRemedies);
return(View["admin.cshtml", model]);
};
Get["/ailments"] = _ => {
List <Disease> AllDiseases = Disease.GetAll();
return(View["ailments.cshtml", AllDiseases]);
};
Get["/remedies"] = _ => {
List <Remedy> AllRemedies = Remedy.GetAll();
return(View["remedies.cshtml", AllRemedies]);
};
Get["/remedies/{id}"] = parameters => {
Remedy foundRemedy = Remedy.Find(parameters.id);
List <Disease> DiseaseList = foundRemedy.GetDisease();
Dictionary <string, object> model = new Dictionary <string, object>();
model.Add("foundRemedy", foundRemedy);
model.Add("DiseaseList", DiseaseList);
return(View["remedy.cshtml", model]);
};
Get["/ailments/{id}"] = parameters => {
Disease foundDisease = Disease.Find(parameters.id);
List <Remedy> RemedyList = foundDisease.GetRemedy();
Dictionary <string, object> model = new Dictionary <string, object>();
model.Add("foundDisease", foundDisease);
model.Add("remedyList", RemedyList);
return(View["ailment.cshtml", model]);
};
Get["/categoryRemedy"] = _ => {
List <CategoryRemedy> AllCategoryRemedy = CategoryRemedy.GetAll();
return(View["categoryRemedy_all.cshtml", AllCategoryRemedy]);
};
Get["/categoryRemedy/{id}"] = parameters => {
CategoryRemedy foundCategoryRemedy = CategoryRemedy.Find(parameters.id);
List <Remedy> RemedyList = foundCategoryRemedy.GetRemedy();
Dictionary <string, object> model = new Dictionary <string, object>();
model.Add("foundCategoryRemedy", foundCategoryRemedy);
model.Add("RemedyList", RemedyList);
return(View["category_remedy.cshtml", model]);
};
Get["/categoryDisease"] = _ => {
List <CategoryDisease> AllCategoryDisease = CategoryDisease.GetAll();
return(View["categoryDisease_all.cshtml", AllCategoryDisease]);
};
Get["/categoryDisease/{id}"] = parameters => {
CategoryDisease foundCategoryDisease = CategoryDisease.Find(parameters.id);
List <Disease> DiseaseList = foundCategoryDisease.GetDisease();
Dictionary <string, object> model = new Dictionary <string, object>();
model.Add("foundCategoryDisease", foundCategoryDisease);
model.Add("DiseaseList", DiseaseList);
return(View["category_disease.cshtml", model]);
};
Get["/search"] = _ => {
Dictionary <string, object> model = new Dictionary <string, object>();
List <Remedy> remedies = new List <Remedy> {
};
List <Disease> diseases = new List <Disease> {
};
model.Add("remedies", remedies);
model.Add("diseases", diseases);
return(View["search.cshtml", model]);
};
Post["/search"] = _ => {
List <Remedy> remedies = new List <Remedy> {
};
List <Disease> diseases = new List <Disease> {
};
Dictionary <string, object> model = new Dictionary <string, object>();
string searchString = Request.Form["search-field"];
string category = Request.Form["category"];
if (category == "Remedy")
{
remedies = Remedy.SearchRemedy(searchString);
}
else if (category == "Disease")
{
diseases = Disease.SearchDisease(searchString);
}
model.Add("remedies", remedies);
model.Add("diseases", diseases);
return(View["search.cshtml", model]);
};
}
