public decimal Sys_Search_Fee_Update(Sys_Search_Fix_Info p_obj)
{
try
{
Sys_Search_Fix_DA _da = new Sys_Search_Fix_DA();
return(_da.Sys_Search_Fee_Update(p_obj));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public ActionResult GetView2View(decimal id)
{
try
{
Sys_Search_Fix_BL _obj_bl = new Sys_Search_Fix_BL();
Sys_Search_Fix_Info _Sys_Search_Fix_Info = _obj_bl.Sys_Search_Fix_GetById(id);
return(PartialView("~/Areas/Manager/Views/Search_Fee/_PartialView.cshtml", _Sys_Search_Fix_Info));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(PartialView("~/Areas/Manager/Views/Search_Fee/_PartialView.cshtml", new Sys_Search_Fix_Info()));
}
}
public ActionResult DoEdit(Sys_Search_Fix_Info p_obj)
{
try
{
if (SessionData.CurrentUser == null)
{
return(Redirect("/"));
}
Sys_Search_Fix_BL _obj_bl = new Sys_Search_Fix_BL();
p_obj.Modified_By = SessionData.CurrentUser.Username;
decimal _ck = _obj_bl.Sys_Search_Fee_Update(p_obj);
BussinessFacade.ModuleMemoryData.MemoryData.LoadSys_Search_Fee_Fix();
return(Json(new { success = _ck }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { success = "-1" }));
}
}
public decimal Sys_Search_Fee_Insert(Sys_Search_Fix_Info p_obj)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_sys_search_fix.Proc_Sys_Search_Fee_Insert",
new OracleParameter("p_country_id", OracleDbType.Decimal, p_obj.Country_Id, ParameterDirection.Input),
new OracleParameter("p_search_object", OracleDbType.Decimal, p_obj.Search_Object, ParameterDirection.Input),
new OracleParameter("p_search_type", OracleDbType.Decimal, p_obj.Search_Type, ParameterDirection.Input),
new OracleParameter("p_amount", OracleDbType.Decimal, p_obj.Amount, ParameterDirection.Input),
new OracleParameter("p_amount_usd", OracleDbType.Decimal, p_obj.Amount_usd, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, p_obj.Created_By, ParameterDirection.Input),
paramReturn
);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}