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; }