public static void AddNotWorkingDay(DateTime dt) { try { InitConnection(); notworkingdaysTableAdapter adapter = new notworkingdaysTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; adapter.Insert(dt); } catch (Exception exObj) { lastErrorString = exObj.Message; } }
public static bool IsNotWorkingDay(DateTime dt) { try { InitConnection(); notworkingdaysTableAdapter adapter = new notworkingdaysTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; int res = Convert.ToInt32(adapter.sp_IsNotWorkngDay(dt)); if (res == 1) return true; else return false; } catch (Exception exObj) { lastErrorString = exObj.Message; return false; } }
public static void DeleteNotWorkingDays(int year) { try { InitConnection(); notworkingdaysTableAdapter adapter = new notworkingdaysTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; adapter.sp_DeleteNotWorkingDays(year); } catch (Exception exObj) { lastErrorString = exObj.Message; } }