public ActionResult create(summernoteNews Uploader, string datepicker)
{
try
{
string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string;
using (IDbConnection db = new SqlConnection(_connectionString))
{
summernoteNews pageVM = new summernoteNews();
//Uploader.PhotoName = fileName;
//Uploader.ModifiedDate = DateTime.Now;
var query = "InsertNews";
Uploader.PublishedDate = Convert.ToDateTime(datepicker);
var param = new DynamicParameters();
param.Add("subject", Uploader.Subject);
param.Add("discussion", Uploader.Discussion);
param.Add("publishedDate", Uploader.PublishedDate);
//param.Add("photoDetails", Uploader.PhotoDetails);
db.Query <summernoteNews>(query, param, commandType: CommandType.StoredProcedure);
return(Redirect("Index"));
}
}
catch (Exception ex)
{
return(View(ex.Message));
}
}
public ActionResult NewsDetail(int id)
{
try
{
string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string;
using (IDbConnection db = new SqlConnection(_connectionString))
{
summernoteNews pageVM = new summernoteNews();
var query = "SelectNewsById";
var param = new DynamicParameters();
param.Add("Id", id);
pageVM = db.Query <summernoteNews>(query, param, commandType: CommandType.StoredProcedure).First();
return(View(pageVM));
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public ActionResult modify(summernoteNews update)
{
try
{
string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string;
summernoteNews pageVM = new summernoteNews();
using (IDbConnection db = new SqlConnection(_connectionString))
{
//update.ModifiedDate = DateTime.Now;
var query = "ModifyNewsById";
var param = new DynamicParameters();
param.Add("id", update.Id);
param.Add("subject", update.Subject);
param.Add("discussion", update.Discussion);
param.Add("publishedDate", update.PublishedDate);
var resut = db.Query <summernoteNews>(query, param, commandType: CommandType.StoredProcedure);
}
return(Redirect("Index"));
}
catch (Exception ex)
{
return(View(ex.Message));
}
}
