static void SendMail(DAL.ServiceCrmEvolutionDetailItem item, Exception ex)
{
try
{
string message = null;
message = "EVOLVE CENTRAL EXCEPTION REPORT";
message += Environment.NewLine;
message += Environment.NewLine;
message += "CLIENT: " + item.ServiceCrmEvolutionItem.CompanyItem.Name;
message += Environment.NewLine;
message += "SERVICE TYPE: " + item.ServiceCrmEvolutionItem.ServiceTemplateCrmEvolutionItem.ServiceTypeItem.Name;
message += Environment.NewLine;
message += "SERVICE: " + item.ServiceCrmEvolutionItem.Name + " ( " + item.ServiceCrmEvolutionItem.Code + " ) ";
message += Environment.NewLine;
message += "SERVICE COMMAND: " + item.Name + " (ID: " + item.Id.ToString() + " ) ";
message += Environment.NewLine;
message += Environment.NewLine;
message += "EXCEPTION:";
message += Environment.NewLine;
message += Environment.NewLine;
message += ex.Message;
SendMail(message);
}
catch
{
}
}
static void LogSqlCommandException(DAL.ServiceCrmEvolutionDetailItem item, Exception ex, string message)
{
Console.WriteLine(ex.Message);
LogSqlCommandExceptionToDatabase(item, ex, message);
SendMail(item, ex);
}
static void LogSqlCommandToDatabase(DAL.ServiceCrmEvolutionDetailItem i, string message)
{
DAL.SyncLogCrmEvolutionDetailItem item = new DAL.SyncLogCrmEvolutionDetailItem();
item.SyncLogCrmEvolutionId = CurrentLogId;
item.Name = message;
item.IsSuccessful = true;
item.ExecutedCommand = i.Name;
item.CreateDate = DateTime.Now;
item.ErrorMessage = null;
DAL.SyncLogCrmEvolutionDetail.Save(ctx, item);
}
static void LogSqlCommandExceptionToDatabase(DAL.ServiceCrmEvolutionDetailItem i, Exception ex, string message)
{
DAL.SyncLogCrmEvolutionDetailItem item = new DAL.SyncLogCrmEvolutionDetailItem();
item.SyncLogCrmEvolutionId = CurrentLogId;
item.Name = message;
item.IsSuccessful = false;
item.ExecutedCommand = i.Command;
item.CreateDate = DateTime.Now;
item.ErrorMessage = ex.Message;
DAL.SyncLogCrmEvolutionDetail.Save(ctx, item);
DAL.SyncLogCrmEvolutionItem litem = DAL.SyncLogCrmEvolution.GetById(ctx, Convert.ToInt32(item.SyncLogCrmEvolutionId));
litem.IsSuccessful = false;
DAL.SyncLogCrmEvolution.Save(ctx, litem);
}
static void LogSqlCommand(DAL.ServiceCrmEvolutionDetailItem item, string message)
{
Console.WriteLine(message);
LogSqlCommandToDatabase(item, message);
}