public int AddEditDel_NewsListing(DO_Scrl_UserNewsListing objcategory, NewsListing flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_NewsListing", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
//cmd.Parameters.Add("@intBlogId", SqlDbType.Int).Value = objBlog.intBlogId;
cmd.Parameters.Add("@strTitle", SqlDbType.VarChar, 200).Value = objcategory.Title;
cmd.Parameters.Add("@strType", SqlDbType.VarChar, 100).Value = objcategory.Type;
cmd.Parameters.Add("@strLink", SqlDbType.VarChar, 200).Value = objcategory.Source_link;
cmd.Parameters.Add("@strContent", SqlDbType.VarChar, 100000000).Value = objcategory.Content;
//cmd.Parameters.Add("@strBlogPicture", SqlDbType.VarChar, 100).Value = objBlog.strBlogPicture;
//cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objBlog.intAddedBy;
//cmd.Parameters.Add("@strIPAddress", SqlDbType.VarChar, 20).Value = objBlog.strIPAddress;
//cmd.Parameters.Add("@intSubjectCategoryId", SqlDbType.Int).Value = objBlog.intSubjectCategoryId;
//cmd.Parameters.Add("@intModifiedBy", SqlDbType.VarChar, 200).Value = objBlog.intModifiedBy;
//cmd.ExecuteReader();
objcategory.intNewsOutId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
return(objcategory.intNewsOutId);
}
public void DelByID_RssListing(DO_Scrl_UserNewsListing objcategory, NewsListing flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_NewsListing", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = objcategory.ID;
cmd.ExecuteReader();
co.CloseConnection(conn);
}
public void Edit_RssListing(DO_Scrl_UserNewsListing objcategory, NewsListing flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_NewsListing", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = objcategory.ID;
cmd.Parameters.Add("@strTitle", SqlDbType.VarChar, 2000).Value = objcategory.Title;
cmd.Parameters.Add("@strLink", SqlDbType.VarChar, 200).Value = objcategory.Source_link;
cmd.ExecuteReader();
co.CloseConnection(conn);
}
public int Add_RssListing(DO_Scrl_UserNewsListing objcategory, NewsListing flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_NewsListing", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@strTitle", SqlDbType.VarChar, 2000).Value = objcategory.Title;
cmd.Parameters.Add("@strLink", SqlDbType.VarChar, 200).Value = objcategory.Source_link;
//cmd.Parameters.Add("@strContent", SqlDbType.VarChar, 100000000).Value = objcategory.Content;
//cmd.Parameters.Add("@publishTimestamp", SqlDbType.DateTime).Value = objcategory.Published_Timestamp;
objcategory.intNewsOutId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
return(objcategory.intNewsOutId);
}
public DataTable GetNewsDataTable(DO_Scrl_UserNewsListing objcategory, NewsListing flag)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_NewsListing", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
//da.SelectCommand.Parameters.Add("@CurrentPage", SqlDbType.Int).Value = objcategory.CurrentPage;
//da.SelectCommand.Parameters.Add("@PageSize", SqlDbType.Int).Value = objcategory.CurrentPageSize;
//if (Convert.ToString(objcategory.ID) != "")
//{
// da.SelectCommand.Parameters.Add("@ID", SqlDbType.Int).Value = objcategory.ID;
//}
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
