public ActionResult ToggleAllowexport(int id, int idGroup)
{
var helperBo = new HelperBo();
var res = helperBo.IsExistWhere(tableName, "ID_GROUP=" + idGroup + " AND ID_FUNCTION=" + id);
var result = "failed";
if (res.success)
{
// not exist => add new
if (res.message == "0")
{
var g2f = new GroupToFunctionDto()
{
ID_FUNCTION = id,
ID_GROUP = idGroup,
ALLOW_ADD = 0,
ALLOW_DEL = 0,
ALLOW_EDIT = 0,
ALLOW_EXPORT = 1,
ALLOW_VIEW = 0
};
helperBo.Add(tableName, g2f);
}
//exist => update
else
{
helperBo.ToggleWhere(tableName, "ALLOW_EXPORT", "ID_GROUP=" + idGroup + " AND ID_FUNCTION=" + id);
}
result = "success";
}
return(Content(JsonConvert.SerializeObject(new
{
isSuccess = result
}), "application/json"));
}
public ActionResult Update(int ID, int ID_GROUP, int ID_FUNCTION, int ALLOW_VIEW, int ALLOW_ADD, int ALLOW_EDIT, int ALLOW_DEL, int ALLOW_EXPORT)
{
string res = "Failed";
var groupToFunctionBo = new HelperBo();
if (ID == 0)
{
var obj = new GroupToFunctionDto()
{
ALLOW_VIEW = ALLOW_VIEW,
ALLOW_EXPORT = ALLOW_EXPORT,
ALLOW_EDIT = ALLOW_EDIT,
ALLOW_DEL = ALLOW_DEL,
ALLOW_ADD = ALLOW_ADD,
ID_FUNCTION = ID_FUNCTION,
ID_GROUP = ID_GROUP
};
// not exist
var resultAdd = groupToFunctionBo.Add(tableName, obj);
if (resultAdd.success == true)
{
res = "success";
}
}
else
{
var obj = new GroupToFunctionDto()
{
ALLOW_VIEW = ALLOW_VIEW,
ALLOW_EXPORT = ALLOW_EXPORT,
ALLOW_EDIT = ALLOW_EDIT,
ALLOW_DEL = ALLOW_DEL,
ALLOW_ADD = ALLOW_ADD,
ID_FUNCTION = ID_FUNCTION,
ID_GROUP = ID_GROUP
};
var result = groupToFunctionBo.UpdateWhere(tableName, obj, "ID=" + ID);
if (result.success)
{
res = result.message;
}
else
{
_log.Error("ERROR", result.error.exception);
}
}
return(Content(JsonConvert.SerializeObject(new
{
isSuccess = res
}), "application/json"));
}
public ActionResult SetAllowVal(int id, int val)
{
var groupToFunctionBo = new HelperBo();
var obj = new GroupToFunctionDto()
{
ALLOW_ADD = val,
ALLOW_DEL = val,
ALLOW_EDIT = val,
ALLOW_EXPORT = val,
ALLOW_VIEW = val
};
var res = groupToFunctionBo.UpdateWhere(tableName, val, "ID=" + id);
var result = "failed";
if (res.success)
{
result = "success";
}
return(Content(JsonConvert.SerializeObject(new
{
isSuccess = result
}), "application/json"));
}