public JsonResult DeletetheMovie()
{
Movieinf movieinf = new Movieinf()
{
ID = Request.QueryString["id"]
};
int flag = manager.DeleteMovie(movieinf);
return(Json(flag, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchtheMovie()
{
Movieinf movieinf = new Movieinf()
{
ID = Request.QueryString["id"]
};
Movieinf movieinf1 = manager.SearchMovie(movieinf);
return(Json(movieinf1, JsonRequestBehavior.AllowGet));
}
public int InsertMovieinfs(Movieinf movieinf)
{
string id = movieinf.ID;
string name = movieinf.Name;
string type = movieinf.Type;
string time = movieinf.Time;
string ondate = movieinf.Ondate;
string outdate = movieinf.Outdate;
float price = movieinf.Price;
string intro = movieinf.Intro;
string url = movieinf.Url;
string checkString = "SELECT 影片ID,名字 FROM 影片";
string queryString = "INSERT INTO 影片 SET" + " 影片ID='" + id + "',名字='" + name + "'," +
"类型='" + type + "',时长='" + time + "',上映日期='" + ondate + "',下线日期='" + outdate + "'," +
"票价='" + price + "',简介='" + intro + "',图片url='" + url + "'";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
using (MySqlCommand command0 = new MySqlCommand())
{
command0.Connection = connection;
command0.CommandText = checkString;
MySqlDataReader reader = command0.ExecuteReader();
while (reader.Read())
{
if (id == reader["影片ID"].ToString() || name == reader["名字"].ToString())
{
reader.Close();
connection.Close();
return(0);
}
}
reader.Close();
}
using (MySqlCommand command1 = new MySqlCommand())
{
command1.Connection = connection;
command1.CommandText = queryString;
command1.ExecuteNonQuery();
}
connection.Close();
}
return(1);
}
public JsonResult SendNewMovie()
{
Movieinf movieinf = new Movieinf()
{
ID = Request.QueryString["newid"],
Name = Request.QueryString["name"],
Type = Request.QueryString["type"],
Time = Request.QueryString["time"],
Ondate = Request.QueryString["ondate"],
Outdate = Request.QueryString["outdate"],
Price = float.Parse(Request.QueryString["price"]),
Intro = Request.QueryString["introduction"],
Url = Request.QueryString["url"]
};
int flag = manager.InsertMovie(movieinf);
movieinf.flag = flag;
return(Json(movieinf, JsonRequestBehavior.AllowGet));
}
public Movieinf SearchMovieinfs(Movieinf movieinf)
{
string id = movieinf.ID;
Movieinf result = new Movieinf();
result.flag = 0;
string queryString = "SELECT 影片ID,名字,类型,时长,上映日期,下线日期,票价,简介,图片url FROM 影片";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = queryString;
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (id == reader["影片ID"].ToString())
{
result.flag = 1;
result.ID = reader["影片ID"].ToString();
result.Name = reader["名字"].ToString();
result.Type = reader["类型"].ToString();
result.Time = reader["时长"].ToString();
result.Ondate = reader["上映日期"].ToString();
result.Outdate = reader["下线日期"].ToString();
result.Price = (float)reader["票价"];
result.Intro = reader["简介"].ToString();
result.Url = reader["图片url"].ToString();
break;
}
}
reader.Close();
}
connection.Close();
}
return(result);
}
public int UpdateMovieinfs(Movieinf movieinf, string currentid)
{
int flag = 1;
string id = movieinf.ID;
string name = movieinf.Name;
string type = movieinf.Type;
string time = movieinf.Time;
string ondate = movieinf.Ondate;
string outdate = movieinf.Outdate;
float price = movieinf.Price;
string intro = movieinf.Intro;
string url = movieinf.Url;
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
if (id != currentid)
{
string checkString1 = "SELECT 影片ID,名字 FROM 影片 WHERE 影片ID!='" + currentid + "'";
string queryString1 = "START TRANSACTION;" +
"SET foreign_key_checks = 0;" +
"UPDATE 影片 SET 影片ID='" + id + "' WHERE 影片ID='" + currentid + "';" +
"UPDATE 场次 SET 影片ID='" + id + "' WHERE 影片ID='" + currentid + "';" +
"UPDATE 评论记录 SET 影片ID='" + id + "' WHERE 影片ID='" + currentid + "';" +
"UPDATE 收藏记录 SET 影片ID='" + id + "' WHERE 影片ID='" + currentid + "';" +
"SET foreign_key_checks = 1;COMMIT;";
using (MySqlCommand check1 = new MySqlCommand())
{
check1.Connection = connection;
check1.CommandText = checkString1;
MySqlDataReader reader = check1.ExecuteReader();
while (reader.Read())
{
if (id == reader["影片ID"].ToString() || name == reader["名字"].ToString())
{
reader.Close();
connection.Close();
flag = 2; //flag=2 账号id或昵称重复
return(flag);
}
}
reader.Close();
}
using (MySqlCommand command1 = new MySqlCommand())
{
command1.Connection = connection;
command1.CommandText = queryString1;
command1.ExecuteNonQuery();
}
}
else
{
string checkString2 = "SELECT 名字 FROM 影片 WHERE 影片ID!='" + currentid + "'";
using (MySqlCommand check2 = new MySqlCommand())
{
check2.Connection = connection;
check2.CommandText = checkString2;
MySqlDataReader reader = check2.ExecuteReader();
while (reader.Read())
{
if (name == reader["名字"].ToString())
{
reader.Close();
connection.Close();
flag = 3; //昵称重复
return(flag);
}
}
reader.Close();
}
}
string queryString2 = "UPDATE 影片 SET 名字='" + name + "',类型='" + type + "'," +
"时长='" + time + "',上映日期='" + ondate + "',下线日期='" + outdate + "',票价='" + price + "'," +
"简介='" + intro + "',图片url='" + url + "' WHERE 影片ID='" + id + "';";
using (MySqlCommand command2 = new MySqlCommand())
{
command2.Connection = connection;
command2.CommandText = queryString2;
command2.ExecuteNonQuery();
}
connection.Close();
}
return(flag);
}
public int DeleteMovieinfs(Movieinf movieinf)
{
string id = movieinf.ID;
int flag = 0;
List <string> sessions = new List <string>();
// List<int> number = new List<int>();
List <string> tickets = new List <string>();
string sessionid;
string ticketid;
string findSesString = "SELECT 场次ID FROM 场次 WHERE 影片ID='" + id + "'";
string deleteString = "START TRANSACTION;" +
"SET foreign_key_checks = 0;" +
"DELETE FROM 影片 WHERE 影片ID='" + id + "';" +
"DELETE FROM 场次 WHERE 影片ID='" + id + "';" +
"DELETE FROM 评论记录 WHERE 影片ID='" + id + "';" +
"DELETE FROM 收藏记录 WHERE 影片ID='" + id + "';" +
"SET foreign_key_checks = 1;COMMIT;";
//string queryString2 = "DELETE FROM 账号 WHERE 账号ID='" + account + "'";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
using (MySqlCommand ReadSession = new MySqlCommand())
{
ReadSession.Connection = connection;
ReadSession.CommandText = findSesString;
MySqlDataReader reader = ReadSession.ExecuteReader();
while (reader.Read())
{
sessionid = reader["场次ID"].ToString();
sessions.Add(sessionid);
}
reader.Close();
}
for (int i = 0; i < sessions.Count(); i++)
{
using (MySqlCommand ReadTicket = new MySqlCommand())
{
string ReadTstring = "SELECT 影票ID FROM 影票 WHERE 场次ID='" + sessions[i] + "'";
ReadTicket.Connection = connection;
ReadTicket.CommandText = ReadTstring;
MySqlDataReader reader1 = ReadTicket.ExecuteReader();
while (reader1.Read())
{
ticketid = reader1["影票ID"].ToString();
tickets.Add(ticketid);
}
reader1.Close();
}
}
for (int i = 0; i < tickets.Count(); i++)
{
using (MySqlCommand DeleteRecord = new MySqlCommand())
{
string DeleteRstring = "DELETE FROM 评分记录 WHERE 影票ID='" + tickets[i] + "'";
DeleteRecord.Connection = connection;
DeleteRecord.CommandText = DeleteRstring;
DeleteRecord.ExecuteNonQuery();
}
}
for (int i = 0; i < sessions.Count(); i++)
{
using (MySqlCommand DeleteTicket = new MySqlCommand())
{
string DeleteTstring = "DELETE FROM 影票 WHERE 场次ID='" + sessions[i] + "'";
DeleteTicket.Connection = connection;
DeleteTicket.CommandText = DeleteTstring;
DeleteTicket.ExecuteNonQuery();
}
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = deleteString;
command.ExecuteNonQuery();
}
flag = 1;
connection.Close();
}
return(flag);
}
public int UpdateMovie(Movieinf movieinf, string currentid)
{
int flag = repository.UpdateMovieinfs(movieinf, currentid);
return(flag);
}
public int DeleteMovie(Movieinf movieinf)
{
int flag = repository.DeleteMovieinfs(movieinf);
return(flag);
}
public Movieinf SearchMovie(Movieinf movieinf)
{
movieinf = repository.SearchMovieinfs(movieinf);
return(movieinf);
}
public int InsertMovie(Movieinf movieinf)
{
int flag = repository.InsertMovieinfs(movieinf);
return(flag);
}
