public static List <ClassFields> Warnings(double DID)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName, tbl_Warnings.WarningsDescription FROM tbl_WaningsDrugs INNER JOIN tbl_Warnings ON tbl_WaningsDrugs.WarningID = tbl_Warnings.WarningsID INNER JOIN tbl_Drugs ON tbl_WaningsDrugs.DrugID = tbl_Drugs.DrugID WHERE tbl_WaningsDrugs.DrugID = '" + DID + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.WarningsDescription = "•" + dr["WarningsDescription"].ToString();
list.Add(f);
}
}
}
}
}
return(list);
}
public static List <ClassFields> AllDrugClassesSearch(string dc)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_DrugClass WHERE drugClass LIKE '" + dc + "%'ORDER BY drugClass";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugclassID = long.Parse(dr["DrugclassID"].ToString());
f.drugClass = dr["drugClass"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.DrugclassID = 0;
f.drugClass = "0 Result";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> LoadMedicinesSearchings(double IllnessID, string likename)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_Drugs.DrugID, tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName FROM tbl_Drugs INNER JOIN tbl_DrugIllness ON tbl_Drugs.DrugID = tbl_DrugIllness.DrugID INNER JOIN tbl_Illness ON tbl_DrugIllness.IllnessID = tbl_Illness.IllnessID WHERE tbl_DrugIllness.IllnessID = '" + IllnessID + "'AND tbl_Drugs.DrugName LIKE '" + likename + "%'ORDER BY tbl_Drugs.DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return(list);
}
public static List <ClassFields> LoadSymptoms(double IllnessID)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Illness.IllnessName, tbl_Symptoms.Symptoms, tbl_Illness.IllnessID FROM tbl_Illness INNER JOIN tbl_IllnessSymptoms ON tbl_Illness.IllnessID = tbl_IllnessSymptoms.IllnessID INNER JOIN tbl_Symptoms ON tbl_IllnessSymptoms.SymptomsID = tbl_Symptoms.SymptomsID WHERE tbl_Illness.IllnessID = '" + IllnessID + "'GROUP BY tbl_Illness.IllnessName, tbl_Symptoms.Symptoms, tbl_Illness.IllnessID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.Symptoms = "-->> " + dr["Symptoms"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.Symptoms = "Unavailable";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> LoadDosage(double DrugIDs)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugName, tbl_Dosage.Dosage, tbl_Dosage.DosageID, tbl_Drugs.DrugID FROM tbl_Dosage INNER JOIN tbl_DosageDrugs ON tbl_Dosage.DosageID = tbl_DosageDrugs.DosageID INNER JOIN tbl_Drugs ON tbl_DosageDrugs.DrugID = tbl_Drugs.DrugID WHERE tbl_DosageDrugs.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.Dosage = dr["Dosage"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return(list);
}
public static List <ClassFields> AllDrugz()
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_Drugs ORDER BY DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return(list);
}
public static List<ClassFields> Illness_Load()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_Illness ORDER BY IllnessName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.IllnessID = long.Parse(dr["IllnessID"].ToString());
f.IllnessName = dr["IllnessName"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> Category_LoadZERO()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_categoryWEB.CategoryID, tbl_categoryWEB.CategoryName, COUNT(tbl_TopicWEB.CategoryID) AS Number_of_Topic FROM tbl_TopicWEB INNER JOIN tbl_categoryWEB ON tbl_TopicWEB.CategoryID = tbl_categoryWEB.CategoryID GROUP BY tbl_categoryWEB.CategoryID, tbl_categoryWEB.CategoryName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.CategoryID = long.Parse(dr["CategoryID"].ToString());
f.CategoryName = dr["CategoryName"].ToString();
f.Number_of_Topic = dr["Number_of_Topic"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List <ClassFields> FormsAvailable(double DrugIDs)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugName, tbl_AvailableForms.AvailableForms FROM tbl_AvailableForms INNER JOIN tbl_AvailableFormsDrugs ON tbl_AvailableForms.FormsID = tbl_AvailableFormsDrugs.FormsID INNER JOIN tbl_Drugs ON tbl_AvailableFormsDrugs.DrugID = tbl_Drugs.DrugID WHERE tbl_AvailableFormsDrugs.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.AvailableForms = dr["AvailableForms"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.AvailableForms = "On progress";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> view_Expenses_Categorized_bydate(double userIDxExpense, string startdate, string enddate)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_RecordsSpent.amountspent, tbl_RecordsSpent.dateRecorded, tbl_RecordsSpent.usersexpensesID, tbl_expenses_users.expensesID FROM tbl_RecordsSpent INNER JOIN tbl_expenses_users ON tbl_RecordsSpent.usersexpensesID = tbl_expenses_users.usersexpensesID WHERE tbl_RecordsSpent.dateRecorded BETWEEN '" + startdate + "'AND'" + enddate + "'AND tbl_expenses_users.expensesID = '" + userIDxExpense + "'ORDER BY tbl_RecordsSpent.dateRecorded DESC";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
string v = string.Format("{0:N2}", dr["amountspent"].ToString());
f.amountspent = "P " + v.ToString();
f.dateRecorded = dr["dateRecorded"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.amountspent = "0";
f.dateRecorded = "no Record/s Yet";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> LoadDrugClass(double DrugIDs)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_DrugClass.drugClass FROM tbl_Drugs INNER JOIN tbl_MedicineDrugClass ON tbl_Drugs.DrugID = tbl_MedicineDrugClass.DrugID INNER JOIN tbl_DrugClass ON tbl_MedicineDrugClass.DrugclassID = tbl_DrugClass.DrugclassID WHERE tbl_Drugs.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.drugClass = ">>" + dr["drugClass"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.drugClass = "--";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> Illness_LoadSearching(string ill)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT IllnessID,IllnessName FROM tbl_Illness WHERE IllnessName LIKE '" + ill + "%'ORDER BY IllnessName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.IllnessID = long.Parse(dr["IllnessID"].ToString());
f.IllnessName = dr["IllnessName"].ToString();
list.Add(f);
}
}
}
}
}
return(list);
}
public static List <ClassFields> LoadTreatments(double IllnessID)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_Treatment WHERE IllnessID = '" + IllnessID + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.TreatmentDescription = "-->> " + dr["TreatmentDescription"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.TreatmentDescription = "Unavailable";
list.Add(f);
}
}
}
}
return(list);
}
public static List<ClassFields> AllDrugClasses()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_DrugClass ORDER BY drugClass";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugclassID = long.Parse(dr["DrugclassID"].ToString());
f.drugClass = dr["drugClass"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return list;
}
public static List<ClassFields> Warnings(double DID)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName, tbl_Warnings.WarningsDescription FROM tbl_WaningsDrugs INNER JOIN tbl_Warnings ON tbl_WaningsDrugs.WarningID = tbl_Warnings.WarningsID INNER JOIN tbl_Drugs ON tbl_WaningsDrugs.DrugID = tbl_Drugs.DrugID WHERE tbl_WaningsDrugs.DrugID = '" + DID + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.WarningsDescription = "•" + dr["WarningsDescription"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public ResolvedClassField GetOrCreateClassField(ResolvedClassId classId, string fieldName)
{
var clazz = myClasses[classId];
var fieldId = ClassFields.FindOrAdd(fieldName);
return(clazz.GetOrCreateField(fieldId));
}
public static List <ClassFields> CatgoryLoad()
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM CATEGORY ORDER BY CategoryName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields fields = new ClassFields();
fields.Category_Num = long.Parse(dr["Category_Num"].ToString());
fields.CategoryName = "[ " + dr["CategoryName"].ToString() + " ]";
list.Add(fields);
}
}
}
}
}
return(list);
}
/// <summary>
/// Reload data.
/// </summary>
/// <param name="setAutomatically">Indicates whether search options should be set automatically</param>
public void ReloadSearch(bool setAutomatically)
{
ClassFields.ItemID = ItemID;
ClassFields.ReloadData(setAutomatically, true);
// Initialize properties
List <IFormItem> itemList = null;
FormFieldInfo formField = null;
// Load DataClass
dci = DataClassInfoProvider.GetDataClass(ItemID);
if (dci != null)
{
// Load XML definition
fi = FormHelper.GetFormInfo(dci.ClassName, true);
if (CMSString.Compare(dci.ClassName, "cms.user", true) == 0)
{
plcImage.Visible = false;
ClassFields.DisplaySetAutomatically = false;
pnlIndent.Visible = true;
document = DataClassInfoProvider.GetDataClass("cms.usersettings");
if (document != null)
{
FormInfo fiSettings = FormHelper.GetFormInfo(document.ClassName, true);
fi.CombineWithForm(fiSettings, true, String.Empty);
}
}
// Get all fields
itemList = fi.GetFormElements(true, true);
}
if (itemList != null)
{
if (itemList.Any())
{
pnlIndent.Visible = true;
}
// Store each field to array
foreach (object item in itemList)
{
if (item is FormFieldInfo)
{
formField = ((FormFieldInfo)(item));
object[] obj = { formField.Name, FormHelper.GetDataType(formField.DataType) };
attributes.Add(obj);
}
}
}
ReloadControls();
}
/// <summary>
/// Reload data.
/// </summary>
/// <param name="setAutomatically">Indicates whether search options should be set automatically</param>
public void ReloadSearch(bool setAutomatically)
{
ClassFields.ItemID = ItemID;
ClassFields.ReloadData(setAutomatically, true);
// Initialize properties
List <IDataDefinitionItem> itemList = null;
if (ClassInfo != null)
{
// Load XML definition
fi = FormHelper.GetFormInfo(ClassInfo.ClassName, true);
if (CMSString.Compare(ClassInfo.ClassName, "cms.user", true) == 0)
{
plcImage.Visible = false;
ClassFields.DisplaySetAutomatically = false;
pnlIndent.Visible = true;
document = DataClassInfoProvider.GetDataClassInfo("cms.usersettings");
if (document != null)
{
FormInfo fiSettings = FormHelper.GetFormInfo(document.ClassName, true);
fi.CombineWithForm(fiSettings, true, String.Empty);
}
}
// Get all fields
itemList = fi.GetFormElements(true, true);
}
if (itemList != null)
{
if (itemList.Any())
{
pnlIndent.Visible = true;
}
// Store each field to array
foreach (var item in itemList)
{
var formField = item as FormFieldInfo;
if (formField != null)
{
object[] obj = { formField.Name, DataTypeManager.GetSystemType(TypeEnum.Field, formField.DataType) };
attributes.Add(obj);
}
}
}
if (AdvancedMode)
{
ReloadControls();
}
}
public static List <ClassFields> view_User_Expenses_Reports(double UserIds)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT SUM(tbl_RecordsSpent.amountspent) AS OverallAmount, tbl_expensesDesc.expensesdescription, tbl_expenses_users.registereduserID, tbl_expenses_users.usersexpensesID, tbl_expenses_users.expensesID FROM RegisteredUsers INNER JOIN tbl_expenses_users ON RegisteredUsers.registereduserID = tbl_expenses_users.registereduserID INNER JOIN tbl_expensesDesc ON tbl_expenses_users.expensesID = tbl_expensesDesc.expensesID INNER JOIN tbl_RecordsSpent ON tbl_expenses_users.usersexpensesID = tbl_RecordsSpent.usersexpensesID WHERE RegisteredUsers.registereduserID = '" + UserIds + "'GROUP BY tbl_expensesDesc.expensesdescription, tbl_expenses_users.registereduserID, tbl_expenses_users.usersexpensesID, tbl_expenses_users.expensesID ORDER BY tbl_expensesDesc.expensesdescription";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.OverallAmount = "P " + dr["OverallAmount"].ToString();
f.expensesdescription = dr["expensesdescription"].ToString();
f.registereduserID = long.Parse(dr["registereduserID"].ToString());
f.usersexpensesID = long.Parse(dr["usersexpensesID"].ToString());
f.expensesID = long.Parse(dr["expensesID"].ToString());
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.OverallAmount = "Empty";
f.expensesdescription = "Empty";
f.registereduserID = 0;
f.usersexpensesID = 0;
f.expensesID = 0;
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> UserMembers()
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT userID, userlname + ', ' + userfname + ' ' + usermname AS Members, usercodename, userpassword FROM dbo.tbl_UserClient ORDER BY Members";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.userID = long.Parse(dr["userID"].ToString());
f.Members = dr["Members"].ToString();
f.usercodename = dr["usercodename"].ToString();
f.userpassword = dr["userpassword"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.userID = 0;
f.Members = "unavailable";
f.usercodename = "unavailable";
f.userpassword = "******";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> view_Expenses(double expenz)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT recordsAmountID, usersexpensesID, amountspent, dateRecorded FROM dbo.tbl_RecordsSpent WHERE usersexpensesID = '" + expenz + "'ORDER BY dateRecorded DESC";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.recordsAmountID = long.Parse(dr["recordsAmountID"].ToString());
f.usersexpensesID = long.Parse(dr["usersexpensesID"].ToString());
string v = string.Format("{0:N2}", dr["amountspent"].ToString());
f.amountspent = "P " + v.ToString();
f.dateRecorded = dr["dateRecorded"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.recordsAmountID = 0;
f.usersexpensesID = 0;
f.amountspent = "0";
f.dateRecorded = "no Record/s Yet";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> Customer_Load()
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM CUSTOMER ORDER BY Cust_LName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields fields = new ClassFields();
fields.Cust_Num = long.Parse(dr["Cust_Num"].ToString());
fields.Cust_LName = dr["Cust_LName"].ToString();
fields.Cust_FName = dr["Cust_FName"].ToString();
fields.Cust_MName = dr["Cust_MName"].ToString();
fields.Cust_AddressCountry = dr["Cust_AddressCountry"].ToString();
fields.Cust_AddressCity = dr["Cust_AddressCity"].ToString();
fields.Cust_AddressPostal = dr["Cust_AddressPostal"].ToString();
fields.Cust_AddressStreet = dr["Cust_AddressStreet"].ToString();
fields.Cust_Age = int.Parse(dr["Cust_Age"].ToString());
fields.Cust_EmailAddress = dr["Cust_EmailAddress"].ToString();
fields.Cust_General_Balance = dr["Cust_General_Balance"].ToString();
fields.Cust_username = dr["Cust_username"].ToString();
fields.Cust_Password = dr["Cust_Password"].ToString();
list.Add(fields);
}
}
}
}
}
return(list);
}
public static List <ClassFields> AllExpenses_tobeEdited(double usersid)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_expenses_users.usersexpensesID, tbl_expenses_users.registereduserID, tbl_expenses_users.expensesID, tbl_expensesDesc.expensesdescription FROM RegisteredUsers INNER JOIN tbl_expenses_users ON RegisteredUsers.registereduserID = tbl_expenses_users.registereduserID INNER JOIN tbl_expensesDesc ON tbl_expenses_users.expensesID = tbl_expensesDesc.expensesID WHERE RegisteredUsers.registereduserID = '" + usersid + "'ORDER BY tbl_expensesDesc.expensesdescription";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.usersexpensesID = long.Parse(dr["usersexpensesID"].ToString());
f.registereduserID = long.Parse(dr["registereduserID"].ToString());
f.expensesID = long.Parse(dr["expensesID"].ToString());
f.expensesdescription = dr["expensesdescription"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.usersexpensesID = 0;
f.registereduserID = 0;
f.expensesID = 0;
f.expensesdescription = "no Records Yet";
list.Add(f);
}
}
}
}
return(list);
}
public static List <ClassFields> DrugClass_Medecina(double drugclassid)
{
List <ClassFields> list = new List <ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_Drugs.DrugID, tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName, tbl_DrugClass.drugClass, tbl_DrugClass.DrugclassID FROM tbl_Drugs INNER JOIN tbl_MedicineDrugClass ON tbl_Drugs.DrugID = tbl_MedicineDrugClass.DrugID INNER JOIN tbl_DrugClass ON tbl_MedicineDrugClass.DrugclassID = tbl_DrugClass.DrugclassID WHERE tbl_MedicineDrugClass.DrugclassID = '" + drugclassid + "'ORDER BY tbl_Drugs.DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
// f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = "No results Found.";
list.Add(f);
}
}
}
}
return(list);
}
public static List<ClassFields> POSTSz(double threadi)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_usersWEB.LastNamez + ' ' + tbl_usersWEB.FirstNamez AS userzx, tbl_usersWEB.EmailAddressz, tbl_PostWEB.Post, tbl_PostWEB.PostDate FROM tbl_usersWEB INNER JOIN tbl_PostWEB ON tbl_usersWEB.UserCID = tbl_PostWEB.UserCID WHERE tbl_PostWEB.ThreadID = '" + threadi + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.userzx = dr["userzx"].ToString() + "\n" + "[" + dr["EmailAddressz"].ToString() + "]";
f.Post = dr["Post"].ToString();
f.PostDate = dr["PostDate"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> Subject_Load(double idconfirmation)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_TopicWEB.TopicID, tbl_TopicWEB.TopicDecription, COUNT(tbl_TopicWEB.TopicID) AS Number_of_Threds FROM tbl_TopicWEB INNER JOIN tbl_ThreadWEB ON tbl_TopicWEB.TopicID = tbl_ThreadWEB.TopicID WHERE tbl_TopicWEB.CategoryID = '" + idconfirmation + "'GROUP BY tbl_TopicWEB.TopicID, tbl_TopicWEB.TopicDecription, tbl_TopicWEB.CategoryID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.TopicID = long.Parse(dr["TopicID"].ToString());
f.TopicDecription = dr["TopicDecription"].ToString();
f.Number_of_Threds = dr["Number_of_Threds"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> Subject_LoadZERO(double idconfirmation)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TopicID, TopicDecription, topicstatus FROM tbl_TopicWEB WHERE (topicstatus = 0) AND CategoryID ='" + idconfirmation + "'GROUP BY TopicID, TopicDecription, topicstatus, CategoryID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.TopicID = long.Parse(dr["TopicID"].ToString());
f.TopicDecription = dr["TopicDecription"].ToString();
f.topicstatus = dr["topicstatus"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> DrugClass_Medecina(double drugclassid)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_Drugs.DrugID, tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName, tbl_DrugClass.drugClass, tbl_DrugClass.DrugclassID FROM tbl_Drugs INNER JOIN tbl_MedicineDrugClass ON tbl_Drugs.DrugID = tbl_MedicineDrugClass.DrugID INNER JOIN tbl_DrugClass ON tbl_MedicineDrugClass.DrugclassID = tbl_DrugClass.DrugclassID WHERE tbl_MedicineDrugClass.DrugclassID = '" + drugclassid + "'ORDER BY tbl_Drugs.DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
// f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = "No results Found.";
list.Add(f);
}
}
}
}
return list;
}
public static List<ClassFields> ThreadsWoPostsz(double idconfigz)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT ThreadID, ThreadTopic, ThreadStatus, ThreadViewCount FROM dbo.tbl_ThreadWEB WHERE (ThreadStatus = 0) AND TopicID = '" + idconfigz + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.ThreadID = long.Parse(dr["ThreadID"].ToString());
f.ThreadTopic = "----" + dr["ThreadTopic"].ToString();
f.ThreadStatus = long.Parse(dr["ThreadStatus"].ToString());
f.ThreadViewCount = long.Parse(dr["ThreadViewCount"].ToString());
list.Add(f);
}
}
}
}
}
return list;
}
public int GetOrCreateFieldId(string name)
{
var id = ClassFields.FindOrAdd(name);
return(id);
}
public static List<ClassFields> CountAllCategorywithTopics()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT COUNT(CategoryID) AS Withtopics FROM dbo.tbl_categoryWEB WHERE (CategoryStatus = 1)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.Withtopics = dr["Withtopics"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> LoadSideEffects(double DrugIDs)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugID, tbl_Drugs.DrugName, tbl_SideEffects.SideEffectsID AS Expr1, tbl_SideEffects.SideEffects FROM tbl_drugSideEffects INNER JOIN tbl_Drugs ON tbl_drugSideEffects.DrugID = tbl_Drugs.DrugID INNER JOIN tbl_SideEffects ON tbl_drugSideEffects.SideEffectsID = tbl_SideEffects.SideEffectsID WHERE tbl_drugSideEffects.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.SideEffects = dr["SideEffects"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return list;
}
public static List<ClassFields> Category_LoadZEROzzzzzz()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT CategoryID, CategoryName, CategoryStatus FROM dbo.tbl_categoryWEB WHERE (CategoryStatus = 0)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.CategoryID = long.Parse(dr["CategoryID"].ToString());
f.CategoryName = dr["CategoryName"].ToString();
f.CategoryStatus = long.Parse(dr["CategoryStatus"].ToString());
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> LoadMedicinesSearchings(double IllnessID,string likename)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT tbl_Drugs.DrugID, tbl_Drugs.DrugName, tbl_Drugs.GenericName, tbl_Drugs.BrandName FROM tbl_Drugs INNER JOIN tbl_DrugIllness ON tbl_Drugs.DrugID = tbl_DrugIllness.DrugID INNER JOIN tbl_Illness ON tbl_DrugIllness.IllnessID = tbl_Illness.IllnessID WHERE tbl_DrugIllness.IllnessID = '" + IllnessID + "'AND tbl_Drugs.DrugName LIKE '" + likename + "%'ORDER BY tbl_Drugs.DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
}
}
}
}
return list;
}
public static List<ClassFields> LoadDrugClass(double DrugIDs)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_DrugClass.drugClass FROM tbl_Drugs INNER JOIN tbl_MedicineDrugClass ON tbl_Drugs.DrugID = tbl_MedicineDrugClass.DrugID INNER JOIN tbl_DrugClass ON tbl_MedicineDrugClass.DrugclassID = tbl_DrugClass.DrugclassID WHERE tbl_Drugs.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.drugClass = ">>" + dr["drugClass"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.drugClass = "--";
list.Add(f);
}
}
}
}
return list;
}
public static List<ClassFields> FormsAvailable(double DrugIDs)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Drugs.DrugName, tbl_AvailableForms.AvailableForms FROM tbl_AvailableForms INNER JOIN tbl_AvailableFormsDrugs ON tbl_AvailableForms.FormsID = tbl_AvailableFormsDrugs.FormsID INNER JOIN tbl_Drugs ON tbl_AvailableFormsDrugs.DrugID = tbl_Drugs.DrugID WHERE tbl_AvailableFormsDrugs.DrugID = '" + DrugIDs + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.AvailableForms = dr["AvailableForms"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.AvailableForms = "On progress";
list.Add(f);
}
}
}
}
return list;
}
public static List<ClassFields> Name_LOAD()
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT LastNamez + '' + FirstNamez AS Names, EmailAddressz FROM dbo.tbl_usersWEB";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.Names = dr["Names"].ToString();
f.EmailAddressz = dr["EmailAddressz"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> Topics_LoadwIDENTIFICATIONwthreads(double idconfigz)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_ThreadWEB.ThreadID, tbl_ThreadWEB.ThreadTopic, COUNT(tbl_ThreadWEB.ThreadID) AS Posts, dbo.tbl_ThreadWEB.ThreadViewCount FROM tbl_TopicWEB INNER JOIN tbl_ThreadWEB ON tbl_TopicWEB.TopicID = tbl_ThreadWEB.TopicID INNER JOIN tbl_PostWEB ON tbl_ThreadWEB.ThreadID = tbl_PostWEB.ThreadID WHERE tbl_TopicWEB.TopicID = '" + idconfigz + "'GROUP BY tbl_ThreadWEB.ThreadID, tbl_ThreadWEB.ThreadTopic, dbo.tbl_ThreadWEB.ThreadViewCount";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.ThreadID = long.Parse(dr["ThreadID"].ToString());
f.ThreadTopic = "----" + dr["ThreadTopic"].ToString();
f.Posts = dr["Posts"].ToString();
f.ThreadViewCount = long.Parse(dr["ThreadViewCount"].ToString());
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> DisplaySpecificCategory(double specificid)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT dbo.tbl_categoryWEB.* FROM dbo.tbl_categoryWEB WHERE CategoryID = '" + specificid + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.CategoryName = "-----" + dr["CategoryName"].ToString() + " " + "[Category]";
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> UserMembersSearch(string userslname)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT TOP (100) PERCENT userID, userlname + ', ' + userfname + ' ' + usermname AS Members, usercodename, userpassword FROM dbo.tbl_UserClient WHERE userlname LIKE '" + userslname + "%'ORDER BY Members";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.userID = long.Parse(dr["userID"].ToString());
f.Members = dr["Members"].ToString();
f.usercodename = dr["usercodename"].ToString();
f.userpassword = dr["userpassword"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.userID = 0;
f.Members = "unavailable";
f.usercodename = "unavailable";
f.userpassword = "******";
list.Add(f);
}
}
}
}
return list;
}
public static List<ClassFields> LoadSymptoms(double IllnessID)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_Illness.IllnessName, tbl_Symptoms.Symptoms, tbl_Illness.IllnessID FROM tbl_Illness INNER JOIN tbl_IllnessSymptoms ON tbl_Illness.IllnessID = tbl_IllnessSymptoms.IllnessID INNER JOIN tbl_Symptoms ON tbl_IllnessSymptoms.SymptomsID = tbl_Symptoms.SymptomsID WHERE tbl_Illness.IllnessID = '" + IllnessID + "'GROUP BY tbl_Illness.IllnessName, tbl_Symptoms.Symptoms, tbl_Illness.IllnessID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.Symptoms = "-->> " + dr["Symptoms"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.Symptoms = "Unavailable";
list.Add(f);
}
}
}
}
return list;
}
public static List<ClassFields> THREADINGZbySpecificUser(double threadi)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT tbl_usersWEB.LastNamez + ',' + tbl_usersWEB.FirstNamez AS UserBy, tbl_usersWEB.EmailAddressz FROM tbl_ThreadWEB INNER JOIN tbl_usersWEB ON tbl_ThreadWEB.UserCID = tbl_usersWEB.UserCID WHERE tbl_ThreadWEB.ThreadID = '" + threadi + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.UserBy = dr["UserBy"].ToString();
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> THREADINGZ(double threadi)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_ThreadWEB WHERE ThreadID = '" + threadi + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.ThreadTopic = "----------*" + dr["ThreadTopic"].ToString() + "*----------";
list.Add(f);
}
}
}
}
}
return list;
}
public static List<ClassFields> LoadTreatments(double IllnessID)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_Treatment WHERE IllnessID = '" + IllnessID + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.TreatmentDescription = "-->> " + dr["TreatmentDescription"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
f.TreatmentDescription = "Unavailable";
list.Add(f);
}
}
}
}
return list;
}
Tree GetTree(string fullname, string name)
{
List <Type> final = new List <Type>();
switch (name)
{
case "ClusterAlgorithm":
foreach (Type t in clustering)
{
final.Add(t);
}
break;
case "ConsensusFunction":
foreach (Type t in ensemble)
{
final.Add(t);
}
break;
case "Measure":
foreach (Type t in measure)
{
final.Add(t);
}
break;
default:
return(null);
}
ClassFields c = new ClassFields()
{
FullName = fullname, Name = name, IsAbstract = true
};
Tree root = new Tree(c);
Queue <Tree> queue = new Queue <Tree>();
queue.Enqueue(root);
while (queue.Count > 0)
{
Tree top = queue.Dequeue();
Type type = assembly.GetType(top.Value.FullName);
List <DataStructures.Property> _properties = new List <DataStructures.Property>();
List <DataStructures.Property> _propertiesIN = new List <DataStructures.Property>();
List <DataStructures.Property> _propertiesOUT = new List <DataStructures.Property>();
PropertyInfo[] p = type.GetProperties();
foreach (PropertyInfo item in p)
{
DataStructures.Property p1 = new DataStructures.Property()
{
ClassName = top.Value.Name, Name = item.Name
};
foreach (var item1 in item.GetCustomAttributes(true))
{
In _attIN = item1 as In;
Out _attOUT = item1 as Out;
if (_attIN != null)
{
//p1.ParameterConverterType = _attIN.ParameterConverterType;
//p1.Converter = GetConverter(_attIN.ParameterConverterType.FullName);
p1.Converter = _attIN.Converter;
p1.IsMultipleSelection = _attIN.IsMultipleSelection;
p1.Value_Converters = _attIN.Value_Converters;
_propertiesIN.Add(p1);
break;
}
else if (_attOUT != null)
{
_propertiesOUT.Add(p1);
break;
}
}
_properties.Add(p1);
}
top.Value.Properties = _properties;
top.Value.InProperties = _propertiesIN;
top.Value.OutProperties = _propertiesOUT;
List <Tree> lnc = new List <Tree>();
List <int> indexs = new List <int>();
for (int i = 0; i < final.Count; i++)
{
if (final[i].BaseType == type)
{
Tree ncf = new Tree(new ClassFields());
if (!final[i].IsAbstract)
{
IName instance = GetInstance <IName>(final[i].FullName);
ncf.Value.Name = instance.Name;
}
else
{
ncf.Value.Name = final[i].Name;
}
ncf.Value.FullName = final[i].FullName;
ncf.Value.IsAbstract = final[i].IsAbstract ? true : false;
lnc.Add(ncf);
indexs.Add(i);
queue.Enqueue(ncf);
}
}
top.Childs = lnc;
for (int i = indexs.Count - 1; i >= 0; i--)
{
final.RemoveAt(indexs[i]);
}
}
return(root);
}
public static List<ClassFields> Topics_LoadwIDENTIFICATION(double idconfig)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_TopicWEB WHERE TopicID = '" + idconfig + "'";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.TopicDecription = " Topic: ----- " + dr["TopicDecription"].ToString() + "-----";
list.Add(f);
}
}
}
}
}
return list;
}
/// <summary>
/// Calls method from ClassFields control which stores data.
/// </summary>
public void SaveData()
{
ClassFields.SaveData();
}
public static List<ClassFields> AllDrugzSearch(string names)
{
List<ClassFields> list = new List<ClassFields>();
using (SqlConnection conn = ClassConnection.ConnectToServer())
{
string sql = "SELECT * FROM tbl_Drugs WHERE DrugName LIKE '" + names + "%'ORDER BY DrugName";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
ClassFields f = new ClassFields();
f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = dr["DrugName"].ToString();
f.GenericName = dr["GenericName"].ToString();
f.BrandName = dr["BrandName"].ToString();
list.Add(f);
}
}
else
{
ClassFields f = new ClassFields();
// f.DrugID = long.Parse(dr["DrugID"].ToString());
f.DrugName = "No results Found." + "'" + names.ToString() + "'?";
list.Add(f);
}
}
}
}
return list;
}
