public List <dtoShowingRoom> GetShowingRooms()
{
dalShowingRoom dalShowingRoom = new dalShowingRoom();
List <dtoShowingRoom> listEmp = new List <dtoShowingRoom>();
DataTable ShowingRooms = dalShowingRoom.GetShowingRooms();
for (int i = 0; i < ShowingRooms.Rows.Count; i++)
{
dtoShowingRoom ShowingRoom = new dtoShowingRoom();
DataRow row = ShowingRooms.Rows[i];
ShowingRoom.RoomID = Convert.ToInt32(row[0]);
ShowingRoom.RoomType = row[1].ToString();
ShowingRoom.NumberOfSeats = Convert.ToInt32(row[2]);
listEmp.Add(ShowingRoom);
}
return(listEmp);
}
/// <summary>
/// Hàm thêm phòng chiếu
/// </summary>
/// <param name="room"></param>
/// <returns></returns>
public int InsertShowingRoom(dtoShowingRoom room)
{
int count = 0;
try
{
string sql = "INSERT [dbo].[ShowingRoom] ([RoomType], [NumberOfSeats]) VALUES ( @RoomType, @NumberOfSeats)";
SqlParameter parameterRoomType = new SqlParameter("@RoomType", SqlDbType.NVarChar);
parameterRoomType.Value = room.RoomType;
SqlParameter parameterNumberOfSeats = new SqlParameter("@NumberOfSeats", SqlDbType.Int);
parameterNumberOfSeats.Value = room.NumberOfSeats;
count = InsertUpdateDeleteData(sql, new[] { parameterRoomType, parameterNumberOfSeats });
}
finally
{
CloseConnection();
}
return(count);
}
/// <summary>
/// Hàm cập nhập phòng chiếu
/// </summary>
/// <param name="room"></param>
/// <returns></returns>
public int UpdateShowingRoom(dtoShowingRoom room)
{
int count = 0;
try
{
string sql = "UPDATE [dbo].[ShowingRoom] SET [RoomType] = @RoomType, [NumberOfSeats] = @NumberOfSeats WHERE [RoomID] = @RoomID";
SqlParameter parameterRoomID = new SqlParameter("@RoomID", SqlDbType.Int);
parameterRoomID.Value = room.RoomID;
SqlParameter parameterRoomType = new SqlParameter("@RoomType", SqlDbType.NVarChar);
parameterRoomType.Value = room.RoomType;
SqlParameter parameterNumberOfSeats = new SqlParameter("@NumberOfSeats", SqlDbType.Int);
parameterNumberOfSeats.Value = room.NumberOfSeats;
count = InsertUpdateDeleteData(sql, new[] { parameterRoomType, parameterNumberOfSeats });
}
finally
{
CloseConnection();
}
return(count);
}
