public static void WriteToError(string _link, string _detail, int _year)
{
TheNumbersDataContext dc = new TheNumbersDataContext();
dc.Errors.InsertOnSubmit(new Error {
detail = _detail, link = _link.Replace(@"http://www.the-numbers.com/", String.Empty), year = _year
});
dc.SubmitChanges();
}
/// <summary>
/// Write into log.
/// </summary>
/// <param name="status">Status of the program</param>
/// <param name="desc">Default is ""</param>
public static void WriteToLog(ProgramStatus status, string desc = "")
{
string log = "";
switch (status)
{
case ProgramStatus.Error:
log = "ERROR - " + DateTime.Now;
break;
case ProgramStatus.End:
log = "END - " + DateTime.Now;
break;
case ProgramStatus.Start:
log = "START - " + DateTime.Now;
break;
case ProgramStatus.Success:
log = "SUCCESS - " + DateTime.Now;
break;
default:
break;
}
try
{
TheNumbersDataContext dc = new TheNumbersDataContext();
dc.Logs.InsertOnSubmit(new DataModel.Log {
LogTime = DateTime.Now, Desc = log
});
dc.SubmitChanges();
}
catch
{
throw;
}
return;
}
private void Redownload_Click(object sender, EventArgs e)
{
TheNumbersDataContext dc = new TheNumbersDataContext();
var errors = dc.Errors.DistinctBy(x => x.link);
foreach (var error in errors)
{
dc.ExecuteCommand("TRUNCATE TABLE [dbo].[log]"); // clears the log first.
SingleMovieLink tempsml = new SingleMovieLink(error.link, error.year);
dc.Connection.Close();
tempsml.GetMovie();
if (dc.Connection.State.Equals(ConnectionState.Closed))
{
dc.Connection.Open();
}
if (!dc.IsThereAnyError())
{
var tempdelete = dc.Errors.Where(err => err.link.Equals(error.link));
dc.Errors.DeleteAllOnSubmit(tempdelete);
dc.SubmitChanges();
}
}
}