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