//================== АБОНЕНТ ==================
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();
}
}
