public decimal Update(Au_GroupInfo _pbj)
{
decimal ck = -1;
try
{
Au_GroupDA _da = new Au_GroupDA();
ck = _da.Update(_pbj);
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
}
return(ck);
}
public ActionResult Register(Au_GroupInfo au_groupinfo)
{
try
{
Au_GroupBL _bl = new Au_GroupBL();
au_groupinfo.Created_By = "";
au_groupinfo.Created_Date = DateTime.Now;
decimal ck = _bl.Insert(au_groupinfo);
return(Json(new { success = ck }));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(Json(new { success = "-1" }));
}
}
public ActionResult EditView(decimal id)
{
Au_GroupInfo _obj = new Au_GroupInfo();
try
{
Au_GroupBL _bl = new Au_GroupBL();
_obj = _bl.GetbyId(id);
}
catch (Exception ex)
{
_obj = new Au_GroupInfo();
NaviCommon.Common.log.Error(ex.ToString());
}
ViewBag.Supplier = _obj;
return(PartialView("~/Areas/UserAndRole/Views/AuGroup/_Partial_Edit.cshtml"));
}
public decimal Insert(Au_GroupInfo au_group)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Common.gConnectString, CommandType.StoredProcedure, "pkg_au_group.Proc_Insert",
new OracleParameter("p_group_name", OracleDbType.Varchar2, au_group.Group_Name, ParameterDirection.Input),
new OracleParameter("p_description", OracleDbType.Varchar2, au_group.Description, ParameterDirection.Input),
new OracleParameter("p_user_type", OracleDbType.Decimal, au_group.User_Type, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, au_group.Created_By, ParameterDirection.Input),
new OracleParameter("p_created_date", OracleDbType.Date, au_group.Created_Date, ParameterDirection.Input),
new OracleParameter("p_modify_by", OracleDbType.Varchar2, au_group.Modify_By, ParameterDirection.Input),
new OracleParameter("p_modify_date", OracleDbType.Date, au_group.Modify_Date, ParameterDirection.Input),
new OracleParameter("p_deleted", OracleDbType.Decimal, au_group.Deleted, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(-1);
}
}