/// <summary> /// Finally when the client made the changes that he wants the program checks if all the fields /// all fields are fill. If all fields are fill then the program exec the apropriate querry for the /// update of the rating, else show a error message. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSelect_Click(object sender, EventArgs e) { LblRatingValue.Show(); LblComment.Show(); LblUsername.Show(); TbxComment.Show(); TbxRatingValue.Show(); CmbUsername.Show(); BtnEdit.Show(); LblSelect.Hide(); CmbSelect.Hide(); BtnSelect.Hide(); SelectedData = DCom.GetData(String.Format(SqlExec, CmbSelect.SelectedValue)); TbxRatingValue.Text = SelectedData.Rows[0]["Rating_Value"].ToString(); TbxComment.Text = SelectedData.Rows[0]["Comment"].ToString(); CmbUsername.DataSource = DCom.GetData("SELECT * FROM users"); CmbUsername.DisplayMember = "Username"; CmbUsername.ValueMember = "Username"; }
private void DgvManagers_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)//select the manager to updating or deactiving { BtnAdd.Hide(); BtnUpdate.Show(); BtnDeactive.Show(); BtnCancel.Show(); TxtPassword.Hide(); LblPassword.Text = "New Password"; LblComment.Show(); TxtNewPassword.Show(); int Id = Convert.ToInt32(DgvManagers.Rows[e.RowIndex].Cells[0].Value); _selectedManager = _managerService.Find(Id); //index of selected manager on datagridview _selectedIndex = e.RowIndex; //fill the selected manager information to the textboxes TxtName.Text = _selectedManager.Name; TxtSurname.Text = _selectedManager.Surname; TxtPhone.Text = _selectedManager.Phone; TxtUsername.Text = _selectedManager.Username; if (_selectedManager.IsAdmin == true) { CmbPosition.SelectedIndex = 0; return; } CmbPosition.SelectedIndex = 1; }
/// <summary> /// In forms constructor the not necessarily labels, tetxboxes and comboboxes are hiding /// from the form. Then the combobox for ratings(CmbSelect) is filling with the data of the table. /// </summary> public EditRatingsForm() { InitializeComponent(); LblRatingValue.Hide(); LblComment.Hide(); LblUsername.Hide(); TbxComment.Hide(); TbxRatingValue.Hide(); CmbUsername.Hide(); BtnEdit.Hide(); CmbSelect.DataSource = DCom.GetData("SELECT *, CONCAT(Username, ', ', Rating_Value) AS NAME FROM ratings"); CmbSelect.DisplayMember = "NAME"; CmbSelect.ValueMember = "ID"; }
private void Reset()//reset the all changes on textboxes { TxtName.Text = string.Empty; TxtSurname.Text = string.Empty; TxtPhone.Text = string.Empty; TxtUsername.Text = string.Empty; TxtPassword.Text = string.Empty; TxtNewPassword.Text = string.Empty; CmbPosition.SelectedItem = null; BtnAdd.Show(); BtnDeactive.Hide(); BtnUpdate.Hide(); BtnCancel.Hide(); TxtNewPassword.Hide(); LblPassword.Text = "password"; TxtPassword.Show(); LblComment.Hide(); }