public List <DonorDetailInfoForSearch> GetDonorDetail(int a, int b, int c, int d, string es, string publishStatus) { List <DonorDetailInfoForSearch> bldOrganizationInfos = null; string query = " SELECT do.Id,do.DonorName,b.BloodGroupName,do.Mobile,do.AlterMobile,do.Email,do.City,s.SubDistrictName,d.DistrictName,div.DivisionName FROM DonorInfo do JOIN DistrictInfo d ON d.Id=do.DistrictInfoId JOIN DivisionInfo div ON div.Id=do.DivisionInfoId JOIN BloodInfo b ON b.Id=do.BloodInfoId JOIN SubDistrictInfo s ON s.Id=do.SubDistrictInfoId WHERE div.Id='" + a + "' AND d.Id='" + b + "' AND b.Id='" + c + "' AND s.Id='" + d + "' AND do.AbilityToDonate='" + es + "' AND do.PublishStatus='" + publishStatus + "' "; Connection.Open(); Command = new SqlCommand(query, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { bldOrganizationInfos = new List <DonorDetailInfoForSearch>(); while (Reader.Read()) { DonorDetailInfoForSearch bldOrganizationInfo = new DonorDetailInfoForSearch { DonorId = (int)Reader["Id"], DonorName = Reader["DonorName"].ToString(), BloodGroupName = Reader["BloodGroupName"].ToString(), Mobile = Reader["Mobile"].ToString(), AlterMobile = Reader["AlterMobile"].ToString(), Email = Reader["Email"].ToString(), City = Reader["City"].ToString(), SubDistrictName = Reader["SubDistrictName"].ToString(), DistrictName = Reader["DistrictName"].ToString(), DivisionName = Reader["DivisionName"].ToString() }; bldOrganizationInfos.Add(bldOrganizationInfo); } Reader.Close(); } Connection.Close(); return(bldOrganizationInfos); }
public List <DonorDetailInfoForSearch> GetMostDonorInfo() { List <DonorDetailInfoForSearch> bldOrganizationInfos = null; string query = " SELECT do.DonorName,do.DonorType,b.BloodGroupName,do.Mobile,s.SubDistrictName,d.DistrictName,div.DivisionName,do.AbilityToDonate,do.PublishStatus FROM DonorInfo do JOIN DistrictInfo d ON d.Id=do.DistrictInfoId JOIN DivisionInfo div ON div.Id=do.DivisionInfoId JOIN BloodInfo b ON b.Id=do.BloodInfoId JOIN SubDistrictInfo s ON s.Id=do.SubDistrictInfoId "; Connection.Open(); Command = new SqlCommand(query, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { bldOrganizationInfos = new List <DonorDetailInfoForSearch>(); while (Reader.Read()) { DonorDetailInfoForSearch bldOrganizationInfo = new DonorDetailInfoForSearch { DonorName = Reader["DonorName"].ToString(), DonorType = Reader["DonorType"].ToString(), BloodGroupName = Reader["BloodGroupName"].ToString(), Mobile = Reader["Mobile"].ToString(), SubDistrictName = Reader["SubDistrictName"].ToString(), DistrictName = Reader["DistrictName"].ToString(), DivisionName = Reader["DivisionName"].ToString(), AbilityToDonate = Reader["AbilityToDonate"].ToString(), PublishStatus = Reader["PublishStatus"].ToString() }; bldOrganizationInfos.Add(bldOrganizationInfo); } Reader.Close(); } Connection.Close(); return(bldOrganizationInfos); }