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); } }