public List <ViewHistory> 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 <ViewHistory> viewHistories = new List <ViewHistory>(); while (ASqlDataReader.Read()) { ViewHistory aViewHistory = new ViewHistory(); aViewHistory.Id = Convert.ToInt32(ASqlDataReader["id"]); aViewHistory.Name = ASqlDataReader["name"].ToString(); aViewHistory.Diseases = aDiseaseDbGateway.Find(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.Search(Convert.ToInt32(ASqlDataReader["centerId"])).Name; viewHistories.Add(aViewHistory); } ASqlDataReader.Close(); ASqlConnection.Close(); return(viewHistories); }