private void btnAdd_Click(object sender, EventArgs e)
{
btnNext.Visible = false;
UpdateDb();
(new Edit(owner)).ShowDialog();
CourseDataSet.AcceptChanges();
FillDb();
this.Refresh();
}
private void bthDel_Click(object sender, EventArgs e)
{
btnNext.Visible = false;
try
{
if (MessageBox.Show("\tВы уверены?", "\tУдаление", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
switch (owner)
{
case "btnTrainees":
traineesTableAdapter.DeleteQuery(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
break;
case "btnLectures":
lecturerTableAdapter.DeleteQuery(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
break;
case "btnGroup":
groupTableAdapter.DeleteQuery(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
break;
case "btnCourses":
courseTableAdapter.DeleteQuery(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
break;
case "btnExams":
examTableAdapter.DeleteQuery(dataGridView1.SelectedRows[0].Cells[2].Value.ToString(), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[1].Value), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
break;
case "btnDiscipline":
disciplineTableAdapter.DeleteQuery(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
break;
case "btnPayment":
paymentTableAdapter.DeleteQuery(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[1].Value));
break;
case "btnTimeSheet":
timeSheetTableAdapter.DeleteQuery(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
break;
}
}
}
catch (SqlException ex)
{
MessageBox.Show("\tПожалуйста, удалите сначала все связанные данные", "Ошибка удаления");
}
catch (ArgumentOutOfRangeException ex)
{
MessageBox.Show("\tПожалуйста, выберите данные", "\tОшибка");
}
CourseDataSet.AcceptChanges();
FillDb();
this.Refresh();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (MessageBox.Show("\tВы уверены?", "\tУдаление", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
using (SqlConnection sqlCon = new SqlConnection(Main.Connection))
{
sqlCon.Open();
if (!forEdit)
{
switch (owner)
{
case "btnTrainees":
traineesTableAdapter.Insert(
Controls[2].Text,
Controls[3].Text,
((DateTimePicker)Controls[4]).Value,
Controls[5].Text,
Controls[6].Text
);
break;
case "btnLectures":
lecturerTableAdapter.Insert(
Controls[2].Text,
Controls[3].Text,
Int32.Parse(Controls[4].Text),
Controls[5].Text,
Controls[6].Text
);
break;
case "btnGroup":
groupTableAdapter.Insert(
Controls[2].Text,
Controls[3].Text,
Int32.Parse(Controls[4].Text));
break;
case "btnCourses":
courseTableAdapter.Insert(
Controls[2].Text,
Controls[3].Text);
break;
case "btnExams":
examTableAdapter.Insert(
Int32.Parse(Controls[6].Text.Substring(4)),
Int32.Parse(Controls[3].Text),
((DateTimePicker)Controls[4]).Value,
Int32.Parse(Controls[5].Text));
break;
case "btnDiscipline":
disciplineTableAdapter.Insert(
Controls[2].Text,
Int32.Parse(Controls[3].Text),
Controls[5].Text);
break;
case "btnPayment":
paymentTableAdapter.Insert(
Int32.Parse(Controls[6].Text.Substring(4)),
Int32.Parse(Controls[3].Text),
((DateTimePicker)Controls[4]).Value,
Int32.Parse(Controls[5].Text));
break;
case "btnTimeSheet":
timeSheetTableAdapter.Insert(
Int32.Parse(Controls[2].Text),
Int32.Parse(Controls[7].Text.Substring(4)),
Controls[4].Text,
Int32.Parse(Controls[5].Text),
Int32.Parse(Controls[6].Text));
break;
}
}
else
{
switch (owner)
{
case "btnTrainees":
traineesTableAdapter.UpdateQuery(
Controls[2].Text,
Controls[3].Text,
((DateTimePicker)Controls[4]).Value,
Controls[5].Text,
Controls[6].Text,
Int32.Parse(id));
break;
case "btnLectures":
lecturerTableAdapter.UpdateQuery(
Controls[2].Text,
Controls[3].Text,
Int32.Parse(Controls[4].Text),
Controls[5].Text,
Controls[6].Text,
Int32.Parse(id));
break;
case "btnGroup":
groupTableAdapter.UpdateQuery(
Controls[2].Text,
Controls[3].Text,
Int32.Parse(Controls[4].Text));
break;
case "btnCourses":
courseTableAdapter.UpdateQuery(
Controls[2].Text,
Controls[3].Text);
break;
case "btnExams":
examTableAdapter.UpdateQuery(
Int32.Parse(Controls[6].Text.Substring(4)),
Int32.Parse(Controls[3].Text),
((DateTimePicker)Controls[4]).Value.ToString(),
Int32.Parse(Controls[5].Text));
break;
case "btnDiscipline":
disciplineTableAdapter.UpdateQuery(
Controls[2].Text.Trim(),
Int32.Parse(Controls[3].Text),
Controls[5].Text,
Int32.Parse(id));
break;
case "btnPayment":
paymentTableAdapter.UpdateQuery(
Int32.Parse(Controls[6].Text.Substring(4)),
Int32.Parse(Controls[3].Text),
((DateTimePicker)Controls[4]).Value.ToString(),
Int32.Parse(Controls[5].Text));
break;
case "btnTimeSheet":
timeSheetTableAdapter.UpdateQuery(
Int32.Parse(Controls[2].Text),
Int32.Parse(Controls[7].Text.Substring(4)),
Controls[4].Text,
Int32.Parse(Controls[5].Text),
Int32.Parse(Controls[6].Text),
Int32.Parse(id));
break;
}
}
CourseDataSet.AcceptChanges();
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(@"Error: " + ex.Message);
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
btnNext.Visible = false;
object[] args = null;
UpdateDb();
try
{
switch (owner)
{
case "btnTrainees":
var st = new CourseDataSet.TraineesDataTable();
traineesTableAdapter.FillBy(st, Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
args = st.Rows[0].ItemArray;
break;
case "btnLectures":
var st1 = new CourseDataSet.LecturerDataTable();
lecturerTableAdapter.FillBy(st1, Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
args = st1.Rows[0].ItemArray;
break;
case "btnGroup":
var st2 = new CourseDataSet.GroupDataTable();
groupTableAdapter.FillBy(st2, dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
args = st2.Rows[0].ItemArray;
break;
case "btnCourses":
var st3 = new CourseDataSet.CourseDataTable();
courseTableAdapter.FillBy(st3, dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
args = st3.Rows[0].ItemArray;
break;
case "btnExams":
var st4 = new CourseDataSet.ExamDataTable();
examTableAdapter.FillBy(st4, dataGridView1.SelectedRows[0].Cells[2].Value.ToString(), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[1].Value), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
args = st4.Rows[0].ItemArray;
break;
case "btnDiscipline":
var st5 = new CourseDataSet.DisciplineDataTable();
disciplineTableAdapter.FillBy(st5, Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
args = st5.Rows[0].ItemArray;
break;
case "btnPayment":
var st6 = new CourseDataSet.PaymentDataTable();
paymentTableAdapter.FillBy(st6, Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value), Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[1].Value));
args = st6.Rows[0].ItemArray;
break;
case "btnTimeSheet":
var st7 = new CourseDataSet.TimeSheetDataTable();
timeSheetTableAdapter.FillBy(st7, Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value));
args = st7.Rows[0].ItemArray;
break;
}
(new Edit(owner, args)).ShowDialog();
CourseDataSet.AcceptChanges();
FillDb();
this.Refresh();
}
catch (ArgumentOutOfRangeException ex)
{
MessageBox.Show("\tПожалуйста, выберите данные", "\tОшибка");
}
}