// add news
public string add_news(NEWS news)
{
try
{
OracleCommand cmd = DB_Connect("add_news");
OracleParameter retVal = new OracleParameter();
retVal.OracleType = OracleType.Number;
retVal.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(retVal);
cmd.Parameters.AddWithValue("u_title", news.TITLE);
cmd.Parameters.AddWithValue("u_text", news.TEXT);
cmd.Parameters.AddWithValue("u_logoname", news.LOGO_NAME);
cmd.ExecuteNonQuery();
if (int.Parse(retVal.Value.ToString()) > 0)
{
return("News was added successfully");
}
else
{
return("Adding news was unable");
}
}
catch (Exception ex)
{
return(ex.Message);
}
finally { orcl_con.Close(); }
}
public string DeleteFile(string id)
{
Response oResponseResult = new Response();
try
{
NEWS files = this.oINewsService.oDeleteFile(Convert.ToString(id));
//this.OperationResult = oResponseResult.OperationResult;
if (files != null)
{
this.OperationResultMessages = CommonResx.MessageDeleteSuccess;
}
else
{
this.OperationResultMessages = CommonResx.MessageDeleteFailed;
}
////TODO :: Delete file from the file system
}
catch (Exception ex)
{
}
return(this.OperationResultMessages);
}
// delete news
public string delete_news(NEWS news)
{
try
{
// add return value to Oracle Command
OracleCommand cmd = DB_Connect("delete_news");
OracleParameter retVal = new OracleParameter();
retVal.OracleType = OracleType.Number;
retVal.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(retVal);
cmd.Parameters.AddWithValue("u_id", news.ID);
// execute query
cmd.ExecuteNonQuery();
// compare retVal
if (int.Parse(retVal.Value.ToString()) > 0)
{
return("News was deleted successfully");
}
else
{
return("Unable to delete news");
}
}
catch (Exception ex)
{
return(ex.Message);
}
finally { orcl_con.Close(); }
}
public ActionResult NewsInfo(int?id)
{
if (Session["login"] is null)
{
return(RedirectToAction("Login"));
}
int idRole = ((USER)Session["login"]).IdRole;
if (idRole != 1 && idRole != 2)
{
return(RedirectToAction("Index"));
}
NEWS news = new NEWS();
if (id != null)
{
using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities())
{
news = db.NEWS.Where(x => x.IdNews == id).FirstOrDefault();
if (news.IdUser != ((USER)Session["login"]).IdUser && idRole != 1)
{
return(RedirectToAction("News"));
}
if (news is null)
{
return(HttpNotFound());
}
}
}
return(View(news));
}
public ActionResult AddNews(NewsModel NewsModel)
{
var Newsdao = new NewsDao();
var News = new NEWS();
if (ModelState.IsValid)//kiem tra xem form co rong hay khong
{
News.newsTitle = NewsModel.newsTitle;
News.newsImg = NewsModel.newsImg;
News.newsContent = NewsModel.newsContent;
News.newsType = NewsModel.newsType;
long id = Newsdao.AddNews(News);
if (id < 0)
{
ModelState.AddModelError("", "Thêm thất bại");
return(RedirectToAction("AddNews", "News"));
}
else
{
ViewData["success"] = "Thêm News thành công";
}
}
return(View());
}
public ActionResult Update(NEWS entity)
{
var dao = new NewsDAO();
dao.updateNews(entity);
return(RedirectToAction("Management"));
}
/// <summary>
/// 更新新闻信息，成功返回true，失败返回false
/// </summary>
/// <param name="news">要更新的news类</param>
/// <returns>成功返回true，失败返回false</returns>
public Boolean UpdateNewsInfo(News news)
{
avfunEntities DataEntity = DataEntityManager.GetDataEntity();
Boolean result = false;
try
{
NEWS ResultNEWS = (from destNews in DataEntity.NEWS
where destNews.news_id == news.Article_id &&
destNews.news_timestamp == news.Article_timestamp
select destNews).Single();
ResultNEWS.news_title = news.Article_title;
ResultNEWS.news_id = news.Article_id;
ResultNEWS.news_content = news.Article_content;
ResultNEWS.news_isDeleted = news.Article_isDeleted;
ResultNEWS.news_isOnIndex = news.News_isOnIndex;
ResultNEWS.news_publish_date = news.Article_publish_date;
ResultNEWS.news_timestamp = news.Article_timestamp;
ResultNEWS.news_author = news.Article_author;
ResultNEWS.news_click_count = news.News_click_count;
ResultNEWS.news_image = news.News_image;
DataEntity.SaveChanges();
result = true;
}
catch
{
result = false;
}
return(result);
}
public ActionResult Insert(NEWS entity)
{
var dao = new NewsDAO();
dao.insertNews(entity);
return(RedirectToAction("Management"));
}
public static List <VotingClass> getVotingClassList(Entities e, Expression <Func <NEWS, bool> > expr, int page, int userId = 0)
{
List <NewsClass> newsList = getNewsClassList(e, expr, page);
List <VotingClass> votings = new List <VotingClass>();
foreach (var item in newsList)
{
var serializedParent = JsonConvert.SerializeObject(item);
VotingClass votingClass = JsonConvert.DeserializeObject <VotingClass>(serializedParent);
NEWS _NEWS = e.NEWS.FirstOrDefault(n => n.NEWS_ID == item.id);
votingClass.voteType = _NEWS.VOTE_TYPE;
votingClass.voteResult = _NEWS.VOTE_RESULT;
votingClass.voteCount = _NEWS.VOTE_COUNT == 1 ? true : false;
votingClass.expireDate = _NEWS.EXPIRATION_DATE;
votingClass.choices = getChoices(e, item.id, userId);
foreach (var choice in votingClass.choices)
{
votingClass.totalVotes += choice.voteCount;
}
votings.Add(votingClass);
}
return(votings);
}
/// <summary>
/// Delete news image
/// </summary>
/// <param name="oGuid"></param>
/// <returns></returns>
public NEWS oDeleteFile(string oGuid)
{
Response oResponse = new Response();
NEWS fileDetail = new NEWS();
try
{
Guid guid = new Guid(oGuid);
fileDetail = this.oTakamulConnection.NEWS.Find(guid);
if (fileDetail == null)
{
oResponse.OperationResult = enumOperationResult.Faild;
// return Json(new { Result = "Error" });
}
//Remove from database
this.oTakamulConnection.NEWS.Remove(fileDetail);
this.oTakamulConnection.SaveChanges();
}
catch (Exception Ex)
{
oResponse.OperationResult = enumOperationResult.Faild;
//TODO : Log Error Message
oResponse.OperationResultMessage = Ex.Message.ToString();
}
return(fileDetail);
}
public ActionResult Create_Promotion(FormCollection f)
{
try
{
string Content1 = f.Get("Content").ToString();
string Title = f.Get("Title").ToString();
string Description = f.Get("Description").ToString();
int Supplier_id = int.Parse(f.Get("ListSupplier").ToString());
NEWS _NEWS = new NEWS();
_NEWS.TITLE = Title;
_NEWS.CONTENT_1 = Content1;
_NEWS.CONTENT_2 = Description;
_NEWS.CREATED_DATE = DateTime.Now;
_NEWS.SUPPLIER_ID = Supplier_id;
_NEWS.IS_PROMOTION = true;
db.NEWS.Add(_NEWS);
db.SaveChanges();
List <IMAGES_UPLOAD> _lstIMAGE_UPLOAD = db.IMAGES_UPLOAD.Where(n => n.NEWS_ID == 0).ToList();
foreach (var image in _lstIMAGE_UPLOAD)
{
image.NEWS_ID = _NEWS.NEWS_ID;
}
db.SaveChanges();
TempData["SuccessCreate"] = "Thêm thành công bài viết số " + _NEWS.NEWS_ID;
return(RedirectToAction("ManagingNews", "Admin"));
}
catch (Exception ex)
{
throw ex;
}
}
static public int GetNews(GETNEWS getnews, out NEWS[] result)
{
result = null;
if (getnews.ext.nNeedLine == 0)
{
getnews.ext.nNeedLine = 10;
}
DataTable dt = CDB.GetSQLData("select top " + getnews.ext.nNeedLine + " * from tblNews where dwDate >= " + getnews.dwStartDate + " and dwDate <= " + getnews.dwEndDate + " and dwClsID=" + getnews.dwClsID);
if (dt == null)
{
return(1);
}
result = new NEWS[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
result[i] = new NEWS();
result[i].dwNewsID = (int)dt.Rows[i]["dwNewsID"];
result[i].dwDate = (int)dt.Rows[i]["dwDate"];
result[i].dwTime = (int)dt.Rows[i]["dwTime"];
result[i].dwClsID = (int)dt.Rows[i]["dwClsID"];
result[i].dwType = (int)dt.Rows[i]["dwType"];
result[i].szTitle = (string)dt.Rows[i]["szTitle"];
result[i].szContent = (string)dt.Rows[i]["szContent"];
}
return(0);
}
public ActionResult add(NewsDetails news)
{
if (ModelState.IsValid)
{
int commitCount = 0;
NEWS n = new NEWS();
n.TIL = news.newsTitle;
n.CNTNT = news.newsContent;
n.AUTH_ID = Convert.ToInt32(this.Session["UserId"]);
n.CREATED_AT = System.DateTime.Now;
try
{
db.NEWS.Add(n);
commitCount = db.SaveChanges();
if (commitCount > 0)
{
//To Do... Implement Logic to send SMS to all students who has send SMS is enabled
//SMS_SETTING s = new SMS_SETTING();
}
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex;
}
return(RedirectToAction("view", "News", new { id = n.ID }));
}
else
{
ViewBag.ErrorMessage = "Model is not valid..";
return(RedirectToAction("add"));
}
}
public ActionResult DeleteConfirmed(int id)
{
NEWS nEWS = db.NEWS.Find(id);
db.NEWS.Remove(nEWS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public NewsDetailsDataModel DoGetDetailsByID(int ID)
{
NewsDetailsDataModel result = new NewsDetailsDataModel();
NEWS data = DB.NEWS.Where(w => w.ID == ID).FirstOrDefault();
PublicMethodRepository.HtmlDecode(data);
result.Data = data;
return(result);
}
public ActionResult Edit([Bind(Include = "ID,TITLE,BODY,picture,PostTime")] NEWS nEWS)
{
if (ModelState.IsValid)
{
db.Entry(nEWS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nEWS));
}
public ActionResult Create([Bind(Include = "ID,TITLE,BODY,picture,PostTime")] NEWS nEWS)
{
if (ModelState.IsValid)
{
db.NEWS.Add(nEWS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nEWS));
}
/// <summary>
/// Insert News
/// </summary>
/// <param name="oNewsViewModel"></param>
/// <returns>Response</returns>
public Response oInsertNews(NewsViewModel oNewsViewModel)
{
#region ": Insert :"
Response oResponse = new Response();
try
{
if (oNewsViewModel != null)
{
NEWS oNews = new NEWS()
{
APPLICATION_ID = oNewsViewModel.APPLICATION_ID,
NEWS_TITLE = oNewsViewModel.NEWS_TITLE,
NEWS_CONTENT = oNewsViewModel.NEWS_CONTENT,
NEWS_IMG_FILE_PATH = oNewsViewModel.NEWS_IMG_FILE_PATH,
PUBLISHED_DATE = oNewsViewModel.PUBLISHED_DATE,
IS_ACTIVE = oNewsViewModel.IS_ACTIVE,
IS_NOTIFY_USER = oNewsViewModel.IS_NOTIFY_USER,
LANGUAGE_ID = oNewsViewModel.LANGUAGE_ID,
YOUTUBE_LINK = oNewsViewModel.YOUTUBE_LINK,
CREATED_BY = oNewsViewModel.CREATED_BY,
CREATED_DATE = DateTime.Now
};
if (oNewsViewModel.NEWS_CATEGORY_ID != -99)
{
oNews.NEWS_CATEGORY_ID = oNewsViewModel.NEWS_CATEGORY_ID;
}
this.oTakamulConnection.NEWS.Add(oNews);
if (this.intCommit() > 0)
{
oResponse.OperationResult = enumOperationResult.Success;
oResponse.ResponseCode = Convert.ToString(oNews.ID);
}
else
{
oResponse.OperationResult = enumOperationResult.Faild;
oResponse.ResponseCode = "";
}
}
}
catch (Exception Ex)
{
oResponse.OperationResult = enumOperationResult.Faild;
//TODO : Log Error Message
oResponse.OperationResultMessage = Ex.Message.ToString();
}
return(oResponse);
#endregion
}
// Xóa một tin tuc
public bool Delete(int id)
{
NEWS newsItem = model.NEWS.Find(id);
if (newsItem == null)
{
return(false);
}
model.NEWS.Remove(newsItem);
model.SaveChanges();
return(true);
}
public ActionResult News_Detail(int id)
{
try
{
Session["SUPPLIER"] = "DEFAULT";
NEWS _NEWS = db.NEWS.Find(id);
return(View(_NEWS));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
public NEWS Create([FromBody] NEWS news)
{
if (news.NEWS_IMG == null || news.NEWS_IMG.Length == 0)
{
return(new NEWS());
}
news.NEWS_Date = DateTime.Now.ToString();
context.NEWS.Add(news);
context.SaveChanges();
return(news);
}
public ActionResult Update(int id)
{
try
{
NEWS _NEWS = db.NEWS.Find(id);
List <IMAGES_UPLOAD> _lstIMAGES = db.IMAGES_UPLOAD.Where(n => n.NEWS_ID == id).OrderByDescending(n => n.IMAGES_ID).ToList();
ViewBag.ListImages = _lstIMAGES;
return(View(_NEWS));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
// them mot tin tuc
public bool Insert(NEWS news)
{
NEWS newsItem = model.NEWS.Find(news.id);
if (newsItem != null)
{
return(false);
}
model.NEWS.Add(news);
model.SaveChanges();
return(true);
}
// GET: news/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NEWS nEWS = db.NEWS.Find(id);
if (nEWS == null)
{
return(HttpNotFound());
}
return(View(nEWS));
}
public ActionResult News_Bosch_Detail(int id)
{
try
{
SUPPLIER _Supplier = db.SUPPLIERS.Where(n => n.SUPPLIER_NAME.Contains("BOSCH")).Single();
Session["SUPPLIER"] = "BOSCH";
Session["SUPPLIER_MODEL"] = _Supplier;
NEWS _NEWS = db.NEWS.Find(id);
return(View(_NEWS));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
public News ConvertNEWSToNews(NEWS news)
{
News ResultNews = new News();
ResultNews.Article_title = news.news_title;
ResultNews.Article_id = news.news_id;
ResultNews.Article_content = news.news_content;
ResultNews.Article_isDeleted = news.news_isDeleted;
ResultNews.News_isOnIndex = news.news_isOnIndex;
ResultNews.Article_publish_date = news.news_publish_date;
ResultNews.Article_timestamp = news.news_timestamp;
ResultNews.Article_author = news.news_author;
ResultNews.News_click_count = news.news_click_count;
ResultNews.News_image = news.news_image;
return(ResultNews);
}
public NEWS ConvertNewsToNEWS(News news)
{
NEWS ResultNEWS = new NEWS();
ResultNEWS.news_title = news.Article_title;
ResultNEWS.news_id = news.Article_id;
ResultNEWS.news_content = news.Article_content;
ResultNEWS.news_isDeleted = news.Article_isDeleted;
ResultNEWS.news_isOnIndex = news.News_isOnIndex;
ResultNEWS.news_publish_date = news.Article_publish_date;
ResultNEWS.news_timestamp = news.Article_timestamp;
ResultNEWS.news_author = news.Article_author;
ResultNEWS.news_click_count = news.News_click_count;
ResultNEWS.news_image = news.News_image;
return(ResultNEWS);
}
public static NEWS CreateNews(Entities e, NewsClass news)
{
NEWS _News = new NEWS()
{
NEWS_ID = e.NEWS.Max(n => n.NEWS_ID) + 1,
USER_ID = news.userId,
TYPE = news.type,
NEWS_SUB_CAT_ID = news.subcategory.id,
TITLE = news.title,
HEADLINE = news.headLine,
SHARABLE = news.sharable ? short.Parse("1") : short.Parse("2"),
CREATION_DATE = DateTime.Now,
EVENT_DATE = news.eventDate,
VOTE_COUNT = 1,
VOTE_RESULT = 1,
VOTE_TYPE = 1,
HIERARCHY_TYPE = 1,
USERS = e.USERS.FirstOrDefault(u => u.USER_ID == news.userId),
NEWS_SUB_CATS = e.NEWS_SUB_CATS.FirstOrDefault(n => n.NEWS_SUB_CAT_ID == news.subcategory.id),
APPROVED = new UserPrivateInfoClass(news.userId).needApprove,
ACCESSIBILITY = news.privateNewsType == 0 ? 1 : 2
};
processFKForNEWS_IDAndNEWS_MEDIA(e);
int offset = e.NEWS_MEDIAS.Max(n => n.NEWS_MEDIA_ID) + 1;
if (news.body != null)
{
_News.NEWS_MEDIAS.Add(new NEWS_MEDIAS()
{
NEWS_MEDIA_ID = offset, NEWS_ID = _News.NEWS_ID, BODY = news.body, TYPE = 1
});
if (news.newsImage != null)
{
offset++;
}
}
if (news.newsImage != null)
{
_News.NEWS_MEDIAS.Add(new NEWS_MEDIAS()
{
NEWS_MEDIA_ID = offset, NEWS_ID = _News.NEWS_ID, ATTACH = news.newsImage, TYPE = 2, NAME = "No Name.jpg"
});
}
return(_News);
}
public NEWS NewsByID(int id_team)
{
NEWS news = new NEWS();
var result = db.newsByID(id_team).ToList();
foreach (var element in result)
{
var tmp = new NEWS();
news.ID_news = element.ID_news;
news.title = element.title;
news.text = element.text;
news.date = element.date;
news.userName = element.UserName;
news.numberOfComments = element.numberOfComments;
}
return(news);
}
public int DoSaveData(FormCollection form, int?ID = null)
{
NEWS saveModel;
if (ID == 0)
{
saveModel = new NEWS();
saveModel.BUD_ID = UserProvider.Instance.User.ID;
saveModel.BUD_DT = DateTime.UtcNow.AddHours(8);
}
else
{
saveModel = this.DB.NEWS.Where(s => s.ID == ID).FirstOrDefault();
}
saveModel.TITLE = form["title"];
saveModel.HOME_PAGE_DISPLAY = form["disHome"] == "on" ? true : false;
saveModel.DISABLE = form["disable"] == null ? false : Convert.ToBoolean(form["disable"]);
saveModel.SQ = form["sortIndex"] == null ? 1 : Convert.ToDouble(form["sortIndex"]);
saveModel.CONTENT = form["contenttext"];
saveModel.PUB_DT_STR = form["publishDate"];
saveModel.UPT_DT = DateTime.UtcNow.AddHours(8);
saveModel.UPT_ID = UserProvider.Instance.User.ID;
PublicMethodRepository.FilterXss(saveModel);
if (ID == 0)
{
this.DB.NEWS.Add(saveModel);
}
else
{
this.DB.Entry(saveModel).State = EntityState.Modified;
}
try
{
this.DB.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
int identityId = (int)saveModel.ID;
return(identityId);
}
// Use this for initialization
public AnimControl_Player(GameObject o)
{
news = NEWS.S;
obj = o;
}
void changeState(STATE_PLAYER state)
{
switch (state)
{
case STATE_PLAYER.IDLE:
{
if (news == NEWS.N)
finalSt = STATE.B_IDLE;
if (news == NEWS.E)
finalSt = STATE.R_IDLE;
if (news == NEWS.W)
finalSt = STATE.L_IDLE;
if (news == NEWS.S)
finalSt = STATE.F_IDLE;
break;
}
case STATE_PLAYER.RUN:
{
float x = lookDir.x;
float z = lookDir.z;
float abx=0;
float abz=0;
if (x < 0)
abx = -x;
else
abx = x;
if (z < 0)
abz = -z;
else
abz = z;
if (x >0 &&abx-0.01 > abz )
{
changeDir = true;
news = NEWS.E;
finalSt = STATE.R_RUN;
}
else if (z > 0 &&abz-0.01 > abx)
{
changeDir = true;
news = NEWS.N;
finalSt = STATE.B_RUN;
}
else if (x < 0 && abx-0.01> abz)
{
changeDir = true;
news = NEWS.W;
finalSt = STATE.L_RUN;
}
else if (z < 0 && abz-0.01 > abx )
{
changeDir = true;
news = NEWS.S;
finalSt = STATE.F_RUN;
}
break;
}
}
}
