public List<Disease> GetAllDiseases()
{
int count = 0;
List<Disease> diseasesList=new List<Disease>();
string query = "SELECT * FROM DiseaseTBL";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Disease aDisease=new Disease();
aDisease.Id = int.Parse(reader["Id"].ToString());
aDisease.NameOfDisease = reader["Name"].ToString();
aDisease.Description = reader["Description"].ToString();
aDisease.TreatmentProcedure = reader["TreatmentProcedure"].ToString();
count++;
aDisease.SerialNo = count;
diseasesList.Add(aDisease);
}
reader.Close();
connection.Close();
return diseasesList;
}
public string SaveDisease(Disease aDisease)
{
int value = diseaseGateway.SaveDisease(aDisease);
if (value > 0)
{
return "Disease Has Been Saved";
}
else return "Failed";
}
public string SaveDisease(Disease aDisease)
{
int value = diseaseGateway.SaveDisease(aDisease);
if (value > 0)
{
return "New disease has been saved!";
}
else return "Failed";
}
protected void saveButton_Click(object sender, EventArgs e)
{
Disease aDisease=new Disease();
aDisease.NameOfDisease = nameDiseaseEntryTextBox.Text;
aDisease.Description = descriptionDiseaseEntryTextBox.Text;
aDisease.TreatmentProcedure = treatmentProcedureDiseaseEntryTextBox.Text;
msgLabel.Text = diseaseManager.SaveDisease(aDisease);
diseaseEntryGridView.DataSource = diseaseManager.GetAllDiseases();
diseaseEntryGridView.DataBind();
}
public int SaveDisease(Disease aDisease)
{
string query = "INSERT INTO DiseaseTBL VALUES('" + aDisease.NameOfDisease + "','"+aDisease.Description+"','"+aDisease.TreatmentProcedure+"')";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public bool IsDiseaseExists(Disease aDisease)
{
bool exists = false;
string query = "SELECT * FROM DiseaseTBL WHERE Name='" + aDisease.NameOfDisease + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
exists = true;
}
reader.Close();
connection.Close();
return exists;
}
protected void saveButton_Click(object sender, EventArgs e)
{
Disease aDisease=new Disease();
aDisease.NameOfDisease = nameDiseaseEntryTextBox.Text;
aDisease.Description = descriptionDiseaseEntryTextBox.Text;
aDisease.TreatmentProcedure = treatmentProcedureDiseaseEntryTextBox.Text;
if (diseaseManager.IsDiseaseExists(aDisease))
{
megLabel.Text = "";
errorMegLabel.Text = "This disease already exists!";
}
else
{
errorMegLabel.Text = "";
megLabel.Text = diseaseManager.SaveDisease(aDisease);
nameDiseaseEntryTextBox.Text = "";
descriptionDiseaseEntryTextBox.Text = "";
treatmentProcedureDiseaseEntryTextBox.Text = "";
diseaseEntryGridView.DataSource = diseaseManager.GetAllDiseases();
diseaseEntryGridView.DataBind();
}
}
protected void showReportButton_Click(object sender, EventArgs e)
{
string dateFrom = Request.Form["dateFrom"];
string dateTo = Request.Form["dateTo"];
int yearFrom = int.Parse(dateFrom.Substring(0, 4));
int monthFrom = int.Parse(dateFrom.Substring(5, 2));
int dayFrom = int.Parse(dateFrom.Substring(8, 2));
int monthTo = int.Parse(dateTo.Substring(5, 2));
int dayTo = int.Parse(dateTo.Substring(8, 2));
int yearTo = int.Parse(dateTo.Substring(0, 4));
List<int> patientIdList = new List<int>();
if (yearTo < yearFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else if (yearFrom == yearTo && monthTo < monthFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else if (yearFrom == yearTo && monthTo == monthFrom && dayTo < dayFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else
{
megLabel.Text = "";
for (int i = dayFrom; ; i++)
{
if (yearTo == yearFrom && monthTo == monthFrom && i == dayTo)
{
string date2 = yearFrom + "-" + monthFrom + "-" + i;
int patient2 = treatmentManager.GetPatientId(date2);
patientIdList.Add(patient2);
break;
}
string date =yearFrom + "-" + monthFrom + "-" + i;
int patient = treatmentManager.GetPatientId(date);
patientIdList.Add(patient);
if (i == 31 && monthFrom != 12)
{
monthFrom++;
i = 0;
}
else if (monthFrom == 12 && dayFrom == 31)
{
yearFrom++;
monthFrom = 1;
i = 0;
}
}
}
List<int> districtWasePatientIdList=new List<int>();
int districtId = int.Parse(districtDropDownList.SelectedValue);
foreach (int id in patientIdList) {
int patientIdDistrictWase = patientManager.GetDistictWaisePatientId(id, districtId);
districtWasePatientIdList.Add(patientIdDistrictWase);
}
List<int> observationIdList = new List<int>();
foreach (int id in districtWasePatientIdList) {
int observationId = treatmentManager.GetObservationId(id);
observationIdList.Add(observationId);
}
List<Disease> diseaseNameList = new List<Disease>();
List<Disease> allDiseaseNameList = diseaseManager.GetAllDiseases();
foreach (int id in observationIdList) {
List<int> diseaseIdList = treatmentManager.GetDiseaseId(id);
foreach (int disId in diseaseIdList) {
Disease aDisease = new Disease();
aDisease.NameOfDisease = diseaseManager.GetDiseaseName(disId);
diseaseNameList.Add(aDisease);
}
}
Series series = Chart1.Series["Series1"];
foreach (var diseaseName in allDiseaseNameList) {
int count = 0;
foreach (var nameOfDisease in diseaseNameList) {
if (diseaseName.NameOfDisease.Equals(nameOfDisease.NameOfDisease)) {
count++;
}
}
series.Points.AddXY(diseaseName.NameOfDisease, count);
}
}
public bool IsDiseaseExists(Disease aDisease)
{
return diseaseGateway.IsDiseaseExists(aDisease);
}
