//================== АБОНЕНТ ================== private void AddHumanButton_Click(object sender, EventArgs e) { var HumanForm = new AddHuman(); HumanForm.Text = "Добавление абонента"; if (HumanForm.ShowDialog() == DialogResult.OK) { var conn = new SqlConnection(connectionString); conn.Open(); string request = "INSERT INTO " + AbonentTableName + "(Last_Name, Name, Fathers_Name, Birth_Date, Adress, Commentary) "; request += "VALUES " + "('" + HumanForm.LastNameText.Text + "', '" + HumanForm.NameText.Text + "', '" + HumanForm.FathersNameText.Text + "', '" + HumanForm.DateHuman.Value.Month + "." + HumanForm.DateHuman.Value.Day + "." + HumanForm.DateHuman.Value.Year + "', '" + HumanForm.AdressText.Text + "', '" + HumanForm.CommentaryText.Text + "')"; var com = new SqlCommand(request, conn); com.ExecuteNonQuery(); conn.Close(); } updateAbonentDGW(); }
private void EditHumanButton_Click(object sender, EventArgs e) { var EditHumanForm = new AddHuman(); var mas = AbonentDGW.SelectedRows; var Candidat = mas[0].Cells[0].FormattedValue.ToString(); var conn = new SqlConnection(connectionString); conn.Open(); var getrequest = "SELECT Last_Name FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; var com = new SqlCommand(getrequest, conn); var last = com.ExecuteScalar(); EditHumanForm.LastNameText.Text = last.ToString(); getrequest = "SELECT Name FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; com = new SqlCommand(getrequest, conn); last = com.ExecuteScalar(); EditHumanForm.NameText.Text = last.ToString(); getrequest = "SELECT Fathers_Name FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; com = new SqlCommand(getrequest, conn); last = com.ExecuteScalar(); EditHumanForm.FathersNameText.Text = last.ToString(); getrequest = "SELECT Commentary FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; com = new SqlCommand(getrequest, conn); last = com.ExecuteScalar(); EditHumanForm.CommentaryText.Text = last.ToString(); getrequest = "SELECT Adress FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; com = new SqlCommand(getrequest, conn); last = com.ExecuteScalar(); EditHumanForm.AdressText.Text = last.ToString(); var getrequest_year = "SELECT YEAR(Birth_Date) FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; var com_year = new SqlCommand(getrequest_year, conn); int last_year = Convert.ToInt32(com_year.ExecuteScalar()); var getrequest_month = "SELECT MONTH(Birth_Date) FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; var com_month = new SqlCommand(getrequest_month, conn); int last_month = Convert.ToInt32(com_month.ExecuteScalar()); var getrequest_day = "SELECT DAY(Birth_Date) FROM Varpaev_HumanTable WHERE Id_Human = " + Candidat + ""; var com_day = new SqlCommand(getrequest_day, conn); int last_day = Convert.ToInt32(com_day.ExecuteScalar()); EditHumanForm.DateHuman.Value = new DateTime(last_year, last_month, last_day); if (EditHumanForm.ShowDialog() == DialogResult.OK) { conn = new SqlConnection(connectionString); conn.Open(); var request = "UPDATE " + AbonentTableName + " SET Varpaev_HumanTable.Last_Name='" + EditHumanForm.LastNameText.Text + "', " + "Varpaev_HumanTable.Name='" + EditHumanForm.NameText.Text + "', " + "Varpaev_HumanTable.Fathers_Name='" + EditHumanForm.FathersNameText.Text + "', " + "Varpaev_HumanTable.Adress='" + EditHumanForm.AdressText.Text + "'," + "Varpaev_HumanTable.Commentary='" + EditHumanForm.CommentaryText.Text + "'," + "Varpaev_HumanTable.Birth_Date='" + EditHumanForm.DateHuman.Value.Month + "." + EditHumanForm.DateHuman.Value.Day + "." + EditHumanForm.DateHuman.Value.Year + "' WHERE Id_Human = '" + Candidat + "'"; com = new SqlCommand(request, conn); com.ExecuteNonQuery(); conn.Close(); updateAbonentDGW(); updateBookDGW(); } }