private void DepartmentsList_SelectedIndexChanged(object sender, EventArgs e) { string name = DepartmentsList.SelectedItem.ToString(); var id = departments .Where(d => d.Name == name) .FirstOrDefault().Id; var emps = employees .Where(x => x.DepId == id) .ToList(); EmpList.Items.Clear(); foreach (var x in emps) { EmpList.Items.Add($"{x.FirstName} {x.LastName}"); } Add_but.Enabled = true; FName.Clear(); LName.Clear(); Position.Clear(); Experience.Clear(); }
protected void getCompleteProfile(int in_current_userId, int in_profileId) { connect.Open(); SqlCommand cmd = connect.CreateCommand(); try { cmd.CommandText = "select physicianCompleteProfileId from PhysicianCompleteProfiles where userId = '" + in_profileId + "' "; ID = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_isPrivate] from PhysicianCompleteProfiles where userId = '" + in_profileId + "' "; Private = Convert.ToInt32(cmd.ExecuteScalar()); if (in_current_userId == in_profileId || Private == 0)//If the user trying access the profile is the owner { cmd.CommandText = "select [physicianCompleteProfile_Dialysis] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; Dialysis = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_homeDialysis] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; HomeDialysis = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_transplantation] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; Transplantation = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_hypertension] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; Hypertension = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_GN] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; GN = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select [physicianCompleteProfile_physicianId] from [PhysicianCompleteProfiles] where userId = '" + in_profileId + "' "; PhysicianID = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select count(*) from PhysicianExperiences where physicianCompleteProfileId = '" + ID + "' "; int experiencesCount = Convert.ToInt32(cmd.ExecuteScalar()); if (experiencesCount > 0) { Experience = new List <string[]>(); } for (int i = 1; i <= experiencesCount; i++) { cmd.CommandText = "select physicianExperienceId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY physicianExperienceId ASC), * FROM PhysicianExperiences where physicianCompleteProfileId = '" + ID + "') as t where rowNum = '" + i + "'"; string experienceId = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select physicianExperience_hospitalName from PhysicianExperiences where physicianExperienceId = '" + experienceId + "' "; string hospitalName = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select physicianExperience_hospitalAddress from PhysicianExperiences where physicianExperienceId = '" + experienceId + "' "; string hospitalAddress = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select physicianExperience_fromYear from PhysicianExperiences where physicianExperienceId = '" + experienceId + "' "; string fromYear = cmd.ExecuteScalar().ToString(); cmd.CommandText = "select physicianExperience_toYear from PhysicianExperiences where physicianExperienceId = '" + experienceId + "' "; string toYear = cmd.ExecuteScalar().ToString(); string[] result = new string[] { hospitalName, hospitalAddress, fromYear, toYear }; Experience.Add(result); } } else //if (Private == 1) if the account is set to private and the user accessing it is not the owner: { //If the account is private or the user trying to access is not the owner, show nothing: Dialysis = ""; HomeDialysis = ""; Transplantation = ""; Hypertension = ""; GN = ""; PhysicianID = ""; if (Experience != null) { Experience.Clear(); } } } catch (Exception e) { Console.WriteLine("An error occured while trying to retrieve the Physician Complete Profile ID (" + ID + "): ", e); //If there is an error, set everything to blank to avoid null values: Dialysis = ""; HomeDialysis = ""; Transplantation = ""; Hypertension = ""; GN = ""; PhysicianID = ""; if (Experience != null) { Experience.Clear(); } } connect.Close(); }
void Open() { Canvas.gameObject.SetActive(true); Experience.Clear(); }