static void CreateLogInTheDatabase() { DAL.SyncLogCrmEvolutionItem item = new DAL.SyncLogCrmEvolutionItem(); item.CreateDate = syncstartdate; item.IsSuccessful = true; item.ServiceCrmEvolutionId = Convert.ToInt32(CurrentServiceId); DAL.SyncLogCrmEvolution.Save(ctx, item); CurrentLogId = item.Id; }
static void LogExceptionToDatabase(Exception ex, string message) { DAL.SyncLogCrmEvolutionDetailItem item = new DAL.SyncLogCrmEvolutionDetailItem(); item.SyncLogCrmEvolutionId = CurrentLogId; item.Name = message; item.IsSuccessful = false; item.ExecutedCommand = null; item.CreateDate = DateTime.Now; item.ErrorMessage = ex.Message; DAL.SyncLogCrmEvolutionDetail.Save(ctx, item); DAL.SyncLogCrmEvolutionItem litem = DAL.SyncLogCrmEvolution.Get(ctx, Convert.ToInt32(item.SyncLogCrmEvolutionId)); litem.IsSuccessful = false; DAL.SyncLogCrmEvolution.Save(ctx, litem); }
public static bool DeleteByService(entitiesEvolveCentral ctx, int id) { try { List <DAL.SyncLogCrmEvolutionItem> logitems = DAL.SyncLogCrmEvolution.GetByService(ctx, id); for (int i = 0; i < logitems.Count; i++) { int logid = logitems[i].Id; DAL.SyncLogCrmEvolutionDetail.DeleteByLog(ctx, logid); DAL.SyncLogCrmEvolutionItem litem = ctx.SyncLogCrmEvolutionItems.Find(logid); ctx.SyncLogCrmEvolutionItems.Remove(litem); } ctx.SaveChanges(); } catch (Exception ex) { return(false); } return(true); }