/// <summary>
/// To get sub categories.
/// </summary>
/// <param name="cropName">To select sub categories under this crop </param>
/// <returns>Crop sub categories list</returns>
public List <CropSubCategories> GetSubCropCategories(string cropName)
{
List <CropSubCategories> cropSubCategories = new List <CropSubCategories>();
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
List <CHILD_FARM> dbCategories = sqlDBVirutualFormAssistEntities.CHILD_FARM.Where(childFarm => childFarm.MASTER_FARM.MASTER_FARM_NAME == cropName).ToList();
dbCategories.ToList().ForEach(dbCategory => cropSubCategories.Add(new CropSubCategories {
SubCategoryID = dbCategory.CHILD_FARM_ID, SubCategoryName = dbCategory.CHILD_FARM_NAME
}));
}
return(cropSubCategories);
}
/// <summary>
/// To get symptoms for the passed option and sub category.
/// </summary>
/// <param name="option">To select symptom for this option</param>
/// <param name="subCategory">To select symptom for this sub category</param>
/// <returns>Symptoms</returns>
public List <Symptom> GetSymptoms(string option, string subCategory)
{
List <Symptom> symptoms = new List <Symptom>();
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
List <SYMPTOM> dbCategories = sqlDBVirutualFormAssistEntities.SYMPTOMS.Where(symptom => symptom.SEARCH_OPTIONS.CHILD_FARM.CHILD_FARM_NAME == subCategory && symptom.SEARCH_OPTIONS.OPTIONS == option).ToList();
dbCategories.ToList().ForEach(dbCategory => symptoms.Add(new Symptom {
SymptomId = dbCategory.SYMPTOMS_ID, SymptomDescription = dbCategory.SYMPTOMS_DESC
}));
}
return(symptoms);
}
/// <summary>
/// To get search options for the crop sub category.
/// </summary>
/// <param name="cropSubCategoryName">To select search options for this sub category</param>
/// <returns>Search options</returns>
public List <SearchOptions> GetSearchOptions(string cropSubCategoryName)
{
List <SearchOptions> searchOptions = new List <SearchOptions>();
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
List <SEARCH_OPTIONS> dbSearchOptions = sqlDBVirutualFormAssistEntities.SEARCH_OPTIONS.Where(searchOption => searchOption.CHILD_FARM.CHILD_FARM_NAME == cropSubCategoryName).ToList();
dbSearchOptions.ToList().ForEach(dbSearchOption => searchOptions.Add(new SearchOptions {
OptionId = dbSearchOption.SEARCH_OPTIONS_ID, OptionDescription = dbSearchOption.OPTIONS
}));
}
return(searchOptions);
}
/// <summary>
/// To get crop categories.
/// </summary>
/// <param name="userId">To get the categories based on the user location</param>
/// <returns>Farm categories</returns>
public List <CropCategories> GetCropCategories(int userId)
{
List <CropCategories> cropCategories = new List <CropCategories>();
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
List <MASTER_FARM> dbCategories = sqlDBVirutualFormAssistEntities.MASTER_FARM.ToList();
dbCategories.ToList().ForEach(dbCategory => cropCategories.Add(new CropCategories {
CategoryID = dbCategory.MASTER_FARM_ID, CategoryName = dbCategory.MASTER_FARM_NAME
}));
}
return(cropCategories);
}
/// <summary>
/// To update the user queries.
/// </summary>
/// <param name="name">user name who raised this query</param>
/// <param name="email">user email</param>
/// <param name="query">user query</param>
/// <param name="attachmentURL">Attachments</param>
/// <returns>True if successfully updated, else false if any failure</returns>
public bool UpdateQuery(string name, string email, string query, string attachmentURL)
{
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
var userQuery = sqlDBVirutualFormAssistEntities.USER_QUERIES.Add(new USER_QUERIES {
USER_NAME = name, USER_EMAIL = email, USER_QUERY = query, ATTACHMENT = attachmentURL
});
sqlDBVirutualFormAssistEntities.SaveChanges();
//if inserted successfully query id will get retrieved from db.
return(userQuery.USER_QUERY_ID > 0);
}
}
/// <summary>
/// To get symptoms results for the passed symptom and sub category.
/// </summary>
/// <param name="symptom">To select symptom results for this symptom</param>
/// <param name="subCategory">To select symptom results for this sub category</param>
/// <returns>Symptom results</returns>
public string GetSymptomsResults(string symptom, string subCategory)
{
string symptoms = string.Empty;
using (SQLDBVirtualFarmerAssitEntities sqlDBVirutualFormAssistEntities = new SQLDBVirtualFarmerAssitEntities())
{
List <SYMPTOM_RESULTS> dbCategories = sqlDBVirutualFormAssistEntities.SYMPTOM_RESULTS.Where(symptomResult => symptomResult.SYMPTOM.SYMPTOMS_DESC == symptom &&
symptomResult.SYMPTOM.SEARCH_OPTIONS.CHILD_FARM.CHILD_FARM_NAME == subCategory).ToList();
//var dbSymptom = dbCategories.FirstOrDefault(dbCategory => dbCategory.SYMPTOMS_DESC == symptom);
if (dbCategories != null)
{
symptoms = dbCategories.FirstOrDefault().SYMPTOMS_DESC;
}
}
return(symptoms);
}