private void delSchedBtn_Click(object sender, EventArgs e) { Department schedDept = new Department(); schedDept.id = new Guid(chooseDept.SelectedValue.ToString()); Job schedJob = new Job(); schedJob.id = new Guid(chooseJob.SelectedValue.ToString()); Schedule delSched = new Schedule(); delSched.dept = schedDept; delSched.job = schedJob; string where = "fk_department=" + dbConnect.Transform(delSched.dept.id.ToString()) + " and fk_job=" + dbConnect.Transform(delSched.job.id.ToString()); List <string>[] selection = DBConnect.SendMessageFromSocket(dbConnect.Select("schedule", "", where)); if (!selection.Length.Equals(0)) { DBConnect.SendMessageFromSocket(dbConnect.Delete("schedule", where)); MessageBox.Show("Расписание удалено"); foreach (CheckedListBox sub in cbAllControl) { for (int a = 0; a < sub.Items.Count; a++) { sub.SetItemChecked(a, false); } } } else { MessageBox.Show("Для вашего запроса расписание ещё не назначено"); } ScheduleForm_Load(sender, e); }
private void deleteJobBtn_Click(object sender, EventArgs e) { Job delJob = new Job(chooseJob.Text, (string)rankCB.SelectedItem, (int)salaryRank.Value); delJob.id = (Guid)chooseJob.SelectedValue; string where = "idjob=" + dbConnect.Transform(delJob.id.ToString()); dbConnect.Delete("job", where); JobForm_Load(sender, e); }
private void deleteDepBtn_Click(object sender, EventArgs e) { Department delDept = new Department(chooseDept.Text, jobs); delDept.id = new Guid(chooseDept.SelectedValue.ToString()); string where = "iddept=" + dbConnect.Transform(delDept.id.ToString()); DBConnect.SendMessageFromSocket(dbConnect.Delete("department", where)); DepartmentForm_Load(sender, e); }
private void minusPersonBtn_Click(object sender, EventArgs e) { try { string where = "idperson= " + dbConnect.Transform(infTable.SelectedRows[0].Cells[0].Value.ToString()); List <string>[] selection = dbConnect.Select("person", 13, "", where); dbConnect.Delete("person", where); } catch (Exception) { MessageBox.Show("Выделите всю строку"); }; OperationsForm_Load(sender, e); }