public static void InsertOperationLog(string operation, string query, string program)
{
var username = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
var pcname = System.Environment.MachineName;
using (var context = new System.Data.Linq.DataContext(Central.SpecialConnStr))
{
context.ExecuteCommand("insert into log (id,username,computername,logdate,operation,queryon,program)" +
" values ({0},{1},{2},{3},{4},{5},{6})", Guid.NewGuid(), username, pcname, DateTime.Now.Subtract(MinimalDate).Ticks, operation, query, program);
}
}
public override bool Ping(DataContext dataContext)
{
var result = dataContext.ExecuteCommand("SELECT 11 FROM DUAL");
if (result is decimal)
{
return((int)(decimal)result == 11);
}
else
{
return((int)result == 11);
}
}
public void DeleteAll()
{
using (PersonsDBEntities pb = conn.GetContext())
{
System.Configuration.ConnectionStringSettingsCollection connectionStrings =
WebConfigurationManager.ConnectionStrings as ConnectionStringSettingsCollection;
if (connectionStrings.Count > 0)
{
System.Data.Linq.DataContext db = new System.Data.Linq.DataContext(connectionStrings["ConnectionString"].ConnectionString);
db.ExecuteCommand("TRUNCATE TABLE TelContact");
}
}
}
public override bool Ping(DataContext dataContext)
{
return dataContext.ExecuteCommand("SELECT 11 FROM DUAL") == 11;
}
public override bool Ping(DataContext dataContext)
{
return(dataContext.ExecuteCommand("SELECT 11 FROM DUAL") == 11);
}
public int ExecuteCommand(string command, params object[] parameters)
{
return(_linqContext.ExecuteCommand(command, parameters));
}
