private void ShowGridView(Treatment service)
{
var gridView = new GridView();
gridView.CssClass = "gvdatatable dataTable";
gridView.AutoGenerateColumns = false;
BoundField bf = new BoundField();
bf.DataField = "DiseaseName";
bf.HeaderText = "Diseases Name";
gridView.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "MedicineName";
bf.HeaderText = "Medicine Name";
gridView.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "Does";
bf.HeaderText = "Dose";
gridView.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "MealTime";
bf.HeaderText = "Before/After Meal";
gridView.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "Quantity";
bf.HeaderText = "Quantity";
gridView.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "Note";
bf.HeaderText = "Note";
gridView.Columns.Add(bf);
gridView.DataSource = centerManager.GetAllTreatmentList(service.Date, VoterId);
gridView.DataBind();
section.Controls.Add(gridView);
}
private void LoadGridView()
{
aTreatment = (Treatment)ViewState["Treatment"];
addTreatmentGridView.DataSource = Treatments;
addTreatmentGridView.DataBind();
}
public List<Treatment> GetAllTreatmentList(DateTime date, string voterId)
{
string query = "select tbl_medicine.MedicineName,tbl_diseases.DiseasesName,tbl_treatment.does,tbl_treatment.note,tbl_treatment.meal_time,tbl_treatment.quantity from tbl_treatment join tbl_diseases ON tbl_treatment.diseaseId=tbl_diseases.id join tbl_medicine ON tbl_treatment.medicineId=tbl_medicine.id Where patientVoterId='" + voterId + "' AND date='" + date + "'";
sqlConnection.Open();
sqlCommand.CommandText = query;
SqlDataReader aReader = sqlCommand.ExecuteReader();
List<Treatment> treatmentList = new List<Treatment>();
while (aReader.Read())
{
Treatment aTreatment = new Treatment();
aTreatment.MedicineName = aReader["MedicineName"].ToString();
aTreatment.DiseaseName = aReader["DiseasesName"].ToString();
aTreatment.Does = aReader["does"].ToString();
aTreatment.MealTime = aReader["meal_time"].ToString();
aTreatment.Quantity = (int)aReader["quantity"];
aTreatment.Note = aReader["note"].ToString();
treatmentList.Add(aTreatment);
}
aReader.Close();
sqlConnection.Close();
return treatmentList;
}
public List<Treatment> GetNumberofServiceTaken(string voterId)
{
string query = "SELECT DISTINCT date FROM tbl_treatment WHERE patientVoterId ='" + voterId + "'";
sqlConnection.Open();
sqlCommand.CommandText = query;
SqlDataReader aReader = sqlCommand.ExecuteReader();
List<Treatment> treatmentList = new List<Treatment>();
while (aReader.Read())
{
Treatment aTreatment = new Treatment();
aTreatment.Date = (DateTime) aReader["date"];
treatmentList.Add(aTreatment);
}
aReader.Close();
sqlConnection.Close();
return treatmentList;
}
public List<Treatment> GetAllTreatmentByDate(DateTime date, string voterId)
{
string query =" SELECT DISTINCT tbl_center.CenterName,tbl_treatment.date,tbl_doctor.name,tbl_treatment.observation from tbl_treatment join tbl_center ON tbl_center.id=tbl_treatment.centerId join tbl_doctor ON tbl_doctor.id=tbl_treatment.doctorId Where patientVoterId='"+voterId+"' AND date='"+date+"'";
sqlConnection.Open();
sqlCommand.CommandText = query;
SqlDataReader aReader = sqlCommand.ExecuteReader();
List<Treatment> treatmentList = new List<Treatment>();
while (aReader.Read())
{
Treatment aTreatment = new Treatment();
aTreatment.CenterName = aReader["CenterName"].ToString();
aTreatment.Date = (DateTime) aReader["date"];
aTreatment.DoctorName = aReader["name"].ToString();
aTreatment.Observation = aReader["observation"].ToString();
treatmentList.Add(aTreatment);
}
aReader.Close();
sqlConnection.Close();
return treatmentList;
}
