public static DateTime GetServerDateTime() { using (DBCheckup.InhCheckupDataContext dbc = new DBCheckup.InhCheckupDataContext()) { DateTime nowdatetime = Convert.ToDateTime(dbc.ExecuteQuery <DateTime>("select GetDate()").FirstOrDefault()); return(nowdatetime); } }
public static Boolean CheckIsConnection() { try { using (DBCheckup.InhCheckupDataContext dbc = new DBCheckup.InhCheckupDataContext()) { DateTime nowdatetime = Convert.ToDateTime(dbc.ExecuteQuery <DateTime>("select GetDate()").FirstOrDefault()); return(true); } } catch { Program.MessageError("Check Connection", "001", "Can not Connect DataBase SQL"); return(false); } }