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