private void AddBN_Click(object sender, RoutedEventArgs e)
{
try
{
if (SexCB.Text != "М" && SexCB.Text != "Ж")
{
return;
}
string sql = "UPDATE [Employee] SET [SubjectsID] = '" + (SubjectCB.SelectedIndex + 1).ToString() + "', " +
"[FIOEmployee] = '" + FIOTB.Text + "', " +
"[Sex] = '" + SexCB.SelectedItem.ToString() + "', " +
"[DOB] = '" + Convert.ToDateTime(DayB.Text) + "', " +
"[Tel] = '" + TelTB.Text + "' " +
"WHERE [EmployeeID] = " + UCEmployee.index;
WorkWithBD.Update(sql);
Close();
}
catch { MessageBox.Show("Введите корректные данные"); }
}
private void AddBN_Click(object sender, RoutedEventArgs e)
{
try
{
DataSet User = new DataSet();
User = WorkWithBD.outPutdb("SELECT StudentID FROM Student WHERE FIO ='" + (FIOCB.SelectedItem).ToString() + "'").Tables[0].DataSet;
string idfio = (User.Tables[0].DefaultView[0].Row[0].ToString());
string sql = "UPDATE [Logs] SET [StudentID] = " + idfio + ", " +
"[Missed] = '" + ((MissedChB.IsChecked == true)? "н" : " ") + "', " +
"[Rating] = " + (RatingCB.SelectedItem.ToString() == " "? "NULL" : RatingCB.SelectedItem.ToString()) + ", " +
"[Data] = '" + Convert.ToDateTime(DayB.Text) + "' " +
"WHERE [LogsID] = " + UCLogs.index;
WorkWithBD.Update(sql);
Close();
}
catch { MessageBox.Show("Введите корректные данные или проверьте поле оценка"); }
}
