Example #1
0
        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);
        }
Example #2
0
        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);
        }