public ActionResult Del_Pages(decimal p_id) { try { decimal preturn = 0; if (SessionData.CurrentUser == null) { return(Redirect("/")); } var objBL = new Sys_Pages_BL(); Sys_Pages_Info _Info = new Sys_Pages_Info(); var ModifiedBy = SessionData.CurrentUser.Username; _Info.Id = p_id; _Info.Modified_By = ModifiedBy; preturn = objBL.Sys_Pages_Deleted(_Info); if (preturn >= 0) { MemoryData.Load_Sys_page(); } return(Json(new { status = preturn })); } catch (Exception ex) { Logger.LogException(ex); return(View()); } }
public ActionResult Edit_Pages(Sys_Pages_Info p_Sys_Pages_Info) { try { if (p_Sys_Pages_Info == null) { return(Json(new { status = -99 })); } string language = AppsCommon.GetCurrentLang(); var ModifiedBy = SessionData.CurrentUser.Username; var ModifiedDate = CommonFuc.CurrentDate(); if (p_Sys_Pages_Info.pfileLogo != null) { p_Sys_Pages_Info.Imageheader = AppLoadHelpers.PushFileToServer(p_Sys_Pages_Info.pfileLogo, AppUpload.Logo); } p_Sys_Pages_Info.Modified_By = SessionData.CurrentUser.Username; var objBL = new Sys_Pages_BL(); decimal preturn = objBL.Sys_Pages_Update(p_Sys_Pages_Info); if (preturn >= 0) { MemoryData.Load_Sys_page(); } return(Json(new { status = preturn })); } catch (Exception ex) { Logger.LogException(ex); return(View()); } }
public ActionResult ContactDisplay() { var objBL = new Sys_Pages_BL(); string language = AppsCommon.GetCurrentLang(); Sys_Pages_Info _pageInfo = objBL.Sys_Pages_GetBy_Code("abot"); ViewBag.objNewInfo = _pageInfo; return(View("~/Areas/Contact/Views/Contact/ContactDisplay.cshtml")); }
public decimal Sys_Pages_Update(Sys_Pages_Info pInfo) { try { Sys_Pages_DA objDA = new Sys_Pages_DA(); return(objDA.Sys_Pages_Update(pInfo)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }
public decimal Sys_Pages_Deleted(Sys_Pages_Info pInfo) { try { var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_sys_pages.PROC_DELETED", new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input), new OracleParameter("P_MODIFIED_BY", OracleDbType.Varchar2, pInfo.Modified_By, ParameterDirection.Input), paramReturn); return(Convert.ToDecimal(paramReturn.Value.ToString())); } catch (Exception ex) { Logger.LogException(ex); return(-1); } }
public ActionResult NewsDetailmembership() { try { string _code = ""; if (RouteData.Values.ContainsKey("id")) { _code = CommonFuc.ConvertToString(RouteData.Values["id"]); } var objBL = new Sys_Pages_BL(); string language = AppsCommon.GetCurrentLang(); Sys_Pages_Info _pageInfo = objBL.Sys_Pages_GetBy_Code(_code); ViewBag.objNewInfo = _pageInfo; return(View("~/Areas/Sys_Pages/Views/SysPages/NewsDetail_By_Home.cshtml")); //string pCategory = ""; //if (RouteData.Values.ContainsKey("id")) //{ // pCategory = CommonFuc.ConvertToString(RouteData.Values["id"]); //} //var objNewsBL = new NewsBL(); //string language = AppsCommon.GetCurrentLang(); //List<NewsInfo> lstNews = objNewsBL.NewsStatic(language); //ViewBag.objNewInfo = new NewsInfo(); //if (lstNews.Count > 0) //{ // foreach (var item in lstNews) // { // if (item.Categories_Id.ToUpper() == pCategory.ToUpper()) // { // ViewBag.objNewInfo = item; // return View("~/Areas/Articles/Views/ArticlesNews/NewsDetailByCategory.cshtml"); // } // } //} //return View("~/Areas/Articles/Views/ArticlesNews/NewsDetailByCategory.cshtml"); } catch (Exception ex) { Logger.LogException(ex); return(View()); } }
public ActionResult NewsDetail_Page() { try { string _code = ""; if (RouteData.Values.ContainsKey("id")) { _code = CommonFuc.ConvertToString(RouteData.Values["id"]); } var objBL = new Sys_Pages_BL(); string language = AppsCommon.GetCurrentLang(); Sys_Pages_Info _pageInfo = objBL.Sys_Pages_GetBy_Code(_code); ViewBag.objNewInfo = _pageInfo; return(View("~/Areas/Sys_Pages/Views/SysPages/NewsDetail_By_Home.cshtml")); } catch (Exception ex) { Logger.LogException(ex); return(View()); } }
public decimal Sys_Pages_Insert(Sys_Pages_Info pInfo) { try { var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_sys_pages.PROC_INSERT", new OracleParameter("p_code", OracleDbType.Varchar2, pInfo.Code, ParameterDirection.Input), new OracleParameter("P_HEADER", OracleDbType.Varchar2, pInfo.Header, ParameterDirection.Input), new OracleParameter("P_HEADER_EN", OracleDbType.Varchar2, pInfo.Header_En, ParameterDirection.Input), new OracleParameter("P_IMAGEHEADER", OracleDbType.Varchar2, pInfo.Imageheader, ParameterDirection.Input), new OracleParameter("P_CONTENT", OracleDbType.Clob, pInfo.Content, ParameterDirection.Input), new OracleParameter("P_CONTENT_EN", OracleDbType.Clob, pInfo.Content_En, ParameterDirection.Input), new OracleParameter("P_STATUS", OracleDbType.Decimal, pInfo.Status, ParameterDirection.Input), new OracleParameter("P_CREATED_BY", OracleDbType.Varchar2, pInfo.Created_By, ParameterDirection.Input), paramReturn); return(Convert.ToDecimal(paramReturn.Value.ToString())); } catch (Exception ex) { Logger.LogException(ex); return(-1); } }