public void Register(string Firstname, string Lastname, int age)
{
Reg.FirstName = Firstname;
Reg.LastName = Lastname;
Reg.Age = age;
context.Registers.Add(Reg);
context.SaveChanges();
}
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 Cust_add(string Firstname, string lastname, string phone, string address)
{
cust.FirstName = Firstname;
cust.LastName = lastname;
cust.Phone = phone;//this puts the value of variable to databse
cust.Address = address;
context.Customers.Add(cust);
context.SaveChanges();//this save the changes to databse
}
public void VideoAdd(string Title, string Rateing, string copies, string Genre, string Plot, string Year)
{
vid.Title = Title;
vid.Rating = Rateing;//it adds the value of variable to the the database
vid.Genre = Genre;
vid.Plot = Plot;
vid.Copies = copies;
vid.Year = Year;
int rentalcost = Convert.ToInt32(Year);
vid.Rental_Cost = rentalcost <= 2014 ? 2 : 5;
context.Movies.Add(vid);
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
}
}
}