public ActionResult do_Edit(Template_Email_Info pInfo)
{
try
{
if (SessionData.CurrentUser == null)
{
return(Redirect("/"));
}
Email_BL _obj_bl = new Email_BL();
pInfo.Modify_By = SessionData.CurrentUser.Username;
decimal _re = _obj_bl.Template_Email_Update(pInfo);
if (_re > 0)
{
BussinessFacade.ModuleMemoryData.MemoryData.LoadTemplate();
}
return(Json(new { success = _re }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { success = "-1" }));
}
}
public decimal Template_Email_Update(Template_Email_Info info)
{
try
{
Template_EmailDA emailDA = new Template_EmailDA();
return(emailDA.Template_Email_Update(info));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public ActionResult Show_Edit(decimal id)
{
if (SessionData.CurrentUser == null)
{
return(Redirect("/"));
}
try
{
Email_BL _obj_bl = new Email_BL();
Template_Email_Info _Template_Email_Info = _obj_bl.Template_Email_GetBy_Id(id, AppsCommon.GetCurrentLang());
ViewBag.Template_Email_Info = _Template_Email_Info;
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(View("~/Areas/Manager/Views/TemplateEmail/_PartialEdit.cshtml"));
}
public decimal Template_Email_Insert(Template_Email_Info info)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_template_email.Proc_Template_Email_Insert",
new OracleParameter("p_name", OracleDbType.Varchar2, info.Name, ParameterDirection.Input),
new OracleParameter("p_type", OracleDbType.Varchar2, info.Type, ParameterDirection.Input),
new OracleParameter("p_content", OracleDbType.Clob, info.Content, ParameterDirection.Input),
new OracleParameter("p_note", OracleDbType.Clob, info.Note, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, info.Created_By, ParameterDirection.Input),
paramReturn
);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
