public virtual int Add(NewsItem item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("News_AddItem"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("@Title", System.Data.SqlDbType.NVarChar,255).Value = item.Title;
sp.Params.Add("@ImageFile", System.Data.SqlDbType.VarBinary).Value = item.ImageFile;
sp.Params.Add("@Notice", System.Data.SqlDbType.NVarChar, 1024).Value = item.Notice;
sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text;
sp.Params.Add("@LinkUrl", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.LinkUrl);
sp.Params.Add("@LinkText", System.Data.SqlDbType.NVarChar, 255).Value = item.LinkText;
sp.Params.Add("@Link2Url", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.Link2Url);
sp.Params.Add("@Link2Text", System.Data.SqlDbType.NVarChar, 255).Value = item.Link2Text;
sp.Params.Add("@ImagePosition", System.Data.SqlDbType.Int).Value = item.ImagePosition;
sp.Params.Add("@IsActive", System.Data.SqlDbType.Bit).Value = item.IsActive;
sp.Params.Add("@IsMain", System.Data.SqlDbType.Bit).Value = item.IsMain;
sp.Params.Add("@Date", System.Data.SqlDbType.DateTime).Value = item.Date;
sp.Params.Add("@OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public bool DeleteGroup(NewsItem item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("News_DeleteGroup"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public virtual List<NewsItem> GetAll(string language)
{
List<NewsItem> all = new List<NewsItem>();
using (StoredProcedure sp = new StoredProcedure("News_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
NewsItem item = new NewsItem();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Title = Convert.ToString(r["Title"]);
item.Notice = Convert.ToString(r["Notice"]);
item.Text = Convert.ToString(r["Text"]);
item.LinkUrl = Convert.ToString(r["LinkUrl"]);
item.LinkText = Convert.ToString(r["LinkText"]);
item.Link2Url = Convert.ToString(r["Link2Url"]);
item.Link2Text = Convert.ToString(r["Link2Text"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.IsActive = Convert.ToBoolean(r["IsActive"]);
item.IsMain = Convert.ToBoolean(r["IsMain"]);
item.ImagePosition = Convert.ToInt32(r["ImagePosition"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.DateCreated = Convert.ToDateTime(r["DateCreated"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual bool Update(NewsItem item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("News_UpdateItem"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("@Title", System.Data.SqlDbType.NVarChar, 255).Value = item.Title;
sp.Params.Add("@Notice", System.Data.SqlDbType.NVarChar, 1024).Value = item.Notice;
sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text;
sp.Params.Add("@LinkUrl", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.LinkUrl);
sp.Params.Add("@LinkText", System.Data.SqlDbType.NVarChar, 255).Value = item.LinkText;
sp.Params.Add("@Link2Url", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.Link2Url);
sp.Params.Add("@Link2Text", System.Data.SqlDbType.NVarChar, 255).Value = item.Link2Text;
sp.Params.Add("@ImagePosition", System.Data.SqlDbType.Int).Value = item.ImagePosition;
sp.Params.Add("@IsActive", System.Data.SqlDbType.Bit).Value = item.IsActive;
sp.Params.Add("@IsMain", System.Data.SqlDbType.Bit).Value = item.IsMain;
sp.Params.Add("@Date", System.Data.SqlDbType.DateTime).Value = item.Date;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public virtual List<NewsItem> GetTitlesByLangForPageTopN(string langCode, int pageID, int count, bool skipMain)
{
List<NewsItem> all = new List<NewsItem>();
using (StoredProcedure sp = new StoredProcedure("News_GetTitlesByLangForPageTopN"))
{
sp.Params.Add("@Top", System.Data.SqlDbType.Int).Value = count;
sp.Params.Add("@PageID", System.Data.SqlDbType.Int).Value = pageID;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = langCode;
sp.Params.Add("@SkipMain", System.Data.SqlDbType.Bit).Value = skipMain;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
NewsItem item = new NewsItem();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.Title = Convert.ToString(r["Title"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual NewsItem GetMainByLang(string langCode)
{
NewsItem item = null;
using (StoredProcedure sp = new StoredProcedure("News_GetMainByLang"))
{
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = langCode;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new NewsItem();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Title = Convert.ToString(r["Title"]);
item.Notice = Convert.ToString(r["Notice"]);
item.Text = Convert.ToString(r["Text"]);
item.LinkUrl = Convert.ToString(r["LinkUrl"]);
item.LinkText = Convert.ToString(r["LinkText"]);
item.Link2Url = Convert.ToString(r["Link2Url"]);
item.Link2Text = Convert.ToString(r["Link2Text"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.HasImage = Convert.ToBoolean(r["HasImage"]);
item.IsActive = Convert.ToBoolean(r["IsActive"]);
item.IsMain = Convert.ToBoolean(r["IsMain"]);
item.ImagePosition = Convert.ToInt32(r["ImagePosition"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.DateCreated = Convert.ToDateTime(r["DateCreated"]);
}
}
}
return item;
}
public virtual List<NewsItem> GetByLangForSection(string langCode, int sectionID)
{
List<NewsItem> all = new List<NewsItem>();
using (StoredProcedure sp = new StoredProcedure("News_GetByLangForSection"))
{
sp.Params.Add("@SectionID", System.Data.SqlDbType.Int).Value = sectionID;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = langCode;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
NewsItem item = new NewsItem();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Title = Convert.ToString(r["Title"]);
item.Notice = Convert.ToString(r["Notice"]);
item.Text = Convert.ToString(r["Text"]);
item.LinkUrl = Convert.ToString(r["LinkUrl"]);
item.LinkText = Convert.ToString(r["LinkText"]);
item.Link2Url = Convert.ToString(r["Link2Url"]);
item.Link2Text = Convert.ToString(r["Link2Text"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.IsActive = Convert.ToBoolean(r["IsActive"]);
item.IsMain = Convert.ToBoolean(r["IsMain"]);
item.ImagePosition = Convert.ToInt32(r["ImagePosition"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.DateCreated = Convert.ToDateTime(r["DateCreated"]);
all.Add(item);
}
}
}
}
return all;
}