public ActionResult createMovies(Movies m, Login l)
{
try
{
byte[] fileData = null;
if ((m.Files.Count > 0) && (m.Files != null))
{
using (var binaryReader = new BinaryReader(m.Files[0].InputStream))
{
fileData = binaryReader.ReadBytes(m.Files[0].ContentLength);
}
}
using (var context = new Mycontext())
{
m.Image = fileData;
var movies = context.Movies.Add(m);
var login = context.Login.Add(l);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (SystemException)
{
using (var context = new Mycontext())
{
var movies = context.Movies.Add(m);
var login = context.Login.Add(l);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
static void Main(string[] args)
{
using(Mycontext db=new Mycontext())
{
//insert new record
//Student s = new Student() { name = "raj", age = 12, std = "IV" };
//db.Student.Add(s);
//db.SaveChanges();
//fetch record
//Student s = db.Student.Find(1);//return single record using primary key
//Console.WriteLine("welcome{0}", s.name);
//fetch one record using nonprimary key
//Student s1 = db.Student.SingleOrDefault(i => i.name == "raj");//for single( non primary key)
/* List<Student> list = db.Student.Where(i => i.age == 10).ToList();*///for multiple values(non primary key)
//List<Student> list1 = db.Student.Where(i => i.age == 10 && i.std == "II").ToList();
////update record
//Student s2 = db.Student.Find(1);
//s2.age = 11;
//db.Student.Update(s2);
//db.SaveChanges();
//delete record
List<Student> list = db.Student.Where(i => i.name== "raj").ToList();
foreach (var stu in list)
{
db.Student.Remove(stu);
db.SaveChanges();
}
}
}
public ActionResult UpdateMovies(int id)
{
using (var context = new Mycontext())
{
var movies = context.Movies.Where(Movies => Movies.id == id).FirstOrDefault();
return(View(movies));
}
}
public Debitos()
{
//No construtor teriamos um ID com o contexto ou podemos criar um classe bunisses para fazer este debito
//e varias outras regras de negocios.
// estou estanciando mais como iria vim pelo ID so setaria o contexto
fakeContext = new Mycontext();
}
public ActionResult CreateLogin(Login l)
{
using (var context = new Mycontext())
{
var login = context.Login.Add(l);
context.SaveChanges();
return(View("Sucess"));
}
}
// GET: Compagny
public ActionResult Index()
{
using (var context = new Mycontext())
{
var movies = context.Movies.ToList();
//return View(movies);
}
return(View(Repository.listCompagny));
}
public ActionResult DeleteMovies(int id)
{
using (var context = new Mycontext())
{
var movies = context.Movies.Where(Movies => Movies.id == id);
context.Movies.RemoveRange(movies);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public virtual List <T> GetAll()
{
try
{
dbContext = new Mycontext();
return(dbContext.Set <T>().ToList());
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int Update()
{
try
{
dbContext = dbContext ?? new Mycontext();
return(dbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public virtual T GetById(TId id)
{
try
{
dbContext = new Mycontext();
return(dbContext.Set <T>().Find(id));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual int Delete(T entity)
{
try
{
dbContext = dbContext ?? new Mycontext();
dbContext.Set <T>().Remove(entity);
return(dbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
static void Main(string[] args)
{
using (Mycontext db = new Mycontext())
{
//Item it = new Item() { itemName = "steve" };
//db.Add(it);
//db.SaveChanges();
Order o = new Order()
{
itemId = 2, orderdate = new DateTime(2019, 11, 2), deliverydate = DateTime.Parse("11-11-2019")
};
db.Add(o);
db.SaveChanges();
}
}
public ActionResult UpdateMovie(Movies m)
{
using (var context = new Mycontext())
{
var movieInDatabase = context.Movies.Where(Movies => Movies.id == m.id).FirstOrDefault();
movieInDatabase.Name = m.Name;
movieInDatabase.Nationality = m.Nationality;
movieInDatabase.Resume = m.Resume;
movieInDatabase.Actors = m.Actors;
movieInDatabase.Categories = m.Categories;
movieInDatabase.Date = m.Date;
movieInDatabase.Director = m.Director;
context.SaveChanges();
return(RedirectToAction("Index"));
}
//contact.name = c.name;
//contact.number = c.number;
//return RedirectToAction("DetailsContact", new { id = c.id });
}
static void Main(string[] args)
{
using (Mycontext db = new Mycontext())
{
// Student s = new Student() { Sname = "Karan", age = 10, Std = "II" };
//db.Students.Add(s);
//db.SaveChanges();
//Student s = db.Students.Find(1);
//Console.WriteLine("Welcome {0}", s.Sname);
Student s1 = db.Students.SingleOrDefault(i => i.Sname == "Rohan");
List <Student> list = db.Students.Where(i => i.age == 10).ToList();
List <Student> list1 = db.Students.Where(i => i.age == 10 && i.Std == "II").ToList();
Student s2 = db.Students.Find(2);
s2.age = 11;
db.Students.Update(s2);
db.SaveChanges();
Student s3 = db.Students.SingleOrDefault(i => i.Sname == "Rohan");
db.Students.Remove(s3);
db.SaveChanges();
}
}
public OrderRepository(Mycontext db)
{
_db = db;
}
public CartegoryRepository(Mycontext db)
{
_db = db;
}
public CartItemRepository(Mycontext db)
{
_db = db;
}
public SubCategoryRepository(Mycontext db)
{
_db = db;
}
public HomeController(Mycontext context)
{
dbcontext = context;
}
public ProductRepository(Mycontext db)
{
_db = db;
}
public PictureRepository(Mycontext db)
{
_db = db;
}
