public List <ViewStrory> ViewStory(string name)
{
DiseaseDBGateway aDiseaseDbGateway = new DiseaseDBGateway();
DistrictDBGateway aDistrictDbGateway = new DistrictDBGateway();
ThanaDBGateway aThanaDbGateway = new ThanaDBGateway();
CenterDBGateway aCenterDbGateway = new CenterDBGateway();
string query = "SELECT *FROM tbl_patient WHERE name='" + name + "'";
ASqlConnection.Open();
ASqlCommand = new SqlCommand(query, ASqlConnection);
ASqlDataReader = ASqlCommand.ExecuteReader();
List <ViewStrory> viewHistories = new List <ViewStrory>();
while (ASqlDataReader.Read())
{
ViewStrory aViewHistory = new ViewStrory();
aViewHistory.Id = Convert.ToInt32(ASqlDataReader["id"]);
aViewHistory.Name = ASqlDataReader["name"].ToString();
aViewHistory.Diseases = aDiseaseDbGateway.FindId(Convert.ToInt32(ASqlDataReader["diseaseId"])).Name;
aViewHistory.Destrict = aDistrictDbGateway.Find(Convert.ToInt32(ASqlDataReader["districtId"])).Name;
aViewHistory.Thana = aThanaDbGateway.Find(Convert.ToInt32(ASqlDataReader["thanaId"])).Name;
aViewHistory.Center = aCenterDbGateway.GetCenterById(Convert.ToInt32(ASqlDataReader["centerId"])).Name;
viewHistories.Add(aViewHistory);
}
ASqlDataReader.Close();
ASqlConnection.Close();
return(viewHistories);
}