private void MainGrid_Loaded(object sender, RoutedEventArgs e) { _depList = GlobalUsage.GetInfClient().GetDepartments(new BlankMsg() { }); UpdateView(); }
public override Task <DepartmentsListResp> GetDepartments(BlankMsg request, ServerCallContext context) { DepartmentsListResp tmp = new DepartmentsListResp(); DBConnection.Open(); String command = "SELECT * FROM Department"; SqlCommand newCommand = new SqlCommand(command, DBConnection); SqlDataReader dataReader = newCommand.ExecuteReader(); while (dataReader.Read()) { tmp.DepsDesc.Add(new DepartmentDescription { Index = dataReader.GetInt32(0), Name = dataReader.GetString(1) }); } dataReader.Close(); DBConnection.Close(); return(System.Threading.Tasks.Task.FromResult(tmp)); }