public static void Create_Seats(Park_Database.Service.Park_Seats_Service db)
{
Park_Database.Model.Park_Seats PS = new Park_Database.Model.Park_Seats();
PS.Seats_Area = "B";
for (int i = 1; i < 11; i++)
{
PS.Seats_Num = PS.Seats_Area + i.ToString("00");
db.Create(PS);
}
Console.WriteLine("區域位置資料創建完成");
}
public void Create(Park_Database.Model.Park_Seats CP)
{
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = string.Format(@"
INSERT INTO Park_Seats(Seats_Num,Seats_Area)
VALUES (N'{0}',N'{1}')
", CP.Seats_Num, CP.Seats_Area);
command.ExecuteNonQuery();
connection.Close();
}
public List <Park_Database.Model.Park_Seats> LoadAll()
{
List <Park_Database.Model.Park_Seats> result = new List <Park_Database.Model.Park_Seats>();
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = "Select * from Park_Seats";
var reader = command.ExecuteReader();
while (reader.Read())
{
Park_Database.Model.Park_Seats item = new Park_Database.Model.Park_Seats();
item.Seats_Num = reader["Seats_Num"].ToString();
item.Seats_Area = reader["Seats_Area"].ToString();
result.Add(item);
}
connection.Close();
return(result);
}
