public static SyncLogCrmEvolutionItem GetById(entitiesEvolveCentralConsole ctx, int id)
{
var item = new SyncLogCrmEvolutionItem();
item = (from i in ctx.SyncLogCrmEvolutionItems where i.Id == id orderby i.CreateDate descending select i).FirstOrDefault();
return(item);
}
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;
}
public static bool Save(entitiesEvolveCentralConsole ctx, SyncLogCrmEvolutionItem item)
{
try
{
if (item.Id == 0)
{
ctx.SyncLogCrmEvolutionItems.Add(item);
}
ctx.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
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.GetById(ctx, Convert.ToInt32(item.SyncLogCrmEvolutionId));
litem.IsSuccessful = false;
DAL.SyncLogCrmEvolution.Save(ctx, litem);
}
