public static bool AddMovie(string title, string releasedate, string genre, float price, string rate)
{
string sqlstr = "insert into Movies(Title,ReleaseDate,Genre,Price,Rate) values('<title>','<releasedate>','<genre>',<price>,'<rate>')";
sqlstr = sqlstr.Replace("<title>", escape(title))
.Replace("<releasedate>", escape(releasedate))
.Replace("<genre>", escape(genre))
.Replace("<price>", price.ToString())
.Replace("<rate>", escape(rate));
return(DataBaseUtility.ExeSqlNoRes(sqlstr));
}
public static bool UpdateMovie(long id, string title, string releasedate, string genre, float price, string rate)
{
string sqlstr = "Update Movies Set Title = '<title>',ReleaseDate = '<releasedate>',Genre = '<genre>',price = <price>,rate = '<rate>' where Id = <id>";
sqlstr = sqlstr.Replace("<id>", id.ToString())
.Replace("<title>", escape(title))
.Replace("<releasedate>", escape(releasedate))
.Replace("<genre>", escape(genre))
.Replace("<price>", price.ToString())
.Replace("<rate>", escape(rate));
return(DataBaseUtility.ExeSqlNoRes(sqlstr));
}
public static bool DeleteMovie(long id)
{
string sqlstr = "Delete from Movies where Id =" + id.ToString();
return(DataBaseUtility.ExeSqlNoRes(sqlstr));
}