public void CustDelte(int CustID)
{
using (VideoEntities3 context = new VideoEntities3())
{
Customer obj = context.Customers.First(x => x.CustID == CustID); //this delete the cust id if it matches the varable
context.Customers.Remove(obj);
context.SaveChanges(); //this saves the changes
}
}
public void VideoDelte(int movieID)
{
using (VideoEntities3 context = new VideoEntities3())
{
Movy obj = context.Movies.First(x => x.MovieID == movieID); //this delte the row where movie id matches with variable
context.Movies.Remove(obj);
context.SaveChanges(); //this saves the changes
}
}
public void CustUpdate(int CustID, string Firstname, string lastname, string phone, string address)
{
using (var db = new VideoEntities3())
{
var result = db.Customers.SingleOrDefault(b => b.CustID == CustID);//this updates the whole row where cust id is same as varable
if (result != null)
{
result.FirstName = Firstname;
result.LastName = lastname;
result.Phone = phone;
result.Address = address;
db.SaveChanges();//this saves the changes
}
}
}
public void VideoUpdate(int movieID, string Title, string Rateing, string copies, string Genre, string Plot, string Year)
{
using (var db = new VideoEntities3())
{
var result = db.Movies.SingleOrDefault(b => b.MovieID == movieID);//this updates the roe where movie id matches with variable
if (result != null)
{
result.Title = Title;
result.Rating = Rateing;
result.Genre = Genre;
result.Plot = Plot;
result.Copies = copies;
result.Year = Year;
db.SaveChanges();//this saves the changes
}
}
}
protected void Login_Click(object sender, EventArgs e)
{
String id = Login_txt.Text;
VideoEntities3 db = new VideoEntities3();
string query = (from c in db.Logins//this checks the login info from the database
where c.UserName == id && c.Password == Password_txt.Text
select c.UserName).FirstOrDefault();
if (query != null)
{
Response.Redirect("Video.aspx");//if login info is right this opens the video page
}
else
{
Response.Write("Invalid User");//if login info is worng it shows the error
}
}
