public static void AddNewYear(int year)
{
DataContext db = new DataContext();
TblYear tbl = new TblYear();
tbl.Year = year;
db.TblYears.InsertOnSubmit(tbl);
db.SubmitChanges();
db.Dispose();
}
public static bool ValidateYear(int yearToValidated)
{
DataContext db = new DataContext();
TblYear tbl = new TblYear();
var result = from e in db.TblYears where e.Year == yearToValidated select e;
tbl = result.SingleOrDefault();
if (tbl == null)
{
return(true);
}
else
{
return(false);
}
}
