public void Delete(IRoleDetailModel model)
{
var dataAccessStatus = new DataAccessStatus();
try
{
using (var context = new DbContext())
{
string queryStr = "DELETE FROM role_detail WHERE (role_kode = @kode AND menu_name = @parent) " +
"OR (role_kode = @kode AND menu_parent = @parent)";
context.Conn.Execute(queryStr, new
{
kode = model.role_kode,
menu = model.menu_parent,
parent = model.menu_parent
});
}
}
catch (MySqlException ex)
{
dataAccessStatus = SetDataAccessValues(ex, ErrorMessageType.Update);
throw new DataAccessException(message: ex.Message, innerException: ex.InnerException,
dataAccessStatus: dataAccessStatus);
}
}
public void Insert(IRoleDetailModel model)
{
var dataAccessStatus = new DataAccessStatus();
try
{
using (var context = new DbContext())
{
context.Conn.Insert((RoleDetailModel)model);
}
}
catch (MySqlException ex)
{
dataAccessStatus = SetDataAccessValues(ex, ErrorMessageType.Update);
throw new DataAccessException(message: ex.Message, innerException: ex.InnerException,
dataAccessStatus: dataAccessStatus);
}
}
public void Delete(IRoleDetailModel model)
{
_repo.Delete(model);
}
public void Insert(IRoleDetailModel model)
{
_repo.Insert(model);
}
