static public void CreateTables(bool deleteBD)
{
try
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
// se flag for true deleta o banco
if (deleteBD)
{
db.Database.Delete();
}
// cria tabela de usuários e persiste dados padrões
var user = new User {
Name = "Paulo", Password = Common.MD5HashClass.Generate("123"), ConfirmPassword = Common.MD5HashClass.Generate("123"), UserGuid = Guid.NewGuid(), Email = "*****@*****.**"
};
db.Users.Add(user);
// cria tabela de gêneros e persiste dados padrões
var genre = new Genre {
Name = "Drama", CreationDate = DateTime.Now, Active = true
};
db.Genres.Add(genre);
// cria tabela de filmes e persiste dados padrões
var movie = new Movie {
Name = "Brilho Eterno de Uma Mente Sem Lembranças", Active = true, CreationDate = DateTime.Now, GenreId = genre.Id, Del = false
};
db.Movies.Add(movie);
//cria tabela de locações e persiste dados padrões
var location = new Location {
CPF = "000.000.000-00", LocationDate = DateTime.Now
};
db.Locations.Add(location);
//cria tabela de relacionamentos de locações
var locateRegister = new LocateRegister {
IdLocation = 1, IdMovie = 1
};
db.LocateRegisters.Add(locateRegister);
db.SaveChanges();
}
}
catch (DbEntityValidationException err)
{
//escreve log
Common.Log.Write("StartDB CreateTables", err.Message);
}
}
public JsonResult GetMovies(string Id)
{
ArrayList str = new ArrayList();
Location l = new Location();
var listLocations = DAO.Query.LocationQuery.GetLocations();
LocateRegister lr = new LocateRegister();
var listLocationRegisters = DAO.Query.LocationQuery.GetLocateRegister(lr);
Movie m = new Movie();
var listMovies = DAO.Query.MovieQuery.GetMovies(m);
var list = listLocations.Join(listLocationRegisters,
lo => lo.Id,
lor => lor.IdLocation,
(lo, lor) => new
{
lo.Id,
lo.CPF,
lo.LocationDate,
lor.IdMovie
}).Join(listMovies,
lo => lo.IdMovie,
mo => mo.Id,
(lo, mo) => new
{
lo.Id,
lo.CPF,
lo.LocationDate,
lo.IdMovie,
mo.Name
});
str.Add(new
{
list = list.Where(o => o.Id == Convert.ToInt32(Id)).Select(o => o.Name)
});
return(Json(str, JsonRequestBehavior.AllowGet));
}
static public List <LocateRegister> GetLocateRegister(LocateRegister u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
dbContextTransaction.Commit();
return(db.LocateRegisters.ToList());
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(null);
}
}
}
}
static public bool CreateRegister(LocateRegister u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.LocateRegisters.Add(u);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(false);
}
}
}
}
public JsonResult NewLocation(string CPF, string Table)
{
Location l = new Location();
l.CPF = CPF;
int idLo = DAO.Persistence.LocationPersistence.CreateLocation(l);
Table.Split('|').ToList().ForEach(o => {
if (o != "")
{
Movie mo = new Movie();
mo.Name = o;
int IdMovie = DAO.Query.MovieQuery.GetMovies(mo).First().Id;
LocateRegister lr = new LocateRegister();
lr.IdMovie = IdMovie;
lr.IdLocation = idLo;
DAO.Persistence.LocateRegisterPersistence.CreateRegister(lr);
}
});
return(Json("", JsonRequestBehavior.AllowGet));
}
