private List <MovieTitles> SqlGetMovieList(string dbQuery)
{
var temp = new List <MovieTitles>();
var dbCon = DatabaseUtils.Instance();
dbCon.DatabaseName = DatabaseUtils.Databasename;
try
{
if (dbCon.IsConnect())
{
var cmd = new MySqlCommand(dbQuery, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var mov = new MovieTitles();
mov.MovieId = reader.GetInt64("MOV_INFO_UNIQ_ID");
mov.Title = reader.GetString("MOV_INFO_TITLE");
mov.ReturnDate = reader.GetString("MOV_STATUS_DATE");
temp.Add(mov);
mov = null;
}
dbCon.Close();
}
return(temp);
}
catch
{
dbCon.Close();
return(null);
}
}
void LoadMovieTitles()
{
string filePath = Path.Combine(Application.streamingAssetsPath, "MovieTitles.json");
if (File.Exists(filePath))
{
string dataJson = File.ReadAllText(filePath);
movieTitles = JsonUtility.FromJson <MovieTitles>(dataJson);
}
}
public MovieTitlesModel Create(MovieTitles movieTitles)
{
return(new MovieTitlesModel()
{
Id = movieTitles.Id,
MovieTitle = movieTitles.MovieTitle,
MovieDesc = movieTitles.MovieDesc,
ReleaseDate = movieTitles.ReleaseDt,
ImdbUrl = movieTitles.ImdbUrl
});
}
public bool Add(MovieTitles title)
{
try
{
this.movieContext.MovieTitles.Add(title);
}
catch
{
return(false);
}
return(true);
}
public bool UpdateMovieTitle(MovieTitles movieTitles)
{
var dbset = this.movieContext.MovieTitles;
var context = this.movieContext.Entry(movieTitles);
if (context.State == EntityState.Detached)
{
dbset.Attach(movieTitles);
}
context.State = EntityState.Modified;
return(true);
}
public MovieTitles Parse(MovieTitlesModel model)
{
try
{
var title = new MovieTitles();
if (model.MovieTitle != null)
{
title.MovieTitle = model.MovieTitle;
if (model.MovieDesc != null)
{
title.MovieDesc = model.MovieDesc;
}
if (model.ImdbUrl != null)
{
title.ImdbUrl = model.ImdbUrl;
}
if (model.ReleaseDate != null)
{
title.ReleaseDt = model.ReleaseDate;
}
title.DateAdded = DateTime.Now;
title.DateModified = DateTime.Now;
return(title);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}
public MovieTitles ParsePatch(MovieTitlesModel model, int id)
{
try
{
MovieTitles title = this.movieRepository.GetTitleForMovie(id);
if (model.MovieTitle != null)
{
title.MovieTitle = model.MovieTitle;
if (model.MovieDesc != null)
{
title.MovieDesc = model.MovieDesc;
}
if (model.ImdbUrl != null)
{
title.ImdbUrl = model.ImdbUrl;
}
if (model.ReleaseDate != null)
{
title.ReleaseDt = model.ReleaseDate;
}
title.DateModified = DateTime.Now;
return(title);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}
