public static int AddNews(NewsDetail objNewsDetail)
{
objNewsDetail.IndTitleEncrypt = SQL.BLL.EncryptData(objNewsDetail.IndTitle);
objNewsDetail.PostDate = DateTime.Now;
objNewsDetail.Author = Convert.ToString(HttpContext.Current.Session["LoginName"]);
return UpdateNewsData(objNewsDetail);
}
public static int UpdateNewsData(NewsDetail objNewsDetail)
{
string strConnectionStrings = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString;
SqlParameter[] oParam = new SqlParameter[14];
oParam[0] = DBHelper.GetParam("@Id", SqlDbType.Int, 4, ParameterDirection.Input, objNewsDetail.Id);
oParam[1] = DBHelper.GetParam("@IndTitleEncrypt", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.IndTitleEncrypt);
oParam[2] = DBHelper.GetParam("@EngTitle", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.EngTitle);
oParam[3] = DBHelper.GetParam("@EngURLAlias", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.EngURLAlias);
oParam[4] = DBHelper.GetParam("@EngContent", SqlDbType.VarChar, 4000, ParameterDirection.Input, objNewsDetail.EngContent);
oParam[5] = DBHelper.GetParam("@IndTitle", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.IndTitle);
oParam[6] = DBHelper.GetParam("@IndURLAlias", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.IndURLAlias);
oParam[7] = DBHelper.GetParam("@IndContent", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.IndContent);
oParam[8] = DBHelper.GetParam("@Author", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.Author);
oParam[9] = DBHelper.GetParam("@IsSchedule", SqlDbType.Int, 10, ParameterDirection.Input, objNewsDetail.IsSchedule);
oParam[10] = DBHelper.GetParam("@PostDate", SqlDbType.DateTime, 100, ParameterDirection.Input, objNewsDetail.PostDate);
oParam[11] = DBHelper.GetParam("@ImageUrl", SqlDbType.VarChar, 255, ParameterDirection.Input, objNewsDetail.ImageURL);
oParam[12] = DBHelper.GetParam("@IsOnline", SqlDbType.Int, 10, ParameterDirection.Input, objNewsDetail.IsOnline);
oParam[13] = DBHelper.GetParam("@Count", SqlDbType.Int, 10, ParameterDirection.Input, objNewsDetail.Count);
SqlHelper.ExecuteNonQuery(strConnectionStrings, CommandType.StoredProcedure, "USP_AddUpdateNewsData", oParam);
return 1;
}
public static NewsDetail GetNewsData(int NewsId)
{
NewsDetail objNewsDetail = new NewsDetail();
DataTable objmainDT = new DataTable();
DataRow[] objMainRow = null;
if (NewsId != -1)
{
objmainDT = (DataTable)HttpContext.Current.Session["NewsData"];
objMainRow = objmainDT.Select("id=" + NewsId);
}
objNewsDetail.EngTitle = NewsId != -1 ? objMainRow[0]["en_alias"].ToString() : "";
objNewsDetail.EngURLAlias = NewsId != -1 ? objMainRow[0]["en_judul"].ToString() : "";
objNewsDetail.EngContent = NewsId != -1 ? objMainRow[0]["en_isi"].ToString() : "";
objNewsDetail.IndTitle = NewsId != -1 ? objMainRow[0]["alias"].ToString() : "";
objNewsDetail.IndURLAlias = NewsId != -1 ? objMainRow[0]["judul"].ToString() : "";
objNewsDetail.IndContent = NewsId != -1 ? "../" + objMainRow[0]["isi"].ToString() : "";
objNewsDetail.ImageURL = NewsId != -1 ? "../" + objMainRow[0]["gambar"].ToString() : "";
return objNewsDetail;
}
