public int UpdatePermission(SecurityModels.Permission permission) { try { using (SqlConnection con = new SqlConnection(securityConnectionString)) { using (SqlCommand cmd = new SqlCommand("UpdatePermission", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = permission.id; cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = permission.name; cmd.Parameters.Add("@displayName", SqlDbType.VarChar, 50).Value = permission.displayName; cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = permission.active ? 1 : 0; con.Open(); permission.id = Convert.ToInt32(cmd.ExecuteScalar()); } con.Close(); } } catch { throw; } return(permission.id); }
public SecurityModels.Permission GetPermission(int id) { SecurityModels.Permission permission = new SecurityModels.Permission(); using (SqlConnection con = new SqlConnection(securityConnectionString)) { using (SqlCommand cmd = new SqlCommand("GetPermission", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { permission.id = Convert.ToInt32(reader["ID"].ToString()); permission.name = reader["Name"].ToString(); permission.displayName = reader["displayName"].ToString(); permission.active = id == 0 ? false : Convert.ToBoolean(reader["Active"].ToString()); } } con.Close(); } return(permission); }
public void UpdatePermissionStatus(SecurityModels.Permission permission) { try { using (SqlConnection con = new SqlConnection(securityConnectionString)) { using (SqlCommand cmd = new SqlCommand("UpdatePermissionStatus", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = permission.id; cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = permission.active; con.Open(); cmd.ExecuteNonQuery(); } con.Close(); } } catch { throw; } }
public IActionResult GetPermission(int id) { SecurityModels.Permission permission = securityInventoryRepo.GetPermission(id); return(StatusCode(StatusCodes.Status200OK, permission)); }
public IActionResult UpdatePermissionStatus([FromBody] SecurityModels.Permission permission) { securityInventoryRepo.UpdatePermissionStatus(permission); return(StatusCode(StatusCodes.Status200OK, permission)); }