public List <blogModel> getUsersBlogList(blogModel blogParams)
{
using (DAL db = new DAL())
{
List <blogModel> lsblog = new List <blogModel>();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_GetUsersBlogList";
cmd.Parameters.AddWithValue("@showOnHomePage", Convert.ToBoolean(blogParams.onHomePage));
DataSet ds = db.ReturnDataset(cmd);
foreach (DataRow item in ds.Tables[0].Rows)
{
blogModel data = new blogModel();
lsblog.Add(data);
}
return(lsblog);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static int Editblog(int num, string heading, string body)
{
blogModel data = new blogModel
{
num = num,
heading = heading,
body = body
};
string sql = "update dbo.BlogData set heading='" + data.heading + "',body='" + data.body + "' where num=" + data.num + ";";
return(SqlDataAccess.EditData <blogModel>(sql));
}
public static int Createblog(int num, string heading, string body)
{
blogModel data = new blogModel
{
num = num,
heading = heading,
body = body
};
string sql = "insert into dbo.BlogData (num,heading,body) values (" + data.num + ",'" + data.heading + "','" + data.body + "');";
return(SqlDataAccess.SaveData <blogModel>(sql));
}
public BlogModel GetBlogById(int id)
{
blogModel data = LoadBlog(id);
BlogModel blog = new BlogModel
{
ID = data.num,
BlogHeader = data.heading,
BlogBody = data.body
};
return(blog);
}
public ActionResult createBlog(int?id, blogModel AddBlog)
{
var blog = _context.blogs.Find(id);
//if (blog != null)
//{
// System.Diagnostics.Debug.WriteLine("update function");
//}
//else
//{
// System.Diagnostics.Debug.WriteLine("date function");
// _context.blogs.Add(AddBlog);
// System.Diagnostics.Debug.WriteLine("Done");
//}
return(View(blog));
}
public ActionResult Save(blogModel blogm)
{
var blog = _context.blogs.Find(blogm.blogId);
if (blog != null)
{
blog.blogTitle = blogm.blogTitle;
blog.blogText = blogm.blogText;
System.Diagnostics.Debug.WriteLine("update function", blogm.blogId);
System.Diagnostics.Debug.WriteLine("id dd", blogm.blogId);
}
else
{
System.Diagnostics.Debug.WriteLine("date function");
_context.blogs.Add(blogm);
System.Diagnostics.Debug.WriteLine("Done");
}
_context.SaveChanges();
return(RedirectToAction("blogView", "blog"));
}
public List <blogModel> getAdminBlogsList()
{
using (DAL db = new DAL())
{
List <blogModel> lsblog = new List <blogModel>();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_GetAdminBlogsList";
DataSet ds = db.ReturnDataset(cmd);
foreach (DataRow item in ds.Tables[0].Rows)
{
blogModel data = new blogModel();
lsblog.Add(data);
}
return(lsblog);
}
catch (Exception ex)
{
throw ex;
}
}
}
