protected void btnCreate_Click(object sender, EventArgs e) { int idgdv = int.Parse(Request.Cookies["MaGDV"].Value); NewsDTO news = new NewsDTO(); news.Title = txtTitle.Text; news.LinkImages = txtLinkImage.Text; news.Brief = txtBrief.Text; news.Contents = txtContents.Text; news.DateCreated = DateTime.Now; news.DateModified = DateTime.Now; news.ID_GDVPost = idgdv; news.ID_GDVEdit = idgdv; int[] aSelected = listBoxType.GetSelectedIndices(); String type = ""; for (int i = 0; i < aSelected.Length; i++) { string value = listBoxType.Items[aSelected[i]].Value; type += value; if (i != aSelected.Length - 1) type += ", "; } news.ID_Types = type; lblStatus.Text = ""; if (newsDao.CreateNew(news)) { SaveLogTracking(idgdv,gdv.LayTenTheoMa(idgdv)+" viết bài: "+ txtTitle.Text, "Blogs"); Response.Write("<script> window.parent.closeDialog(); </script>"); Response.Write("<script> window.parent.Refresh();</script>"); } else lblStatus.Text = "Create Error"; }
public bool CreateNew(NewsDTO news) { string sql = "sp_News_Create"; List<SqlParameter> list = new List<SqlParameter>(); //list.Add(new SqlParameter("@ID_News", news.ID_News)); list.Add(new SqlParameter("@Title", news.Title)); list.Add(new SqlParameter("@LinkImages", news.LinkImages)); list.Add(new SqlParameter("@DateCreated", news.DateCreated)); list.Add(new SqlParameter("@DateModified", news.DateModified)); list.Add(new SqlParameter("@Brief", news.Brief)); list.Add(new SqlParameter("@Contents", news.Contents)); list.Add(new SqlParameter("@ID_GDVPost", news.ID_GDVPost)); list.Add(new SqlParameter("@ID_GDVEdit", news.ID_GDVEdit)); list.Add(new SqlParameter("@ID_Types", news.ID_Types)); bool kq = SqlDataAcessHelper.exNonStoreParas(sql, list); return kq; }
public NewsDTO GetNews(int ID_News) { string sql = "sp_News_Get_ID"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@ID_News", ID_News)); DataTable dt = SqlDataAcessHelper.exStoreParas(sql, list); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; NewsDTO news = new NewsDTO(); news.ID_News = (int)row["ID_News"]; news.Title = row["Title"].ToString(); news.LinkImages = row["LinkImages"].ToString(); news.Views = (int)row["Views"]; news.Hot = (int)row["Hot"]; news.Brief = row["Brief"].ToString(); news.Contents = row["Contents"].ToString(); var dateCreate = row["DateCreated"]; if (dateCreate.ToString() != "") news.DateCreated = (DateTime)row["DateCreated"]; var date = row["DateModified"]; if (date.ToString() != "") news.DateModified = (DateTime)row["DateModified"]; news.ID_GDVPost = (int)row["ID_GDVPost"]; news.Ten_GDVPost = row["Ten_GDVPost"].ToString(); news.ID_GDVEdit = (int)row["ID_GDVEdit"]; news.Ten_GDVEdit = row["Ten_GDVEdit"].ToString(); news.ID_Types = (String)row["ID_Types"]; return news; } else return null; }