// GET: api/ShowTime
public IEnumerable <ShowTime> Get(int genreRoomID)
{
List <ShowTime> showTimes = new List <ShowTime>();
string query = "SELECT s.*,f.FilmName,r.RoomName,gr.GenreRoomName FROM dbo.ShowTime s JOIN dbo.Film f ON f.FilmID = s.FilmID JOIN dbo.Room r ON s.RoomID = r.RoomID JOIN dbo.Genre_room gr ON gr.GenreRoomID = r.GenreRoomID WHERE f.Status = 1 ";
if (genreRoomID > 0)
{
query += " AND r.GenreRoomID = " + genreRoomID;
}
query += "ORDER BY s.StartTime , r.GenreRoomID , f.FilmName";
DataTable table = DataProvider.Instace.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
ShowTime item = new ShowTime();
item.FilmID = int.Parse(row["FilmID"].ToString());
item.RoomID = int.Parse(row["RoomID"].ToString());
item.ShowTimeID = int.Parse(row["ShowTimeID"].ToString());
item.StartTime = DateTime.Parse(row["StartTime"].ToString());
Film film = new Film();
film.FilmID = item.FilmID;
film.FilmName = row["FilmName"].ToString();
item.Film = film;
Room room = new Room();
room.RoomName = row["RoomName"].ToString();
Genre_room genre_Room = new Genre_room();
genre_Room.GenreRoomName = row["GenreRoomName"].ToString();
room.Genre_room = genre_Room;
item.Room = room;
showTimes.Add(item);
}
return(showTimes);
}
public ActionResult DeleteConfirmed(int id)
{
Genre_room genre_room = db.Genre_room.Find(id);
db.Genre_room.Remove(genre_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: api/GenreRoom/5
public Genre_room Get(int id)
{
string query = "SELECT * FROM dbo.Genre_room WHERE GenreRoomID = " + id;
DataTable table = DataProvider.Instace.ExecuteQuery(query);
Genre_room genre_Room = new Genre_room();
genre_Room.GenreRoomID = int.Parse(table.Rows[0]["GenreRoomID"].ToString());
genre_Room.GenreRoomName = table.Rows[0]["GenreRoomName"].ToString();
return(genre_Room);
}
public ActionResult Edit([Bind(Include = "GenreRoomID,GenreRoomName")] Genre_room genre_room)
{
if (ModelState.IsValid)
{
db.Entry(genre_room).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre_room));
}
public ActionResult Create([Bind(Include = "GenreRoomID,GenreRoomName")] Genre_room genre_room)
{
if (ModelState.IsValid)
{
db.Genre_room.Add(genre_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre_room));
}
// PUT: api/GenreRoom/5
public int Put(int id, [FromBody] Genre_room value)
{
string query = "UPDATE dbo.Genre_room SET GenreRoomName = N'" + value.GenreRoomName + "' WHERE GenreRoomID = " + id;
try
{
int res = DataProvider.Instace.ExecuteNonQuery(query);
}
catch (SqlException)
{
return(0);
}
return(1);
}
// POST: api/GenreRoom
public int Post([FromBody] Genre_room value)
{
string query = "INSERT dbo.Genre_room(GenreRoomName)VALUES(N'" + value.GenreRoomName + "')";
try
{
int res = DataProvider.Instace.ExecuteNonQuery(query);
}
catch (SqlException)
{
return(0);
}
return(1);
}
// GET: Admin/Genre_room/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Genre_room genre_room = db.Genre_room.Find(id);
if (genre_room == null)
{
return(HttpNotFound());
}
return(View(genre_room));
}
// GET: api/GenreRoom
public IEnumerable <Genre_room> Get()
{
List <Genre_room> genre_room = new List <Genre_room>();
string query = "SELECT * FROM dbo.Genre_room";
DataTable table = DataProvider.Instace.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
Genre_room item = new Genre_room();
item.GenreRoomID = int.Parse(row["GenreRoomID"].ToString());
item.GenreRoomName = row["GenreRoomName"].ToString();
genre_room.Add(item);
}
return(genre_room);
}
// GET: api/Rooms/5
public Room Get(int id)
{
string query = "SELECT r.* , gr.GenreRoomName FROM dbo.Room r JOIN dbo.Genre_room gr ON gr.GenreRoomID = r.GenreRoomID WHERE r.RoomID = " + id;
DataTable table = DataProvider.Instace.ExecuteQuery(query);
Room room = new Room();
room.RoomID = int.Parse(table.Rows[0]["RoomID"].ToString());
room.RoomName = table.Rows[0]["RoomName"].ToString();
room.StatusRoom = byte.Parse(table.Rows[0]["StatusRoom"].ToString());
room.GenreRoomID = int.Parse(table.Rows[0]["GenreRoomID"].ToString());
room.RoomID = int.Parse(table.Rows[0]["RoomID"].ToString());
Genre_room genre_Room = new Genre_room();
genre_Room.GenreRoomID = room.GenreRoomID;
genre_Room.GenreRoomName = table.Rows[0]["GenreRoomName"].ToString();
room.Genre_room = genre_Room;
return(room);
}
// GET: api/Rooms
public IEnumerable <Room> GetRooms()
{
List <Room> room = new List <Room>();
string query = "SELECT r.* , gr.GenreRoomName FROM dbo.Room r JOIN dbo.Genre_room gr ON gr.GenreRoomID = r.GenreRoomID";
DataTable table = DataProvider.Instace.ExecuteQuery(query);
foreach (DataRow row in table.Rows)
{
Room item = new Room();
item.RoomID = int.Parse(row["RoomID"].ToString());
item.RoomName = row["RoomName"].ToString();
item.StatusRoom = byte.Parse(row["StatusRoom"].ToString());
item.GenreRoomID = int.Parse(row["GenreRoomID"].ToString());
Genre_room genre_Room = new Genre_room();
genre_Room.GenreRoomID = int.Parse(row["GenreRoomID"].ToString());
genre_Room.GenreRoomName = row["GenreRoomName"].ToString();
item.Genre_room = genre_Room;
room.Add(item);
}
return(room);
}
