public bool AddCrashDescription(int rowID, string CrashDescription, string Summary)
{
// If CrashDescription and Summary == null then just return a successful update
if (String.IsNullOrEmpty(CrashDescription) && String.IsNullOrEmpty(Summary))
{
return(true);
}
string LogFileName = ConfigurationManager.AppSettings["LogFileName"];
StreamWriter LogFile = null;
try
{
LogFile = new StreamWriter(LogFileName, true);
}
catch (Exception)
{
// Ignore cases where the log file can't be opened (another instance may be writing to it already)
}
int rowsAffected = 0;
try
{
CrashReportDataContext mCrashDataContext = new CrashReportDataContext();
Crash CrashToUpdate = mCrashDataContext.Crashes.Where(c => c.Id == rowID).First();
CrashToUpdate.Description = CrashDescription;
mCrashDataContext.SubmitChanges();
}
catch (Exception e)
{
if (LogFile != null)
{
LogFile.WriteLine("Exception caught!");
LogFile.WriteLine(e.Message);
LogFile.Close();
}
return(false);
}
if (LogFile != null)
{
LogFile.WriteLine("Successfully updated Crash Description, " + rowsAffected.ToString() + " Rows updated");
LogFile.Close();
}
return(true);
}
public bool AddCrashFiles(int rowID, bool bHasLog, bool bHasMiniDump, bool bHasVideo)
{
string LogFileName = ConfigurationManager.AppSettings["LogFileName"];
StreamWriter LogFile = null;
try
{
LogFile = new StreamWriter(LogFileName, true);
}
catch (Exception)
{
// Ignore cases where the log file can't be opened (another instance may be writing to it already)
}
int rowsAffected = 0;
try
{
CrashReportDataContext mCrashDataContext = new CrashReportDataContext();
Crash CrashToUpdate = mCrashDataContext.Crashes.Where(c => c.Id == rowID).First();
CrashToUpdate.HasLogFile = bHasLog;
CrashToUpdate.HasMiniDumpFile = bHasMiniDump;
CrashToUpdate.HasVideoFile = bHasVideo;
mCrashDataContext.SubmitChanges();
}
catch (Exception e)
{
if (LogFile != null)
{
LogFile.WriteLine("Exception caught!");
LogFile.WriteLine(e.Message);
LogFile.Close();
}
return(false);
}
if (LogFile != null)
{
LogFile.WriteLine("Successfully updated Crash Description, " + rowsAffected.ToString() + " Rows updated");
LogFile.Close();
}
return(true);
}
public int CreateNewCrash(int AutoReporterId, string ComputerName, string UserName, string GameName, string PlatformName, string LanguageExt,
string TimeOfCrash, string BuildVer, string ChangelistVer, string CommandLine, string BaseDir,
string CallStack, string EngineMode)
{
string LogFileName = ConfigurationManager.AppSettings["LogFileName"];
int newID = -1;
StreamWriter LogFile = null;
try
{
LogFile = new StreamWriter(LogFileName, true);
}
catch (Exception)
{
// Ignore cases where the log file can't be opened (another instance may be writing to it already)
}
DateTime currentDate = DateTime.Now;
if (LogFile != null)
{
LogFile.WriteLine("");
LogFile.WriteLine("Creating new report..." + currentDate.ToString("G"));
}
try
{
//TODO Catch exception if we fail to connect to the database
var NewCrash = new Crash();
if (CallStack.Contains("Assertion failed:"))
{
NewCrash.CrashType = 2;
}
else if (CallStack.Contains("Ensure condition failed:"))
{
NewCrash.CrashType = 3;
}
else
{
NewCrash.CrashType = 1;
}
NewCrash.BaseDir = BaseDir;
NewCrash.BuildVersion = BuildVer;
NewCrash.ChangeListVersion = ChangelistVer;
NewCrash.CommandLine = CommandLine;
NewCrash.ComputerName = ComputerName;
NewCrash.EngineMode = EngineMode;
NewCrash.GameName = GameName;
NewCrash.LanguageExt = LanguageExt;
NewCrash.PlatformName = PlatformName;
NewCrash.RawCallStack = CallStack;
NewCrash.TimeOfCrash = ConvertDumpTimeToDateTime(TimeOfCrash);
NewCrash.Status = "New";
using (var DataContext = new CrashReportDataContext())
{
// Crashes after this upgrade refer to users by ID
NewCrash.UserNameId = DataContext.FindOrAddUser(UserName);
DataContext.Crashes.InsertOnSubmit(NewCrash);
DataContext.SubmitChanges();
DataContext.BuildPattern(NewCrash);
}
newID = NewCrash.Id;
}
catch (Exception e)
{
if (LogFile != null)
{
LogFile.WriteLine("Exception caught!");
LogFile.WriteLine(e.Message);
LogFile.Close();
}
return(newID);
}
//TODO Catch any execptions from failing to open the connection to the db.
/* catch (conn e)
* {
* if (LogFile != null)
* {
* LogFile.WriteLine("Failed to open connection to database!");
* LogFile.WriteLine("ConnectionString");
* LogFile.WriteLine(e.Message);
* LogFile.Close();
* }
* return -1;
* }*/
if (LogFile != null)
{
LogFile.WriteLine("Successfully created new record with id " + newID.ToString());
LogFile.Close();
}
return(newID);
}