public static FilmCategory GetFilmCategorySingle(SqlConnection dbcon, int id)
{
FilmCategory obj = new FilmCategory();
string strsql = "select * from FilmCategories where FikmID = " + id;
SqlCommand cmd = new SqlCommand(strsql, dbcon);
SqlDataReader myReader;
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
obj.FilmID = Convert.ToInt32(myReader["FilmID"].ToString());
obj.CategoryID = Convert.ToInt32(myReader["CategoryID"].ToString());
}
myReader.Close();
return(obj);
}
public static List <FilmCategory> GetFilmCategoryList(SqlConnection dbcon)
{
List <FilmCategory> itemlist = new List <FilmCategory>();
string strsql = "select * from FilmCategories";
SqlCommand cmd = new SqlCommand(strsql, dbcon);
SqlDataReader myReader;
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
FilmCategory obj = new FilmCategory();
obj.FilmID = Convert.ToInt32(myReader["FilmID"].ToString());
obj.CategoryID = Convert.ToInt32(myReader["CategoryID"].ToString());
itemlist.Add(obj);
}
myReader.Close();
return(itemlist);
}
public static int CUDFilmCategory(SqlConnection dbcon, string CUDAction, FilmCategory obj)
{
SqlCommand cmd = new SqlCommand();
if (CUDAction == "create")
{
cmd.CommandText = "insert into FilmCategories " +
"Values (@FilmID,@CategoryID)";
cmd.Parameters.AddWithValue("@FilmID", SqlDbType.Int).Value = obj.FilmID;
cmd.Parameters.AddWithValue("@CategoryID", SqlDbType.Int).Value = obj.CategoryID;
}
else if (CUDAction == "delete")
{
cmd.CommandText = "delete FilmCategories where FilmID = @FilmID";
cmd.Parameters.AddWithValue("@FilmID", SqlDbType.Int).Value = obj.FilmID;
}
cmd.Connection = dbcon;
int intResult = cmd.ExecuteNonQuery();
cmd.Dispose();
return(intResult);
}
