private void addmovie_Click(object sender, EventArgs e)
{
int a, b;
if (movie_title.Text == "" || movie_year.Text == "" || movie_rating.Text == "" || movie_copies.Text == "" || movie_plot.Text == "" || movie_gener.Text == "")
{
MessageBox.Show("****Fill mandatory fields*****");
}
else if (!int.TryParse(movie_year.Text, out a) || !(int.TryParse(movie_copies.Text, out b)))
{
MessageBox.Show("Year and Copies must be a correct value");
}
else
{
int rental = 0;
if ((DateTime.Now.Year - a) > 5)
{
rental = 2;
}
else
{
rental = 5;
}
DBContextHelper database = new DBContextHelper();
database.Create_Movie(movie_rating.Text, movie_title.Text, movie_year.Text, rental.ToString(), movie_copies.Text, movie_plot.Text, movie_gener.Text);
MessageBox.Show("Movie Added");
ALLHIDE();
}
}
private void button1_Click(object sender, EventArgs e)
{
int a, b;
if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb4.Text == "" || tb5.Text == "" || tb6.Text == "")
{
MessageBox.Show("****Fill mandatory fields*****");
}
else if (!int.TryParse(tb3.Text, out a) || !(int.TryParse(tb4.Text, out b)))
{
MessageBox.Show("Year and Copies must be a correct value");
}
else
{
int rental = 0;
if ((DateTime.Now.Year - a) > 5)
{
rental = 2;
}
else
{
rental = 5;
}
DBContextHelper database = new DBContextHelper();
database.CreateMovie(tb1.Text, tb2.Text, tb3.Text, rental.ToString(), tb4.Text, tb5.Text, tb6.Text);
MessageBox.Show("Movie Added");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
int a, b;
if (tbx_Rating.Text == "" || tbx_Title.Text == "" || tbx_Year.Text == "" || tbx_Copies.Text == "" || tbx_Plot.Text == "" || tbx_Genre.Text == "")
{
MessageBox.Show("****Fill compulsory fields*****");
}
else if (!int.TryParse(tbx_Year.Text, out a) || !(int.TryParse(tbx_Copies.Text, out b)))
{
MessageBox.Show("Year and Copies must have a correct value");
}
else
{
int rental = 0;
if ((DateTime.Now.Year - a) > 5)
{
rental = 2;
}
else
{
rental = 5;
}
DBContextHelper database = new DBContextHelper();
database.Update_Movie(tbx_Rating.Text, tbx_Title.Text, tbx_Year.Text, rental.ToString(), tbx_Copies.Text, tbx_Plot.Text, tbx_Genre.Text, MovieId);
MessageBox.Show("Movie Details Updated");
Dispose();
}
}
public EditCustomer(string CustomerId)
{
this.Id = CustomerId;
DataTable dtCustomers = new DBContextHelper().GetCustomerByID(Id);
InitializeComponent();
tbx_FirstName.Text = dtCustomers.Rows[0]["CustomerFirstName"].ToString();
tbx_LastName.Text = dtCustomers.Rows[0]["CustomerLastName"].ToString();
tbx_Address.Text = dtCustomers.Rows[0]["CustomerAddress"].ToString();
tbx_PhoneNo.Text = dtCustomers.Rows[0]["CustomerPhone"].ToString();
}
public EditCustomer(string Id)
{
this.Id = Id;
DataTable table = new DBContextHelper().GetCustByID(Id);
InitializeComponent();
tb1.Text = table.Rows[0]["FirstName"].ToString();
tb2.Text = table.Rows[0]["LastName"].ToString();
tb3.Text = table.Rows[0]["Address"].ToString();
tb4.Text = table.Rows[0]["Phone"].ToString();
}
public EditMovie(string Id)
{
MovieId = Id;
InitializeComponent();
DataTable table = new DBContextHelper().GetMovieByMovieID(MovieId);
tb1.Text = table.Rows[0]["Rating"].ToString();
tb2.Text = table.Rows[0]["Title"].ToString();
tb3.Text = table.Rows[0]["Year"].ToString();
tb4.Text = table.Rows[0]["Copies"].ToString();
tb5.Text = table.Rows[0]["Plot"].ToString();
tb6.Text = table.Rows[0]["Genre"].ToString();
}
public EditMovie(string movId)
{
MovieId = movId;
InitializeComponent();
DataTable dtMovies = new DBContextHelper().Get_Movie_By_MovieID(movId);
tbx_Rating.Text = dtMovies.Rows[0]["MoviesRatings"].ToString();
tbx_Title.Text = dtMovies.Rows[0]["MoviesTitle"].ToString();
tbx_Year.Text = dtMovies.Rows[0]["MoviesYear"].ToString();
tbx_Copies.Text = dtMovies.Rows[0]["MoviesCopies"].ToString();
tbx_Plot.Text = dtMovies.Rows[0]["MoviesPlot"].ToString();
tbx_Genre.Text = dtMovies.Rows[0]["MoviesGenre"].ToString();
}
private void addcustomer_Click(object sender, EventArgs e)
{
if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb.Text == "")
{
MessageBox.Show("****Fill mandatory fields*****");
}
else
{
DBContextHelper database = new DBContextHelper();
database.CreateCustomer(tb1.Text, tb2.Text, tb3.Text, tb.Text);
MessageBox.Show("Customer Added");
ALLHIDE();
}
}
private void returnToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Are you sure to reurn this rental?", "Return Confirmation", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string Date = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString();
DBContextHelper database = new DBContextHelper();
database.Return_Movie(Date, dataGridView1return.SelectedRows[0].Cells[0].Value.ToString());
MessageBox.Show("Movie Returned");
dataGridView1return.DataSource = new DBContextHelper().Movies_ToBe_Returned();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (tbx_FirstName.Text == "" || tbx_LastName.Text == "" || tbx_Address.Text == "" || tbx_PhoneNo.Text == "")
{
MessageBox.Show("****Fill cumpulsory fields*****");
}
else
{
DBContextHelper database = new DBContextHelper();
database.UpdateCustomer(tbx_FirstName.Text, tbx_LastName.Text, tbx_Address.Text, tbx_PhoneNo.Text, Id);
MessageBox.Show("Customer Details Updated");
Dispose();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (tb1.Text == "" || tb2.Text == "" || tb3.Text == "" || tb4.Text == "")
{
MessageBox.Show("****Fill mandatory fields*****");
}
else
{
DBContextHelper database = new DBContextHelper();
database.UpdateCust(tb1.Text, tb2.Text, tb3.Text, tb4.Text, Id);
MessageBox.Show("Customer Updated");
Dispose();
}
}
private void issueToolStripMenuItem_Click(object sender, EventArgs e)
{
int copies = new DBContextHelper().Check_Copies(Convert.ToInt32(gridmovie.SelectedRows[0].Cells[0].Value));
if (copies > 0)
{
Issue issueRental = new Issue(gridmovie.SelectedRows[0].Cells[0].Value.ToString());
issueRental.ShowDialog();
gridmovie.DataSource = new DBContextHelper().Get_All_Movies();
}
else
{
MessageBox.Show("No copy available to rent");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (tb2.Text == "")
{
MessageBox.Show("Enter valid Customer ID");
}
else
{
string Date = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString();
DBContextHelper database = new DBContextHelper();
database.IssueMovie(Id, customerid.Text, Date);
MessageBox.Show("Movie Rented");
Dispose();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (tbx_LastName.Text == "")
{
MessageBox.Show("Enter correct Customer ID");
}
else
{
string CurrentDate = DateTime.Now.ToString("MM/dd/yyyy") + " " + DateTime.Now.ToShortTimeString();
DBContextHelper database = new DBContextHelper();
database.Issue_Movie(Id, tbx_CustomerID.Text, CurrentDate);
MessageBox.Show("Movie is Rented");
Dispose();
}
}
private void CustID_TextChanged(object sender, EventArgs e)
{
tb1.Text = "";
tb2.Text = "";
tb3.Text = "";
tb4.Text = "";
DataTable table = new DBContextHelper().GetCustByID(customerid.Text);
if (table.Rows.Count > 0)
{
tb1.Text = table.Rows[0]["FirstName"].ToString();
tb2.Text = table.Rows[0]["LastName"].ToString();
tb3.Text = table.Rows[0]["Address"].ToString();
tb4.Text = table.Rows[0]["Phone"].ToString();
}
}
private void tbx_CustomerID_TextChanged(object sender, EventArgs e)
{
tbx_FirstName.Text = "";
tbx_LastName.Text = "";
tbx_Address.Text = "";
tbx_PhoneNo.Text = "";
DataTable dtCustomers = new DBContextHelper().GetCustomerByID(tbx_CustomerID.Text);
if (dtCustomers.Rows.Count > 0)
{
tbx_FirstName.Text = dtCustomers.Rows[0]["CustomerFirstName"].ToString();
tbx_LastName.Text = dtCustomers.Rows[0]["CustomerLastName"].ToString();
tbx_Address.Text = dtCustomers.Rows[0]["CustomerAddress"].ToString();
tbx_PhoneNo.Text = dtCustomers.Rows[0]["CustomerPhone"].ToString();
}
}
