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); }