private void btnCreateBackUp_Click(object sender, EventArgs e)
{
int backupID = 0;
if (ValidateBackUpName())
{
BackupHistoryModel backupData = new BackupHistoryModel();
backupData = GetInsertBackupHistory();
backupID = backuprestoreData.AddBackupHistory(backupData);
if (backupID > 0)
{
string folderPath = "";
folderPath = this.GetBackupFolderPath(backupID.ToString());
//
if (folderPath == "")
{
MessageBox.Show(MessageConstants.Cannotcreatebackupfilepathisinvalid, MessageConstants.TitleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
//Dele
}
else
{
if (Directory.Exists(folderPath))
{
FilesUtilBll.DeleteDirectory(folderPath);
}
if (!ExportTableToTextFile(folderPath, backupID))
{
FilesUtilBll.DeleteDirectory(folderPath);
backuprestoreData.UpdateDeletedFlagBackupHistory(backupID, UserName);
MessageBox.Show(MessageConstants.Cannotcreatebackupfileerrorexportcsvfile, MessageConstants.TitleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(MessageConstants.Createbackupfilesuccessfull, MessageConstants.TitleInfomation, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
txtBackupName.Text = "";
RefreshData();
FocusOnLastRow();
}
else
{
MessageBox.Show(MessageConstants.BackupNamemustnotbeNullorBlank, MessageConstants.TitleWarning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private bool RestoreDataByTableName(int backupID, string folderPath)
{
List <ConfigBackupTable> bckTable = lstBackupTable.OrderBy(o => o.TableSeq).ToList <ConfigBackupTable>();
List <BackupHistoryDetail> bckDetail = backuprestoreData.LoadBackupHistoryDetailByBackupID(backupID);
try
{
foreach (ConfigBackupTable bck in bckTable)
{
int seqTable = bck.TableSeq;
List <BackupHistoryDetail> bDetail = (from b in bckDetail
where b.BackupSeq == bck.TableSeq
select b).ToList <BackupHistoryDetail>();
string fullPath = folderPath + @bDetail[0].FileName;
DataTable dtFormat = new DataTable();
DataTable dtImport = new DataTable();
dtFormat = backuprestoreData.GetSchemaTableByTableName(bDetail[0].BackupTable);
if (dtFormat != null)
{
dtImport = FilesUtilBll.GetDataTableFromTextFile(dtFormat, fullPath, ",", true, true);
}
else
{
dtImport = FilesUtilBll.GetDataTableFromTextFile(fullPath, ",", true, true);
}
if (dtImport != null)
{
if (!backuprestoreData.RestoreDataByTableName(bDetail[0].BackupTable, dtImport))
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
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);
}
}
private void btnDeleteBackUp_Click(object sender, EventArgs e)
{
List <int> selectedRow = GetListSelected();
List <string> error = new List <string>();
string errorMsg = "";
int selected = selectedRow.Count;
if (selected > 0)
{
try
{
DialogResult dialogresult = MessageBox.Show(MessageConstants.Doyouwanttodeletebackupdata, MessageConstants.TitleClearDataConfirmation, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogresult == DialogResult.Yes)
{
//delete backup
foreach (int idx in selectedRow)
{
int backupID = 0;
backupID = int.Parse(dgvBackUpHistory.Rows[idx].Cells[1].Value.ToString());
if (backupID > 0)
{
//delete Directory
string folderPath = "";
folderPath = this.GetBackupFolderPath(backupID.ToString());
if (folderPath == "")
{
errorMsg += MessageConstants.CannotdeletebackupfilewithbackupID + backupID + "." + Environment.NewLine;
}
else
{
if (FilesUtilBll.DeleteDirectory(folderPath))
{
//update flag
backuprestoreData.UpdateDeletedFlagBackupHistory(backupID, UserName);
}
else
{
errorMsg += MessageConstants.CannotdeletebackupfilewithbackupID + backupID + "." + Environment.NewLine;
}
}
}
}
if (errorMsg != "")
{
MessageBox.Show(errorMsg, MessageConstants.TitleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(MessageConstants.Deletebackupdatasuccessfull, MessageConstants.TitleInfomation, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
RefreshData();
}
}
catch (Exception ex)
{
log.Error(String.Format("Exception : {0}", ex.StackTrace));
MessageBox.Show(MessageConstants.Cannotdeletebackupdata, MessageConstants.TitleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(MessageConstants.CannotdeletebackupdataPleaseselectrecordfordelete, MessageConstants.TitleWarning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}