private void cmdQuery_Click(object sender, EventArgs e)
{
SQLServerAccess sqa = new SQLServerAccess();
dgvMovieResults.DataSource = null;
dgvMovieResults.Rows.Clear();
dgvMovieResults.Columns.Clear();
List<WatchedMovieModel> movielist = new List<WatchedMovieModel>();
movielist = sqa.getAllWatchedMovies();
if (movielist != null)
{
dgvMovieResults.Columns.Add("clmMovieID", "Movie ID");
dgvMovieResults.Columns.Add("clmMovieTitle", "Movie Title");
dgvMovieResults.Columns.Add("clmReleaseDate", "Release Date");
dgvMovieResults.Columns.Add("clmRating", "Rating");
foreach (WatchedMovieModel m in movielist){
string[] row = new string[] { m.movieID.ToString(), m.movieTitle, DateTime.Parse(m.movieReleaseDate.ToString()).ToString("yyyy-MM-dd"), m.personal_rating.ToString() };
dgvMovieResults.Rows.Add(row);
}
dgvMovieResults.Refresh();
} else
{
dgvMovieResults.Columns.Add("clmError", "Error Message");
dgvMovieResults.Rows.Add();
dgvMovieResults.Rows[0].Cells[0].Value = "Error";
Console.WriteLine("Returned null");
}
}
private async void frmMovieDetails_Load(object sender, EventArgs e)
{
lblLoading.Visible = true;
sqa = new SQLServerAccess();
if (sqa.checkIfWatched(movieID))
{
movie = new WatchedMovie();
movie = sqa.getWatchedMovie(movieID);
getMovieDetails(movieID);
cmdWatched.Enabled = false;
cmdWatched.Text = "Watched";
chklbStarRating.SetItemChecked(movie.personal_rating - 1, true);
} else
{
API_INIT = new APIAccess();
movie = new TmdbMovie();
movie = await API_INIT.fullMovieDetails(movieID);
await getMovieDetails();
}
MoviePosterURL = movie.poster_path;
lblTitle.Text = movie.Title;
lblTagLine.Text = movie.tagline;
lblStatusActual.Text = movie.status;
lblDirectorActual.Text = director.director_name;
if (movie.status == "Released")
{
lblStatusActual.ForeColor = Color.Green;
} else
{
lblStatusActual.ForeColor = Color.Red;
}
lblReleaseDateActual.Text = movie.release_date.ToString();
lblRevenueActual.Text = "$" + string.Format("{0:N}", movie.Revenue);
lblBudgetActual.Text = "$" + string.Format("{0:N}", movie.Budget);
lblRuntimeActual.Text = movie.Runtime.ToString() + " mins";
picMoviePoster.ImageLocation = MovieURLPrefix + "w500" + MoviePosterURL;
lblLoading.Visible = false;
}
public static IDataSource GetDataSource()
{
IDataSource dataAccess;
switch (AppSettings.System.DataSource)
{
case DataSourceEnum.SQLServer:
dataAccess = new SQLServerAccess();
break;
default:
throw new ArgumentOutOfRangeException();
}
return(dataAccess);
}
private void getMovieDetails(int movieID)
{
cast = new List<MovieCast>();
sqa = new SQLServerAccess();
cast = sqa.getMovieCast(this.movieID);
foreach (MovieCast m in cast)
{
string[] row = new string[] { m.name, m.character };
dgvMovieCredits.Rows.Add(row);
}
director = sqa.getMovieDirector(this.movieID);
}
private void cmdWatched_Click(object sender, EventArgs e)
{
int rating = 0;
if (chklbStarRating.CheckedItems.Count != 0)
{
foreach(char s in chklbStarRating.CheckedItems[0].ToString()) {
rating++;
}
} else
{
MessageBox.Show("Please give a movie rating", "Error!");
return;
}
lblLoading.Visible = true;
lblLoading.Text = "SAVING";
sqa = new SQLServerAccess();
sqa.watchMovie(movie, cast, movie.Genres, director, rating);
cmdWatched.Enabled = false;
lblLoading.Visible = false;
lblLoading.Text = "LOADING";
}
public void Run()
{
var dt = DateTime.Now;
//var s = from t in new List<object>()
// where t.ToString() == ""
// select t;
var ssa = new SQLServerAccess();
var lastweek_start = ComFunc.GetMondayDate(DateTime.Now).AddDays(-7);
var lastweek_end = ComFunc.GetSundayDate(DateTime.Now).AddDays(-7);
var dd = from t in ssa.NewLinqTable("IC_Statistic_Water", "a")
where t.SW_Estate == "1" &&
t.todatetime(t.SW_Year.tostring(4).concat("-", (t.SW_Month + 100).tostring(3).substring(2, 2), "-", (t.SW_Day + 100).tostring(3).substring(2, 2))) >= t.todatetime($"{lastweek_start.Year}-{lastweek_start.Month}-{lastweek_start.Day}") &&
t.todatetime(t.SW_Year.tostring(4).concat("-", (t.SW_Month + 100).tostring(3).substring(2, 2), "-", (t.SW_Day + 100).tostring(3).substring(2, 2))) <= t.todatetime($"{lastweek_end.Year}-{lastweek_end.Month}-{lastweek_end.Day}")
select new
{
hour = t.SW_Hour,
count = t.SW_Total
};
//var filter = "a";
//var start_time = "";
//var end_time = "";
//var s = from t in LinqDLRTable.New<LinqDLRColumn>("a", "", new SqlOperatorFlags())
// where t.notnull(filter, (t.Request_Route.contains(filter) || t.Request_IP.contains(filter) || t.Request_SubSystem_Name.contains(filter)))
// && t.notnull(start_time, t.add_time >= start_time) && t.notnull(end_time, t.add_time <= end_time) && t.start_time.isnull("").within(",1,2,3")
// orderby t.add_time descending
// select t;
Console.WriteLine(dd.ToSql());
var s = from t in LinqDLRTable.New <LinqDLRColumn>("a", "a", new SqlOperatorFlags())
join t2 in LinqDLRTable.New <LinqDLRColumn>("b", "b", new SqlOperatorFlags()) on t.id equals t2.code
join t3 in LinqDLRTable.New <LinqDLRColumn>("b", "c", new SqlOperatorFlags()) on t.id2 equals t3.code
group t by new { t.a, t.b } into g
select g;
var sql = s.ToSql();
Console.WriteLine(sql);
sql = (from t in LinqDLRTable.New <LinqDLRColumn>("a", "", new SqlOperatorFlags())
orderby t.time descending
select t).ToSql();
Console.WriteLine(sql);
sql = (from t in LinqDLRTable.New <LinqDLRColumn>("a", "", new SqlOperatorFlags())
orderby t.time descending, t.id
select new { t.id, t.name }).ToSql();
Console.WriteLine(sql);
sql = (from t in LinqDLRTable.New <LinqDLRColumn>("a", "", new SqlOperatorFlags())
group t by new { t.a, t.b } into g
select g).ToSql();
Console.WriteLine(sql);
sql = (from t in LinqDLRTable.New <LinqDLRColumn>("a", "", new SqlOperatorFlags())
from t2 in LinqDLRTable.New <LinqDLRColumn>("b", "", new SqlOperatorFlags())
where t.id == t2.id && t.time == "2018/08/17"
select new
{
t.id,
t2.name
}).ToSql();
Console.WriteLine(sql);
sql = (from t in LinqDLRTable.New <LinqDLRColumn>("a", "", new SqlServerOperatorFlags())
from t2 in LinqDLRTable.New <LinqDLRColumn>("b", "", new SqlServerOperatorFlags())
from t3 in LinqDLRTable.New <LinqDLRColumn>("c", "", new SqlServerOperatorFlags())
where t.id == t2.id
group new { t, t2, t3 } by new
{
t.id,
t2.time
} into g
select new
{
g.t.id,
g.t2.name
}).ToSql();
Console.WriteLine(sql);
Console.WriteLine($"selectmany cast:{(DateTime.Now - dt).TotalMilliseconds}"); dt = DateTime.Now;
}
