public HomePage(ResultObject result_object) { result_object.ipAddress = Dns.GetHostByName(Dns.GetHostName()).AddressList[0].ToString(); _contact = _homePageContactAction_BL.GetList(null, "", 1, result_object).FirstOrDefault(); CategoryList = _categoryActionAction_BL.GetList(null, "", 1, result_object); HomePageContentList = _homePageContentAction_BL.GetList(null, "", 1, result_object); _page = _pageAction_BL.GetBanners(1, null, "", 1, result_object).FirstOrDefault(); HomePageFooterList = _homePageFooterAction_BL.GetList(null, "", 1, result_object); }
public List <HomePageContactModel> GetList(int?home_page_contact_id, string search_text, int?status, ResultObject result_object) { List <HomePageContactModel> _homePageContacts = new List <HomePageContactModel>(); using (SqlConnection conn = new SqlConnection(conStr)) { SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); using (SqlCommand cmd = new SqlCommand("[dbo].[sp_HomePageContact_Get]", conn)) { cmd.CommandType = CommandType.StoredProcedure; if (home_page_contact_id == null) { cmd.Parameters.AddWithValue("@home_page_contact_id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@home_page_contact_id", home_page_contact_id); } if (search_text == null || search_text == "") { cmd.Parameters.AddWithValue("@search_text", DBNull.Value); } else { cmd.Parameters.AddWithValue("@search_text", search_text); } if (status == 1) { cmd.Parameters.AddWithValue("@status", 1); } else if (status == 0) { cmd.Parameters.AddWithValue("@status", 0); } else { cmd.Parameters.AddWithValue("@status", DBNull.Value); } cmd.CommandTimeout = 0; da = new SqlDataAdapter(cmd); da.Fill(ds); conn.Close(); } if (ds.Tables.Count != 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { HomePageContactModel _homePageContact = new HomePageContactModel(); _homePageContact.home_page_contact_id = Convert.ToInt32(ds.Tables[0].Rows[i]["home_page_contact_id"]); _homePageContact.address = Convert.ToString(ds.Tables[0].Rows[i]["address"]); _homePageContact.email = Convert.ToString(ds.Tables[0].Rows[i]["email"]); _homePageContact.phone = Convert.ToString(ds.Tables[0].Rows[i]["phone"]); _homePageContact.isactive = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[i]["is_active"]) == "" ? 0 : ds.Tables[0].Rows[i]["is_active"]); _homePageContacts.Add(_homePageContact); result_object.success = true; } } } return(_homePageContacts); }