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