public bool AddBackupHistoryDetail(BackupHistoryDetail bckDetail)
{
bool success = false;
success = backuprestoreDAO.AddBackupHistoryDetail(bckDetail);
return(success);
}
public bool AddBackupHistoryDetail(BackupHistoryDetail bckDetail)
{
try
{
dbContext.BackupHistoryDetails.Add(bckDetail);
try
{
dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
log.Error(String.Format("Exception : {0}", ex.StackTrace));
return(false);
}
}
catch (Exception ex)
{
log.Error(String.Format("Exception : {0}", ex.StackTrace));
return(false);
}
}
private bool ExportTableToTextFile(string folderPath, int backupID)
{
try
{
foreach (ConfigBackupTable bck in lstBackupTable.OrderBy(o => o.TableSeq).ToList <ConfigBackupTable>())
{
int tableSeq = bck.TableSeq;
string tableName = bck.TableName;
string fileName = bck.TableName + @".csv";
string fullPath = folderPath + @"\" + fileName;
DataTable dtExportFile = backuprestoreData.GetSchemaTableByTableName(tableName);
if (FilesUtilBll.ExportTextFileFromDataTable(fullPath, dtExportFile, ",", true, true))
{
BackupHistoryDetail backupDetail = new BackupHistoryDetail();
backupDetail.BackupID = backupID;
backupDetail.BackupSeq = tableSeq;
backupDetail.BackupTable = tableName;
backupDetail.FileName = fileName;
backupDetail.CreateDate = DateTime.Now;
backupDetail.CreateBy = UserName;
//Insert History Detail
if (!backuprestoreData.AddBackupHistoryDetail(backupDetail))
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
log.Error(String.Format("Exception : {0}", ex.StackTrace));
return(false);
}
}
