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)); } }