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