public bool VideoVisto(Model.Videos Video)
{
bool estado = false;
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
Video.ESTADO = "Visto";
db.Entry(Video).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
estado = true;
}
catch (Exception Ex)
{
string Error = Ex.Message;
estado = false;
}
return(estado);
}
private void GuardarChannel(YouTubeAPI obj, int total)
{
List <Model.Videos> Videos = new List <Model.Videos>();
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
for (int i = 0; i < total; i++)
{
Model.Videos Video = new Model.Videos();
Video.Id_Video = obj.items[i].id.videoId;
Video.Nombre = obj.items[i].snippet.title;
Video.Url = "https://www.youtube.com/embed/" + obj.items[i].id.videoId;
Video.ESTADO = "Listo";
Videos.Add(Video);
}
if (total > 0)
{
db.Videos.AddRange(Videos);
// db.Entry(Videos).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
}
//return total;
}
}
//cath para saber sobre error en Entity Framework
//catch (DbEntityValidationException ex)
//{
// StringBuilder sb = new StringBuilder();
// foreach (var failure in ex.EntityValidationErrors)
// {
// sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
// foreach (var error in failure.ValidationErrors)
// {
// sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
// sb.AppendLine();
// }
// }
// //return total;
// throw new DbEntityValidationException(
// "Entity Validation Failed - errors follow:\n" +
// sb.ToString(), ex
// ); // Add the original exception as the innerException
//}
catch (Exception ex)
{
string Error = ex.Message;
// return total;
}
}
public Model.Videos FirstVideo()
{
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
FVideo = db.Videos.First(x => x.ESTADO == "Listo");
}
return(FVideo);
}
catch (Exception ex)
{
string error = ex.Message;
throw;
}
}
public List <Model.Videos> ListaVideos()
{
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
Lista = db.Videos.Where(x => x.ESTADO == "Listo").ToList();
}
return(Lista);
}
catch (Exception ex)
{
string error = ex.Message;
throw;
}
}
//Metodo para grebar en bd el tiempo de ocio y de Anti Procrastine
public void SetTime(int OcioTime, int APTime)
{
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
Model.AntiP AP = db.AntiP.First();
AP.OcioTime = OcioTime;
AP.APTime = APTime;
db.Entry(AP).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var e = new AjusteEventArgs();
e.OcioTime = OcioTime;
e.APTime = APTime;
ChangePreset(this, e);
}
}
//cath para saber sobre error en Entity Framework
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var failure in ex.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new DbEntityValidationException(
"Entity Validation Failed - errors follow:\n" +
sb.ToString(), ex
); // Add the original exception as the innerException
}
catch (Exception ex)
{
string Error = ex.Message;
}
}
public void State()
{
string State = "";
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
//Reviso el Estado de ANTI PROCRASTINE
// y Lo agrego el StateEventArgs
Model.AntiP AP = db.AntiP.First();
State = AP.State.ToString();
var e = new StateEventArgs();
e.State = State;
EventState(this, e);
}
}
//cath para saber sobre error en Entity Framework
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var failure in ex.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new DbEntityValidationException(
"Entity Validation Failed - errors follow:\n" +
sb.ToString(), ex
); // Add the original exception as the innerException
}
catch (Exception ex)
{
State = ex.Message;
}
//return State;
}
public int PorVer()
{
int PorVer;
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
PorVer = db.Videos.Where(x => x.ESTADO == "Listo").Count();
}
}
catch (Exception)
{
PorVer = 0;
throw;
}
return(PorVer);
}
public int Vistos()
{
int Vistos;
try
{
using (Model.AntiProcrastineEntities db = new Model.AntiProcrastineEntities())
{
Vistos = db.Videos.Where(x => x.ESTADO == "Visto").Count();
}
}
catch (Exception)
{
Vistos = 0;
throw;
}
return(Vistos);
}
