public static bool UpdateProviderOperationNum(string name) { try { InitConnection(); providersTableAdapter adapter = new providersTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; adapter.sp_GetProviderOperationNum(name); return true; } catch (Exception exObj) { lastErrorString = exObj.Message; string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[UpdateProviderOperationNum - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n"); } return false; }
public static APIServiceProviderNamespace.main.providersDataTable GetProviders() { try { InitConnection(); providersTableAdapter adapter = new providersTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; return adapter.GetData(); } catch (Exception exObj) { lastErrorString = exObj.Message; string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[GetProviders - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n"); } return null; }