private void BtnCourseNew_Click(object sender, EventArgs e) { try { using (SqlConnection connecting = new SqlConnection(Program.connection)) { connecting.Open(); SqlCommand cmd = connecting.CreateCommand(); //Добавление документа cmd.CommandText = "INSERT INTO [Documents] (TypeDoc, [Group], IdStudent, StatusDoc, Utrata, Obmen, Unichtog, SeriesDoc, NumberDoc, RegNumber, DateIssued) VALUES ('" + Convert.ToString(CbTypeDoc.Text) + "', '" + Convert.ToString(CbGroup.Text) + "','" + Convert.ToInt32(TbStudent.Text) + "','" + CbStatusDoc.Text + "', '" + CbUtrata.Text + "','" + CbObmen.Text + "', '" + CbUnichtog.Text + "', '" + TbSeriesDoc.Text + "', '" + Convert.ToInt32(TbNumberDoc.Text) + "', '" + Convert.ToInt32(TbRegNumber.Text) + "', '" + Convert.ToDateTime(dateTimedateissued.Value).ToShortDateString() + "')"; cmd.ExecuteScalar(); MessageBox.Show("Документ добавлен"); Documents ifrm = new Documents(); ifrm.Show(); this.Hide(); } } catch (Exception ex) { MessageBox.Show("Возникла ошибка: " + ex); } }
private void BtnEditDoc_Click(object sender, EventArgs e) { try { using (SqlConnection connecting = new SqlConnection(Program.connection)) { connecting.Open(); SqlCommand cmd = connecting.CreateCommand(); //Изменение данных о слушателе SqlCommand WriteCommand; WriteCommand = new SqlCommand("UPDATE [Documents] SET TypeDoc = @typedoc, [Group] = @group, IdStudent=@idstudent, StatusDoc=@statusdoc, Utrata = @utrata, Obmen = @obmen, Unichtog = @unichtog, SeriesDoc= @seriesdoc, NumberDoc = @numberdoc, RegNumber = @regnumber WHERE ID = @ID", connecting); WriteCommand.Parameters.AddWithValue("typedoc", CbTypeDoc.Text); WriteCommand.Parameters.AddWithValue("group", CbGroup.Text); WriteCommand.Parameters.AddWithValue("idstudent", TbStudent.Text); WriteCommand.Parameters.AddWithValue("statusdoc", CbStatusDoc.Text); WriteCommand.Parameters.AddWithValue("utrata", CbUtrata.Text); WriteCommand.Parameters.AddWithValue("obmen", CbObmen.Text); WriteCommand.Parameters.AddWithValue("unichtog", CbUnichtog.Text); WriteCommand.Parameters.AddWithValue("seriesdoc", TbSeriesDoc.Text); WriteCommand.Parameters.AddWithValue("numberdoc", Convert.ToInt32(TbNumberDoc.Text)); WriteCommand.Parameters.AddWithValue("regnumber", Convert.ToInt32(TbRegNumber.Text)); WriteCommand.Parameters.AddWithValue("ID", Convert.ToInt32(id)); WriteCommand.ExecuteNonQuery(); MessageBox.Show("Данные о документе изменены"); connecting.Close(); } Documents ifrm = new Documents(); ifrm.Show(); this.Hide(); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); } }
private void button2_Click_1(object sender, EventArgs e) { Forms.Documents frm = new Forms.Documents(); frm.Show(); this.Hide(); }