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