public List <PartnerProfilesLatest> ExpressInterestSelectDal(DashboardRequest Dreq) { List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>(); SqlDataReader reader; SqlConnection connection = null; try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@custId", SqlDbType.Int); parm[0].Value = Dreq.IntCustID; parm[1] = new SqlParameter("@typeofData", SqlDbType.VarChar); parm[1].Value = Dreq.TypeOfReport; parm[2] = new SqlParameter("@yourFilter", SqlDbType.VarChar); parm[2].Value = Dreq.yourFilter; parm[3] = new SqlParameter("@oppfilter", SqlDbType.VarChar); parm[3].Value = Dreq.oppfilter; parm[4] = new SqlParameter("@pagefrom", SqlDbType.Int); parm[4].Value = Dreq.pagefrom; parm[5] = new SqlParameter("@pageto", SqlDbType.Int); parm[5].Value = Dreq.pageto; using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { connection.Open(); reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, "[dbo].[usp_select_customerDashboard_ExpressInterest]", parm); if (reader.HasRows) { while (reader.Read()) { PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "ExpressInterest"); PartnerLi.Add(Partnercls); } } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog("[dbo].[usp_select_customerDashboard_ExpressInterest]", Convert.ToString(ex.Message), Dreq.IntCustID, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(PartnerLi); }
public DashboardClass GetPartnerProfilesDal(int?CustID, string TypeOfReport, int pagefrom, int pageto, string spName) { DashboardClass land = new DashboardClass(); List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>(); SqlDataReader reader; SqlConnection con = null; try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@custID", SqlDbType.Int); parm[0].Value = CustID; parm[1] = new SqlParameter("@TypeOfReport", SqlDbType.VarChar); parm[1].Value = TypeOfReport; parm[2] = new SqlParameter("@pagefrom", SqlDbType.Int); parm[2].Value = pagefrom; parm[3] = new SqlParameter("@pageto", SqlDbType.Int); parm[3].Value = pageto; using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { con.Open(); reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "Partner"); PartnerLi.Add(Partnercls); } land.PartnerProfilesnew = PartnerLi; } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), CustID, null, null); } finally { con.Close(); //SqlConnection.ClearPool(con); //SqlConnection.ClearAllPools(); } return(land); }
public PartnerProfilesLatest ReturnPartnerProfilesClass(SqlDataReader reader, string Type) { int? inull = null; bool? bnull = null; DateTime?dnull = null; Int64? Lnull = null; PartnerProfilesLatest Partnercls = new PartnerProfilesLatest(); Partnercls.Row = reader["Row"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Row")) : inull; Partnercls.TableName = reader["TableName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TableName")) : null; Partnercls.ProfileID = reader["ProfileID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null; Partnercls.Cust_ID = reader["Cust_ID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_ID")) : Lnull; Partnercls.intCusID = reader["Cust_ID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_ID")) : Lnull; Partnercls.NAME = reader["NAME"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null; Partnercls.LastName = reader["LastName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("LastName")) : null; Partnercls.DateOfBirth = reader["DateOfBirth"] != DBNull.Value ? (reader.GetString(reader.GetOrdinal("DateOfBirth"))) : null; Partnercls.Age = reader["Age"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Age")) : inull; Partnercls.Height = reader["Height"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Height")) : null; Partnercls.ReligionName = reader["ReligionName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReligionName")) : null; Partnercls.Caste = reader["Caste"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Caste")) : null; Partnercls.Education = reader["Education"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Education")) : null; Partnercls.EducationGroup = reader["EducationGroup"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EducationGroup")) : null; Partnercls.profession = reader["profession"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("profession")) : null; Partnercls.Profession = reader["profession"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("profession")) : null; Partnercls.PhoneNumber = reader["PhoneNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("PhoneNumber")) : null; Partnercls.Email = reader["Email"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : null; Partnercls.Star = reader["Star"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Star")) : null; Partnercls.placeofbirth = reader["placeofbirth"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("placeofbirth")) : null; Partnercls.Location = reader["Location"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Location")) : null; Partnercls.HoroscopeImage = reader["HoroscopeImage"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("HoroscopeImage")) : null; Partnercls.PhotosCount = reader["PhotosCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotosCount")) : inull; Partnercls.PhotoCount = reader["PhotosCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotosCount")) : inull; Partnercls.Photoname = reader["Photoname"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photoname")) : null; Partnercls.mybookmarked = reader["mybookmarked"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("mybookmarked")) : bnull; Partnercls.recentlyviewes = reader["recentlyviewes"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("recentlyviewes")) : bnull; Partnercls.ignode = reader["ignode"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ignode")) : bnull; Partnercls.TotalRows = reader["TotalRows"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalRows")) : inull; Partnercls.ExpressFlag = reader["ExpressFlag"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ExpressFlag")) : bnull; Partnercls.IsPaidMember = reader["IsPaidMember"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IsPaidMember")) : inull; Partnercls.iGenderID = reader["iGenderID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iGenderID")) : inull; Partnercls.iCasteID = reader["iCasteID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iCasteID")) : inull; Partnercls.iStarID = reader["iStarID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iStarID")) : inull; Partnercls.iCountryID = reader["iCountryID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iCountryID")) : inull; Partnercls.iReligionID = reader["iReligionID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iReligionID")) : inull; Partnercls.iProfessionGroupID = reader["iProfessionGroupID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iProfessionGroupID")) : inull; Partnercls.ProfessionID = reader["ProfessionID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ProfessionID")) : inull; Partnercls.iEducationGroupID = reader["iEducationGroupID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iEducationGroupID")) : inull; Partnercls.iHeightInCentimeters = reader["iHeightInCentimeters"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iHeightInCentimeters")) : inull; Partnercls.iStarLanguageID = reader["iStarLanguageID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iStarLanguageID")) : inull; Partnercls.iCityID = reader["iCityID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iCityID")) : inull; Partnercls.iStateID = reader["iStateID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("iStateID")) : inull; Partnercls.MaritalStatusID = reader["MaritalStatusID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MaritalStatusID")) : inull; Partnercls.MaritualStatus = reader["MaritualStatus"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MaritualStatus")) : null; Partnercls.Photo = reader["Photo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null; Partnercls.DescribeYourSelf = reader["DescribeYourSelf"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("DescribeYourSelf")) : null; Partnercls.DistName = reader["DistName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("DistName")) : null; if (Type == "ExpressInterest") { Partnercls.ServiceGivenBanch = reader["ServiceGivenBanch"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ServiceGivenBanch")) : null; Partnercls.SuggestEmpName = reader["SuggestEmpName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("SuggestEmpName")) : null; Partnercls.SuggestedEmpNumber = reader["SuggestedEmpNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("SuggestedEmpNumber")) : null; Partnercls.SuggestionFlag = reader["SuggestionFlag"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SuggestionFlag")) : inull; Partnercls.NewCount = reader["NewCount"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("NewCount")) : Lnull; Partnercls.AcceptCount = reader["AcceptCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AcceptCount")) : inull; Partnercls.RejectCount = reader["RejectCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("RejectCount")) : inull; Partnercls.RelationShipManagerName = reader["RelationShipManagerName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RelationShipManagerName")) : null; Partnercls.RelationShipManagerNumber = reader["RelationShipManagerNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RelationShipManagerNumber")) : null; Partnercls.LogID = reader["LogID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("LogID")) : Lnull; Partnercls.LogId = reader["LogID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("LogID")) : Lnull; Partnercls.RelationShipManagerEmail = reader["RelationShipManagerEmail"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RelationShipManagerEmail")) : null; Partnercls.Mystatus = reader["Mystatus"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Mystatus")) : null; Partnercls.OppStatus = reader["OppStatus"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("OppStatus")) : null; Partnercls.TicketID = reader["TicketID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("TicketID")) : Lnull; Partnercls.CreatedDate = reader["CreatedDate"] != DBNull.Value ? reader.GetDateTime(reader.GetOrdinal("CreatedDate")) : dnull; Partnercls.CommunicationHistoryFlag = reader["CommunicationHistoryFlag"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CommunicationHistoryFlag")) : inull; Partnercls.YouProceed = reader["YouProceed"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("YouProceed")) : inull; Partnercls.Youskipped = reader["Youskipped"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Youskipped")) : inull; Partnercls.YouPending = reader["YouPending"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("YouPending")) : inull; Partnercls.OppProceed = reader["OppProceed"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("OppProceed")) : inull; Partnercls.Oppskipped = reader["Oppskipped"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Oppskipped")) : inull; Partnercls.Opppending = reader["Opppending"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Opppending")) : inull; } else { Partnercls.RequestDate = reader["RequestDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RequestDate")) : null; } // SqlConnection.ClearAllPools(); return(Partnercls); }
public DashboardClass LandingCountsDal(int?CustID, string TypeOfReport, int pagefrom, int pageto, string spName) { DashboardClass land = new DashboardClass(); List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>(); SqlDataReader reader; DataSet ds = new DataSet(); DataTable dt = new DataTable(); int? inull = null; bool? bnull = null; SqlConnection con = null; Int64? Lnull = null; List <PersonalInfo> liPerson = new List <PersonalInfo>(); try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@custID", SqlDbType.Int); parm[0].Value = CustID; parm[1] = new SqlParameter("@TypeOfReport", SqlDbType.VarChar); parm[1].Value = TypeOfReport; parm[2] = new SqlParameter("@pagefrom", SqlDbType.Int); parm[2].Value = pagefrom; parm[3] = new SqlParameter("@pageto", SqlDbType.Int); parm[3].Value = pageto; using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { con.Open(); reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { LandingPartnerMenu liCount = new LandingPartnerMenu(); { liCount.SaveSearchCount = reader["SavesSearchCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SavesSearchCount")) : inull; liCount.WhobookmarkedCount = reader["WhoBookmarkedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoBookmarkedCount")) : inull; liCount.MybookMarkedProfCount = reader["BookmarkCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("BookmarkCount")) : inull; liCount.RectViewedProfCount = reader["ViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ViewedCount")) : inull; liCount.RectWhoViewedCout = reader["WhoViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoViewedCount")) : inull; liCount.IgnoreProfileCount = reader["IgnoreCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IgnoreCount")) : inull; //express and Counts Bind liCount.ExpressIntSent = reader["ExpressSentCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressSentCount")) : inull; liCount.ExpressIntReceived = reader["ExpressReceiveCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressReceiveCount")) : inull; liCount.ExpressAllcount = reader["ExpressAllcount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressAllcount")) : inull; liCount.NewMsgs = reader["NewMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("NewMessageCount")) : inull; liCount.TotalMsgs = reader["TotalMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalMessageCount")) : inull; liCount.SentPhotoRequestCount = reader["PhotoRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestSentCount"))) : inull; liCount.SentHoroRequestCount = reader["HoroRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestSentCount"))) : inull; liCount.ReceivedPhotoRequestCount = reader["PhotoRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestReceivedCount"))) : inull; liCount.ReceivedHoroRequestCount = reader["HoroRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestReceivedCount"))) : inull; liCount.SentProtectedReply = reader["SentProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedNewCount"))) : inull; liCount.SentProtectedAccept = reader["SentProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedAcceptCount"))) : inull; liCount.SentProtectedReject = reader["SentProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedRejectCount"))) : inull; liCount.ReceivedProtectedNew = reader["ReceivedProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedNewCount"))) : inull; liCount.ReceivedProtectedAccept = reader["ReceivedProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedAcceptCount"))) : inull; liCount.ReceivedProtectedReject = reader["ReceivedProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedRejectCount"))) : inull; land.DashBoardCounts = liCount; } } } reader.NextResult(); if (reader.HasRows) { while (reader.Read()) { PersonalInfo Pcls = new PersonalInfo(); Pcls.TableName = reader["TableName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TableName")) : null; Pcls.ProfileID = reader["ProfileID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null; Pcls.GenderID = reader["GenderID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : inull; Pcls.NAME = reader["NAME"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null; Pcls.PaidMember = reader["PaidMember"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidMember")) : inull; Pcls.ProfileLastModifieddate = reader["ProfileLastModifieddate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("ProfileLastModifieddate"))).ToString() : null; Pcls.PhotoName = reader["PhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("PhotoName")) : null; Pcls.PhotoName_Cust = reader["PhotoName_Cust"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoName_Cust")) : inull; Pcls.MsgReceivedFrom = reader["MsgReceivedFrom"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MsgReceivedFrom")) : null; Pcls.MsgReceivedDate = reader["MsgReceivedDate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("MsgReceivedDate"))).ToString() : null; Pcls.ProfilePhotoName = reader["ProfilePhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePhotoName")) : null; Pcls.IsReviewed = reader["IsReviewed"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsReviewed")) : bnull; Pcls.IsActive = reader["IsActive"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsActive")) : bnull; Pcls.ProfileBattery = reader["ProfileBattery"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ProfileBattery")) : inull; Pcls.EmpID = reader["EmpID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("EmpID")) : Lnull; Pcls.EmpPhone = reader["EmpPhone"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmpPhone")) : null; Pcls.OfficialContactNumber = reader["OfficialContactNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("OfficialContactNumber")) : null; Pcls.EmployeeName = reader["EmployeeName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmployeeName")) : null; Pcls.EmailID = reader["EmailID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmailID")) : null; Pcls.PhotoViewCount = reader["PhotoViewCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoViewCount")) : inull; Pcls.PartnetPrefernceLastOnemonth = reader["PartnetPrefernceLastOnemonth"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PartnetPrefernceLastOnemonth")) : inull; Pcls.Photo = reader["Photo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null; Pcls.MaskDiv = (!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true && Pcls.IsActive == true)) ? " " : ((!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true || Pcls.IsActive == true)) ? "divCSSclass clearfix" : "cssMaskupload clearfix"); land.PersonalInfo = Pcls; } } reader.NextResult(); if (reader.HasRows) { while (reader.Read()) { PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "Partner"); PartnerLi.Add(Partnercls); } land.PartnerProfilesnew = PartnerLi; } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), CustID, null, null); } finally { con.Close(); //SqlConnection.ClearPool(con); //SqlConnection.ClearAllPools(); } return(land); }