private static void AddPartnerContent(ref PartnerContent defaultContent, DataRow row) { if(!row.IsNull("description")) defaultContent.Description = row.ReadNullableTrimmedString("description"); if (!row.IsNull("title")) defaultContent.Title = row.ReadNullableTrimmedString("title"); if (!row.IsNull("keywords")) defaultContent.Keywords = row.ReadNullableTrimmedString("keywords"); if (!row.IsNull("footer")) defaultContent.Footer = row.ReadNullableTrimmedString("footer"); if (!row.IsNull("header")) defaultContent.Header = row.ReadNullableTrimmedString("header"); if (!row.IsNull("background_image_name")) defaultContent.ImageName = row.ReadNullableTrimmedString("background_image_name"); if (!row.IsNull("partner_id")) defaultContent.PartnerId = row.ReadInt("partner_id"); if (!row.IsNull("partner_user_id")) defaultContent.UserId = row.ReadInt("partner_user_id"); }
public static PartnerContent GetPartnerContent(string lang) { //current domain try { var domain = "excursions.ru-kipr.ru"; //domain = HttpContext.Current.Request.Url.Host; //current page //current language var query = " SELECT partner_id, partner_user_id, header, footer, " + " background_image_name, title, keywords, description " + " FROM guestservice_partner_data, guestservice_partner_links " + " WHERE partner_domain = @domain and user_id = partner_user_id and lang_code = @lang and special_for_page = @page"; var partnerContent = new PartnerContent(); var res = DatabaseOperationProvider.Query(query, "content", new { lang = lang, domain = domain, page = "" }); if (res.Tables["content"].Rows.Count > 0) { AddPartnerContent(ref partnerContent, res.Tables["content"].Rows[0]); } res = DatabaseOperationProvider.Query(query, "content", new { lang = lang, domain = domain, page = HttpContext.Current.Request.Url.AbsolutePath }); if (res.Tables["content"].Rows.Count > 0) { AddPartnerContent(ref partnerContent, res.Tables["content"].Rows[0]); } return(partnerContent); } catch (Exception ex) { return(new Data.PartnerContent()); } }
private static void AddPartnerContent(ref PartnerContent defaultContent, DataRow row) { if (!row.IsNull("description")) { defaultContent.Description = row.ReadNullableTrimmedString("description"); } if (!row.IsNull("title")) { defaultContent.Title = row.ReadNullableTrimmedString("title"); } if (!row.IsNull("keywords")) { defaultContent.Keywords = row.ReadNullableTrimmedString("keywords"); } if (!row.IsNull("footer")) { defaultContent.Footer = row.ReadNullableTrimmedString("footer"); } if (!row.IsNull("header")) { defaultContent.Header = row.ReadNullableTrimmedString("header"); } if (!row.IsNull("background_image_name")) { defaultContent.ImageName = row.ReadNullableTrimmedString("background_image_name"); } if (!row.IsNull("partner_id")) { defaultContent.PartnerId = row.ReadInt("partner_id"); } if (!row.IsNull("partner_user_id")) { defaultContent.UserId = row.ReadInt("partner_user_id"); } }
public static PartnerContent GetPartnerContent(string lang) { //current domain try { var domain = "excursions.ru-kipr.ru"; //domain = HttpContext.Current.Request.Url.Host; //current page //current language var query = " SELECT partner_id, partner_user_id, header, footer, " + " background_image_name, title, keywords, description " + " FROM guestservice_partner_data, guestservice_partner_links " + " WHERE partner_domain = @domain and user_id = partner_user_id and lang_code = @lang and special_for_page = @page"; var partnerContent = new PartnerContent(); var res = DatabaseOperationProvider.Query(query, "content", new { lang = lang, domain = domain, page = "" }); if (res.Tables["content"].Rows.Count > 0) AddPartnerContent(ref partnerContent, res.Tables["content"].Rows[0]); res = DatabaseOperationProvider.Query(query, "content", new { lang = lang, domain = domain, page = HttpContext.Current.Request.Url.AbsolutePath }); if (res.Tables["content"].Rows.Count > 0) AddPartnerContent(ref partnerContent, res.Tables["content"].Rows[0]); return partnerContent; } catch (Exception ex) { return new Data.PartnerContent(); } }