public static void UpdateQuarterStatus(long id,QuarterStatus status) { DataClassesDataContext datacontext = new DataClassesDataContext(); var varquarter = from quarterCategory in datacontext.tblQuarters where quarterCategory.Id==id select quarterCategory; tblQuarter quarter = varquarter.FirstOrDefault(); quarter.Status = (int)status; datacontext.SubmitChanges(); }
public static void UpdateQuarterStatus(string quarterNumber, QuarterStatus status) { DataClassesDataContext datacontext = new DataClassesDataContext(); var varquarter = from quarterCategory in datacontext.tblQuarters where quarterCategory.QuarterNumber.ToLower()==quarterNumber.ToLower() select quarterCategory; tblQuarter quarter = varquarter.FirstOrDefault(); quarter.Status = (int)status; datacontext.SubmitChanges(); }