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