public void OpenDBTest()
{
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
logManager.PrintLogMessage("ADCManager", "OpenDBTest", "open db test ok", System.Diagnostics.EventLogEntryType.Information);
}
catch (Exception err)
{
logManager.PrintLogMessage("ADCManager", "OpenDBTest", "open db test failed: " + err.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
}
public int CreateNewProcess(PushMsgModel pushMsgModel)
{
int newProcessId = DefineManager.NOT_AVAILABLE;
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
ADC_PushData adcPushData = new ADC_PushData();
adcPushData.ADC_OrderType = pushMsgModel.orderType;
adcPushData.ADC_DownloadUrl = pushMsgModel.downloadUrl;
adcPushData.ADC_UpdateTargetPath = pushMsgModel.updateTargetPath;
adcPushData.ADC_PushMsg = pushMsgModel.msg;
adcPushData.ADC_Version = pushMsgModel.version;
adcPushData.ADC_CallbackUrl = pushMsgModel.callbackUrl;
adcPushData.ADC_FileType = pushMsgModel.fileType;
context.ADC_PushData.Add(adcPushData);
context.SaveChanges();
newProcessId = adcPushData.ADC_Index;
ADC_Status adcStatus = new ADC_Status();
adcStatus.ADC_Index = newProcessId;
adcStatus.ADC_ProcessStatus = DefineManager.STATUS_CODE_DEFAULT;
adcStatus.ADC_UpdateDateTime = DateTime.Now;
context.ADC_Status.Add(adcStatus);
context.SaveChanges();
tran.Commit();
LogManager.PrintLogMessage("ADCManager", "CreateNewProcess", "process created, id: " + newProcessId, DefineManager.LOG_LEVEL_DEBUG);
}
catch (Exception err)
{
tran.Rollback();
LogManager.PrintLogMessage("ADCManager", "CreateNewProcess", "cannot create new process: " + err.Message, DefineManager.LOG_LEVEL_ERROR);
}
}
return(newProcessId);
}
public List <ADC_PushData> GetReadyForDeployFileList()
{
List <ADC_PushData> readyForDeployFileList = null;
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
readyForDeployFileList = context.ADC_PushData.Where(selectedPushMsgDataItem => selectedPushMsgDataItem.ADC_OrderType == DefineManager.ORDER_TYPE_NORMAL_DEPLOY &&
selectedPushMsgDataItem.ADC_Status.ADC_ProcessStatus == DefineManager.STATUS_CODE_DEPLOY_FILE_IS_READY).ToList();
logManager.PrintLogMessage("ADCManager", "GetReadyForDeployFileList", "ready for deploy file list size: " + readyForDeployFileList.Count, System.Diagnostics.EventLogEntryType.Information);
}
catch (Exception err)
{
logManager.PrintLogMessage("ADCManager", "GetReadyForDeployFileList", "cannot get ready for deploy flie list: " + err.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
return(readyForDeployFileList);
}
public List <ADCStatusReportModel> GetLatestADCStatusList(int limit = DefineManager.DEFAULT_ADC_STATUS_REPORT_RETURN_LIMIT)
{
List <ADCStatusReportModel> adcStatusReportList = null;
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
List <ADC_PushData> adcPushDataList = context.ADC_PushData.Where(selectedPushDataItem => selectedPushDataItem.ADC_OrderType != DefineManager.EXECUTE_ORDER_GET_STATUS).ToList();
List <ADC_Status> adcStatusList = context.ADC_Status.ToList();
adcStatusReportList = adcPushDataList.Select(pushDataItem => new ADCStatusReportModel
{
adcIndex = pushDataItem.ADC_Index,
adcOrderType = pushDataItem.ADC_OrderType,
adcDownloadUrl = pushDataItem.ADC_DownloadUrl,
adcDownloadedPath = pushDataItem.ADC_DownloadedPath,
adcExtractedPath = pushDataItem.ADC_ExtractedPath,
adcUpdateTargetPath = pushDataItem.ADC_UpdateTargetPath,
adcPushMsg = pushDataItem.ADC_PushMsg,
adcVersion = pushDataItem.ADC_Version,
adcCallbackUrl = pushDataItem.ADC_CallbackUrl,
adcFileType = pushDataItem.ADC_FileType,
adcProcessStatus = ADCExtension.IsStatusNotNull(adcStatusList, pushDataItem.ADC_Index) ? ADCExtension.GetStatusItem(adcStatusList, pushDataItem.ADC_Index).ADC_ProcessStatus : DefineManager.NOT_AVAILABLE,
adcProcessMsg = ADCExtension.IsStatusNotNull(adcStatusList, pushDataItem.ADC_Index) ? ADCExtension.GetStatusItem(adcStatusList, pushDataItem.ADC_Index).ADC_ProcessMsg : null,
adcUpdateDateTime = ADCExtension.IsStatusNotNull(adcStatusList, pushDataItem.ADC_Index) ? ADCExtension.GetStatusItem(adcStatusList, pushDataItem.ADC_Index).ADC_UpdateDateTime.ToString() : DateTime.Now.ToString()
}).OrderByDescending(orderPushDataItem => orderPushDataItem.adcIndex).Take(limit).ToList();
LogManager.PrintLogMessage("ADCManager", "GetLatestADCStatusList", "status report size: " + adcStatusReportList.Count, DefineManager.LOG_LEVEL_INFO);
}
catch (Exception err)
{
tran.Rollback();
LogManager.PrintLogMessage("ADCManager", "GetLatestADCStatusList", "cannot get process status: " + err.Message, DefineManager.LOG_LEVEL_ERROR);
}
}
return(adcStatusReportList);
}
public void UpdateCurrentProcessInfo(ADC_PushData adcPushData)
{
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
ADC_PushData selectedADCPushData = context.ADC_PushData.Where(selectedADCPushDataItem => selectedADCPushDataItem.ADC_Index == adcPushData.ADC_Index).FirstOrDefault();
selectedADCPushData.ADC_DownloadedPath = adcPushData.ADC_DownloadedPath;
selectedADCPushData.ADC_ExtractedPath = adcPushData.ADC_ExtractedPath;
context.SaveChanges();
tran.Commit();
LogManager.PrintLogMessage("ADCManager", "UpdateCurrentProcessInfo", "process info updated, downloaded path: " + selectedADCPushData.ADC_DownloadedPath + " extracted path: " + selectedADCPushData.ADC_ExtractedPath, DefineManager.LOG_LEVEL_DEBUG);
}
catch (Exception err)
{
tran.Rollback();
LogManager.PrintLogMessage("ADCManager", "UpdateCurrentProcessInfo", "cannot update process status: " + err.Message, DefineManager.LOG_LEVEL_ERROR);
}
}
}
public void UpdateCurrentProcessStatus(ADC_Status adcStatus)
{
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
ADC_Status selectedADCStatus = context.ADC_Status.Where(selectedADCStatusItem => selectedADCStatusItem.ADC_Index == adcStatus.ADC_Index).FirstOrDefault();
selectedADCStatus.ADC_ProcessMsg = adcStatus.ADC_ProcessMsg;
selectedADCStatus.ADC_ProcessStatus = adcStatus.ADC_ProcessStatus;
selectedADCStatus.ADC_UpdateDateTime = DateTime.Now;
context.SaveChanges();
tran.Commit();
LogManager.PrintLogMessage("ADCManager", "UpdateCurrentProcessStatus", "process status updated, status: " + adcStatus.ADC_StatusCode, DefineManager.LOG_LEVEL_DEBUG);
}
catch (Exception err)
{
tran.Rollback();
LogManager.PrintLogMessage("ADCManager", "UpdateCurrentProcessStatus", "cannot update process status: " + err.Message, DefineManager.LOG_LEVEL_ERROR);
}
}
}
public ADC_Status FindCurrentStatus(ADC_PushData adcPushData)
{
ADC_Status selectedADCStatus = null;
using (AutoDeployClientEntities context = new AutoDeployClientEntities())
using (var tran = context.Database.BeginTransaction())
{
try
{
selectedADCStatus = context.ADC_Status.Where(selectedADCStatusItem => selectedADCStatusItem.ADC_Index == adcPushData.ADC_Index).FirstOrDefault();
context.SaveChanges();
tran.Commit();
logManager.PrintLogMessage("ADCManager", "FindCurrentStatus", "process status updated, status: " + selectedADCStatus.ADC_StatusCode, System.Diagnostics.EventLogEntryType.Information);
}
catch (Exception err)
{
tran.Rollback();
logManager.PrintLogMessage("ADCManager", "FindCurrentStatus", "cannot update process status: " + err.Message, System.Diagnostics.EventLogEntryType.Error);
}
}
return(selectedADCStatus);
}
