public void InsertinDB()
{
MSSQLConnector connector = new MSSQLConnector();
connector.OpenConnect();
string rqst = "INSERT INTO Регионы (Название) VALUES ('" + this.Name + "')";
SqlCommand command2 = new SqlCommand(rqst, connector.conn);
command2.ExecuteNonQuery();
connector.CloseConnect();
}
public void InsertinDB()
{
MSSQLConnector connector = new MSSQLConnector();
connector.OpenConnect();
string rqst = @"INSERT INTO Страны (Название, [Код страны], Площадь, Население, Регион, Столица) VALUES "
+ "('" + this.Name + "','" + this.Code + "'," + this.Area + "," + this.Population + "," + this.Reg.Id + "," + this.Cap.Id + ")";
this.Show();
SqlCommand command2 = new SqlCommand(rqst, connector.conn);
command2.ExecuteNonQuery();
connector.CloseConnect();
}
//ISQLUPDATE Interface Implementation
public void UpdateRecord()
{
MSSQLConnector connector = new MSSQLConnector();
connector.OpenConnect();
string rqst = @"UPDATE Страны SET Название = '" + this.Name + "', [Код страны]= '" + this.Code + "', Площадь=" + this.Area +
",Население=" + this.Population + ", Регион =" + this.Reg.Id + ", Столица = " + this.Cap.Id + " WHERE id=" + this.Id;;
SqlCommand command = new SqlCommand(rqst, connector.conn);
command.ExecuteNonQuery();
System.Windows.Forms.MessageBox.Show(this.Name + " data was updated");
connector.CloseConnect();
}
public ArrayList FindIfExist()
{
MSSQLConnector connector = new MSSQLConnector();
connector.OpenConnect();
string rqst = "Select * from Города Where Название = '" + this.Name + "'";
SqlCommand command1 = new SqlCommand(rqst, connector.conn);
SqlDataReader dr = command1.ExecuteReader();
ArrayList tempArr = TransformResult(dr);
connector.CloseConnect();
if (tempArr.Count == 0)
{
tempArr.Add(new Models.Capital());
}
return(tempArr);
}
