public List<Model.PlayTime> getPlayTimeList()
{
List<Model.PlayTime> lst = new List<Model.PlayTime>();
DataTable dt = DBUtility.SqlHelper.executeTable("select * from PlayTimes", CommandType.Text, null);
foreach (DataRow item in dt.Rows)
{
Model.PlayTime emp = new Model.PlayTime() { PlaytimeID = int.Parse(item[0].ToString()),
MovieID =int.Parse( item[1].ToString()), CinemaID =int.Parse( item[2].ToString()),
Playtime =DateTime.Parse( item[3].ToString()), PlayState =bool.Parse( item[4].ToString()) };
lst.Add(emp);
}
return lst;
//throw new NotImplementedException();
}
public List<Model.PlayTime> getPlayTimeList(int movieID, int cinemaID)
{
List<Model.PlayTime> lst = new List<Model.PlayTime>();
string sql = "SELECT * FROM PlayTimes WHERE MovieID=@movieID AND CinemaID=@cinemaID";
SqlParameter[] sps = new SqlParameter[]{
new SqlParameter(){ParameterName="@movieID",Value=movieID},
new SqlParameter(){ParameterName="@cinemaID",Value=cinemaID}
};
DataTable dt = DBUtility.SqlHelper.executeTable(sql, CommandType.Text, sps);
foreach (DataRow item in dt.Rows)
{
Model.PlayTime emp = new Model.PlayTime()
{
PlaytimeID = int.Parse(item[0].ToString()),
MovieID = int.Parse(item[1].ToString()),
CinemaID = int.Parse(item[2].ToString()),
Playtime = DateTime.Parse(item[3].ToString()),
PlayState = bool.Parse(item[4].ToString())
};
lst.Add(emp);
}
return lst;
//throw new NotImplementedException();
}
