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