public async Task <ApiResponse> GetAsync(Int64 id)
{
var _apiRes = new ApiResponse();
var dbPara = new DynamicParameters();
dbPara.Add("@oPageId", id, DbType.Int64);
dbPara.Add("@SuccessMsg", null, DbType.String, ParameterDirection.Output);
dbPara.Add("@IsSuccess", 0, DbType.Int16, ParameterDirection.Output);
_apiRes.Data = await _dapperService.GetAsync <Pages>("API_GetCMS", dbPara, CommandType.StoredProcedure);
_apiRes.Message = dbPara.Get <string>("SuccessMsg");
_apiRes.Status = dbPara.Get <Int16>("IsSuccess") == 1 ? true : false;
return(_apiRes);
}
public async Task <ApiResponse> IsActiveUser(Int64 userId, int isActive)
{
var _apiResponse = new ApiResponse();
var _param = new DynamicParameters();
_param.Add("@oUserId", userId, DbType.Int64);
_param.Add("@oIsActive", isActive, DbType.Int16);
_param.Add("@SuccessMsg", null, DbType.String, ParameterDirection.Output);
_param.Add("@IsSuccess", 0, DbType.Int16, ParameterDirection.Output);
await _dapperService.GetAsync <User>("API_IsActiveUser", _param, CommandType.StoredProcedure);
_apiResponse.Message = _param.Get <string>("SuccessMsg");
_apiResponse.Status = _param.Get <Int16>("IsSuccess") == 1 ? true : false;
return(_apiResponse);
}
public async Task <ApiResponse> GetPermissionAsync(Int64 id, string menu)
{
var _apiResponse = new ApiResponse();
var _param = new DynamicParameters();
_param.Add("@orole_id", id, DbType.Int32);
_param.Add("@omenu_url", menu, DbType.String);
_param.Add("@SuccessMsg", null, DbType.String, ParameterDirection.Output);
_param.Add("@IsSuccess", 0, DbType.Int16, ParameterDirection.Output);
var result = await _dapperService.GetAsync <RolePermission>("API_GetPermission", _param, CommandType.StoredProcedure);
_apiResponse.Data = result;
_apiResponse.Message = _param.Get <string>("SuccessMsg");
_apiResponse.Status = _param.Get <Int16>("IsSuccess") == 1 ? true : false;
return(_apiResponse);
}
public async Task <ApiResponse> SaveAsync(Menu model)
{
var _apiRes = new ApiResponse();
var dbPara = new DynamicParameters();
dbPara.Add("@omenu_id", model.menu_id, DbType.Int64);
dbPara.Add("@oparent_menu_id", model.parent_menu_id, DbType.Int64);
dbPara.Add("@oUserId", model.UserId, DbType.Int64);
dbPara.Add("@omenu_title", model.menu_title, DbType.String);
dbPara.Add("@omenu_url", model.menu_url, DbType.String);
dbPara.Add("@omenu_icon", model.menu_icon, DbType.String);
dbPara.Add("@osort_order", model.sort_order, DbType.Int32);
dbPara.Add("@ois_active", model.is_active, DbType.Int32);
dbPara.Add("@SuccessMsg", null, DbType.String, ParameterDirection.Output);
dbPara.Add("@IsSuccess", 0, DbType.Int16, ParameterDirection.Output);
await _dapperService.GetAsync <Pages>("API_SaveMenu", dbPara, CommandType.StoredProcedure);
_apiRes.Message = dbPara.Get <string>("SuccessMsg");
_apiRes.Status = dbPara.Get <Int16>("IsSuccess") == 1 ? true : false;
return(_apiRes);
}
public async Task <ApiResponse> GetUserByEmailAndPassword(string userName, string password)
{
var _apiResponse = new ApiResponse();
var _param = new DynamicParameters();
_param.Add("@uUserName", userName, DbType.String);
_param.Add("@uPassword", password, DbType.String);
_param.Add("@SuccessMsg", null, DbType.String, ParameterDirection.Output, 200);
_param.Add("@IsSuccess", null, DbType.Int16, ParameterDirection.Output);
_apiResponse.Data = await Task.FromResult(_dapperService.GetAsync <User>("API_AdminLogin", _param, CommandType.StoredProcedure)).Result;
_apiResponse.Message = _param.Get <string>("SuccessMsg");
_apiResponse.Status = _param.Get <Int16>("IsSuccess") == 1 ? true : false;
return(_apiResponse);
}
