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