}//txtInsertBox
//
// Instert Review :
//
private void addReview_Click(object sender, EventArgs e)
{
if (this.txtInsertBox.Text == "")
{
MessageBox.Show("Please select a Movie name , User Name and enter Review..");
return;
}
if (this.lstMovies.SelectedIndex < 0)
{
MessageBox.Show("Please select a movie...");
return;
}
if (this.lstUserName.SelectedIndex < 0)
{
MessageBox.Show("Please select a UserName...");
return;
}
int input = System.Int32.Parse(this.txtInsertBox.Text);
if (input < 0 || input > 5)
{
MessageBox.Show("Please enter Rating between 1 to 5...");
return;
}
int movieid = System.Int32.Parse(this.textMovieID.Text);
int userid = System.Int32.Parse(this.txtUserID.Text);
BusinessTier.Business biztier = new BusinessTier.Business(this.txtDatabase.Text);
BusinessTier.Review review = biztier.AddReview(movieid, userid, input);
MessageBox.Show("Review is added...");
//this.lstReviews.Items.Add(review.UserID.ToString());
//this.lstReview1.Items.Add(review.MovieID.ToString());
}//end of the insert review event:
private void button2_Click(object sender, EventArgs e)
{
string dbfilename = this.textBox1.Text;
BusinessTier.Business biztier = new BusinessTier.Business(dbfilename);
if (!biztier.TestConnection())
{
return;
}
if (textBox5.Text.Length == 0)
{
return;
}
int movieID = Convert.ToInt32(textBox5.Text);
if (textBox6.Text.Length == 0)
{
return;
}
int userID = Convert.ToInt32(textBox6.Text);
if (comboBox1.Text.Length == 0)
{
return;
}
int rating = Convert.ToInt32(comboBox1.Text);
BusinessTier.Review review = biztier.AddReview(movieID, userID, rating);
if (review == null)
{
MessageBox.Show("Failed");
}
else
{
MessageBox.Show("Success");
}
}
private void button6_Click(object sender, EventArgs e)
{
String dbfilename = this.dbname.Text; // get DB name from text box:
BusinessTier.Business biztier = new BusinessTier.Business(dbfilename);
if (biztier.TestConnection())
{
int mid, uid, rating;
if (this.listBox1.SelectedIndex < 0)
{
MessageBox.Show("Please select a movie");
return;
}
else
{
mid = Convert.ToInt32(this.textBox9.Text);
}
if (this.listBox2.SelectedIndex < 0)
{
MessageBox.Show("Please select a user");
return;
}
else
{
uid = Convert.ToInt32(this.textBox1.Text);
}
if (this.textBox6.Text.Length == 0)
{
MessageBox.Show("Please enter a rating");
return;
}
else
{
rating = Convert.ToInt32(this.textBox6.Text);
}
if (rating < 1 || rating > 5)
{
MessageBox.Show("Rating must range from 1-5");
return;
}
else
{
BusinessTier.Review newreview = biztier.AddReview(mid, uid, rating);
if (newreview != null)
{
MessageBox.Show("Success!");
return;
}
else
{
MessageBox.Show("Failed to add review");
return;
}
}
}
else
{
MessageBox.Show("Connection could not be established");
return;
}
}
private void insertReviewBUTTON_Click(object sender, EventArgs e)
{
string insertMovie = insertReviewMovieTEXTBOX.Text;
string insertUser = insertReviewUserTEXTBOX.Text;
string insertRating = insertReviewRatingTEXTBOX.Text;
int insertRate;
bool m = false;
bool u = false;
bool r = false;
if (int.TryParse(insertReviewRatingTEXTBOX.Text, out insertRate))
{
if (insertRate >= 1 && insertRate <= 5)
{
r = true;
}
}
else
{
MessageBox.Show("Input ERROR");
}
// Check to make sure database filename in text box actually exists:
string filename = this.filenameTEXTBOX.Text;
if (!fileExists(filename))
{
return;
}
//
// check movie name exist
string version, connectionInfo;
SqlConnection db;
version = "MSSQLLocalDB";
connectionInfo = String.Format(@"Data Source=(LocalDB)\{0};AttachDbFilename=|DataDirectory|\{1};Integrated Security=True;", version, filename);
db = new SqlConnection(connectionInfo);
db.Open();
string sql = string.Format(@"SELECT MovieName FROM Movies ORDER BY MovieName ASC;");
SqlCommand cmd = new SqlCommand();
cmd.Connection = db;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
cmd.CommandText = sql;
adapter.Fill(ds);
db.Close();
foreach (DataRow row in ds.Tables["TABLE"].Rows)
{
string msg = string.Format("{0}", Convert.ToString(row["MovieName"]));
if (msg == insertMovie)
{
m = true;
}
}
// check user exist
SqlConnection db2;
version = "MSSQLLocalDB";
connectionInfo = String.Format(@"Data Source=(LocalDB)\{0};AttachDbFilename=|DataDirectory|\{1};Integrated Security=True;", version, filename);
db2 = new SqlConnection(connectionInfo);
db2.Open();
string sql2 = string.Format(@"SELECT UserName FROM Users ORDER BY UserName ASC;");
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = db2;
SqlDataAdapter adapter2 = new SqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
cmd2.CommandText = sql2;
adapter2.Fill(ds2);
db2.Close();
foreach (DataRow row in ds2.Tables["TABLE"].Rows)
{
string msg = string.Format("{0}", Convert.ToString(row["UserName"]));
if (msg == insertUser)
{
u = true;
}
}
// insert if valid
if (m && u && r)
{
BusinessTier.Business biztier = new BusinessTier.Business(filename);
var insUser = biztier.GetNamedUser(insertUser);
int userID = insUser.UserID;
var insMovie = biztier.GetMovie(insertMovie);
int movieID = insMovie.MovieID;
BusinessTier.Review newReview = biztier.AddReview(movieID, userID, insertRate);
if (newReview != null)
{
MessageBox.Show("Insert Successful");
}
else
{
MessageBox.Show("Fail inserting");
}
}
else
{
MessageBox.Show("Input ERROR");
}
}
