private BackupProgress StartBackup(Models.Backup backup)
{
if (CoreBaseSettings.Standalone)
{
TenantExtra.DemandControlPanelPermission();
}
var storageType = backup.StorageType == null ? BackupStorageType.Documents : (BackupStorageType)Int32.Parse(backup.StorageType);
var storageParams = backup.StorageParams == null ? new Dictionary <string, string>() : backup.StorageParams.ToDictionary(r => r.Key.ToString(), r => r.Value.ToString());
BackupHandler.StartBackup(storageType, storageParams, backup.BackupMail);
return(BackupHandler.GetBackupProgress());
}
public static async Task CleanupRestoreErrorAsync(BackupHandler handler, Guid appId, Guid id, ISemanticLog log)
{
try
{
await handler.CleanupRestoreErrorAsync(appId);
}
catch (Exception ex)
{
log.LogError(ex, id.ToString(), (logOperationId, w) => w
.WriteProperty("action", "cleanupRestore")
.WriteProperty("status", "failed")
.WriteProperty("operationId", logOperationId));
}
}
void timer_Elapsed(object sender, ElapsedEventArgs e)
{
try
{
timer.Interval = Helper.Add24HrsInterval;
log.Info("Next backup will be taken on : " + DateTime.Now.AddMilliseconds(Helper.Add24HrsInterval).ToString(Helper.AppConstants.DateTimeFormat));
var ObjBackupConfig = ProcessHandler.GetBackConfig();
BackupHandler.BackupDatabase(ObjBackupConfig);
}
catch (Exception ex)
{
log.Error(ex);
}
}
protected async override void OnAppearing()
{
base.OnAppearing();
DataTable dt = new DataTable();
BackupHandler edf = new BackupHandler();
var temp = (measunit)BindingContext;
using (var stream = await FileSystem.OpenAppPackageFileAsync("MEASUNIT.EDF"))
{
using (var reader = new StreamReader(stream))
{
dt = edf.readEDF(reader);
reader.Close();
}
stream.Close();
}
}
void TestBackupWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
ImageVisibility(true);
var ObjBackupConfig = GetBackupConfig();
ProcessingStatus("Taking Backup @ " + ObjBackupConfig.BackupLocation);
BackupHandler.BackupDatabase(ObjBackupConfig);
ImageVisibility(false);
MessageBox.Show("Test Backup successfull.", "Success");
}
catch (Exception)
{
ImageVisibility(false);
//
}
}
/// <summary>
/// Creates a backup of the database specified in the job details.
/// </summary>
/// <param name="context">The execution context.</param>
public void Execute(IJobExecutionContext context)
{
Guid databaseId;
if (Guid.TryParse(context.JobDetail.JobDataMap.GetString(CreateBackupJob.Properties.DatabaseId.ToString()), out databaseId))
{
BackupHandler backupHandler = new BackupHandler();
try
{
backupHandler.CreateBackup(databaseId);
}
catch (Exception ex)
{
new LogHandler().LogMessage(LogHandler.MessageType.ERROR, "Job: " + context.JobDetail.Key + Environment.NewLine + ex.ToString());
}
}
}
/// <summary>
/// Handles the Click event of the MakeManualBackupButton control: Creates a manual backup of the selected database.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void MakeManualBackupButton_Click(object sender, RoutedEventArgs e)
{
try
{
BackupHandler backupHandler = new BackupHandler();
if (backupHandler.CreateBackup(CurrentDbInfo.ID))
{
FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(string.Format("A backup of the database {0} has been created!", CurrentDbInfo.DatabaseName), "Success", MessageBoxButton.OK);
}
else
{
FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(string.Format("The backup of database {0} failed. Please check the log for details", CurrentDbInfo.DatabaseName), "Error", MessageBoxButton.OK);
}
}
catch (Exception ex)
{
FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(ex.ToString(), "Error", MessageBoxButton.OK);
}
}
private bool CreateBackupSchedule(BackupSchedule backupSchedule)
{
if (CoreBaseSettings.Standalone)
{
TenantExtra.DemandControlPanelPermission();
}
var storageType = backupSchedule.StorageType == null ? BackupStorageType.Documents : (BackupStorageType)Int32.Parse(backupSchedule.StorageType);
var storageParams = backupSchedule.StorageParams == null ? new Dictionary <string, string>() : backupSchedule.StorageParams.ToDictionary(r => r.Key.ToString(), r => r.Value.ToString());
var backupStored = backupSchedule.BackupsStored == null ? 0 : Int32.Parse(backupSchedule.BackupsStored);
var cron = new CronParams()
{
Period = backupSchedule.CronParams.Period == null ? BackupPeriod.EveryDay : (BackupPeriod)Int32.Parse(backupSchedule.CronParams.Period),
Hour = backupSchedule.CronParams.Hour == null ? 0 : Int32.Parse(backupSchedule.CronParams.Hour),
Day = backupSchedule.CronParams.Day == null ? 0 : Int32.Parse(backupSchedule.CronParams.Day),
};
BackupHandler.CreateSchedule(storageType, storageParams, backupStored, cron, backupSchedule.BackupMail);
return(true);
}
/// <summary>
/// Deletes a user
/// </summary>
/// <param name="user"></param>
public void DeleteUser(User user)
{
Users.Remove(user);
BackupHandler.DeleteBackup(user);
}
public async void LoadDataAsync()
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://192.168.4.1/Services?Backup");
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream resStream = response.GetResponseStream();
StreamReader reader = new StreamReader(resStream);
string text = reader.ReadToEnd();
loading.IsEnabled = true;
loading.IsVisible = true;
loading.IsRunning = true;
loadingLBL.IsVisible = true;
BackupHandler handler = new BackupHandler();
string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
string filename = Path.Combine(path, "KASA.txt");
string content = "";
using (var streamReader = new StreamReader(filename))
{
content = streamReader.ReadToEnd();
}
/*string text = "";
* using (var stream = await FileSystem.OpenAppPackageFileAsync("backup.tsv"))
* {
* using (var reader = new StreamReader(stream))
* {
* UTF8Encoding uTF8 = new UTF8Encoding();
* byte[] output = uTF8.GetBytes(reader.ReadToEnd());
* string tempString = Encoding.ASCII.GetString(output, 0, output.Length);
* text = tempString;
*
* reader.Close();
* }
* stream.Close();
* }*/
List <string> tables = handler.readToListofTables(text);
List <DataTable> dataTables = new List <DataTable>();
foreach (string t in tables)
{
dataTables.Add(handler.stringToDT(t));
}
var kasa = await App.Database.getKasaPLU(content);
if (kasa == null)
{
foreach (DataTable d in dataTables)
{
if (d.TableName.Equals("PLU"))
{
List <plu> plus = await App.Database.getPLU();
int dlzka = d.Rows.Count;
plus.Clear();
string[] columnNames = d.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName)
.ToArray();
for (int i = 0; i < dlzka; i++)
{
plus.Add(new plu
{
PLU = Convert.ToInt32(d.Rows[i][0]),
PLU_PRICE = d.Rows[i][1].ToString(),
PLU_NAME = d.Rows[i][2].ToString(),
PLU_BARCODE = d.Rows[i][3].ToString(),
PLU_TAXRATE = d.Rows[i][4].ToString(),
PLU_SPEC_REG = d.Rows[i][5].ToString(),
PLU_DPT = d.Rows[i][6].ToString(),
PLU_UNIT = d.Rows[i][7].ToString(),
PLU_LINK = d.Rows[i][8].ToString(),
PLU_OTHERPRICE = d.Rows[i][9].ToString(),
PLU_DESCRIPTOR = d.Rows[i][10].ToString(),
PLU_CONTAINER = d.Rows[i][11].ToString(),
KASA = content,
});
}
foreach (plu p in plus)
{
await App.Database.savePLU(p);
}
}
if (d.TableName.Equals("DPT"))
{
List <dpt> dpts = await App.Database.getDPT();
int dlzka = d.Rows.Count;
dpts.Clear();
for (int i = 0; i < dlzka; i++)
{
dpts.Add(new dpt
{
DPT = Convert.ToInt32(d.Rows[i][0]),
DPT_NAME = d.Rows[i][1].ToString(),
KASA = content
});
}
foreach (dpt p in dpts)
{
await App.Database.saveDPT(p);
}
}
if (d.TableName.Equals("OPERATOR"))
{
List <@operator> operators = await App.Database.getOPERATOR();
int dlzka = d.Rows.Count;
operators.Clear();
for (int i = 0; i < dlzka; i++)
{
operators.Add(new @operator
{
OPERATOR = Convert.ToInt32(d.Rows[i][0]),
OPERATOR_NAME = d.Rows[i][1].ToString(),
OPERATOR_PSWD = d.Rows[i][2].ToString(),
OPERATOR_XMODE = d.Rows[i][3].ToString(),
OPERATOR_ZMODE = d.Rows[i][4].ToString(),
OPERATOR_PMODE = d.Rows[i][5].ToString(),
OPERATOR_TMODE = d.Rows[i][6].ToString(),
OPERATOR_REFUND = d.Rows[i][7].ToString(),
OPERATOR_VOID = d.Rows[i][8].ToString(),
OPERATOR_SURDISC = d.Rows[i][9].ToString(),
KASA = content
});
}
foreach (@operator p in operators)
{
await App.Database.saveOPERATOR(p);
}
}
if (d.TableName.Equals("MEASUREUNIT"))
{
List <measunit> measunits = await App.Database.getMEASUNIT();
int dlzka = d.Rows.Count;
measunits.Clear();
for (int i = 0; i < dlzka; i++)
{
measunits.Add(new measunit
{
MEASUREUNIT = Convert.ToInt32(d.Rows[i][0]),
MEASUREUNIT_NAME = d.Rows[i][1].ToString(),
KASA = content
});
}
foreach (measunit p in measunits)
{
await App.Database.saveMEASUNIT(p);
}
}
if (d.TableName.Equals("SURDISC"))
{
List <surdisc> surdiscs = await App.Database.getSURDISC();
int dlzka = d.Rows.Count;
surdiscs.Clear();
for (int i = 0; i < dlzka; i++)
{
surdiscs.Add(new surdisc
{
SURDISC = Convert.ToInt32(d.Rows[i][0]),
PERCDISCRATE = d.Rows[i][1].ToString(),
PERCDISCLIMIT = d.Rows[i][2].ToString(),
KASA = content
});
}
foreach (surdisc p in surdiscs)
{
await App.Database.saveSURDISC(p);
}
}
if (d.TableName.Equals("TEXTLOGO"))
{
List <textlogo> textlogos = await App.Database.getTEXTLOGO();
int dlzka = d.Rows.Count;
textlogos.Clear();
for (int i = 0; i < dlzka; i++)
{
textlogos.Add(new textlogo
{
TEXTLOGO = Convert.ToInt32(d.Rows[i][0]),
LOGOLINE1 = d.Rows[i][1].ToString(),
LOGOLINE2 = d.Rows[i][2].ToString(),
LOGOLINE3 = d.Rows[i][3].ToString(),
LOGOLINE4 = d.Rows[i][4].ToString(),
LOGOLINE5 = d.Rows[i][5].ToString(),
LOGOLINE6 = d.Rows[i][6].ToString(),
LOGOLINE7 = d.Rows[i][7].ToString(),
LOGOLINE8 = d.Rows[i][8].ToString(),
LOGOLINE9 = d.Rows[i][9].ToString(),
KASA = content
});
}
foreach (textlogo p in textlogos)
{
await App.Database.saveTEXTLOGO(p);
}
}
if (d.TableName.Equals("FUNCTEXT"))
{
List <functext> functexts = await App.Database.getFUNCTEXT();
int dlzka = d.Rows.Count;
functexts.Clear();
for (int i = 0; i < dlzka; i++)
{
functexts.Add(new functext
{
FUNCTEXT = Convert.ToInt32(d.Rows[i][0]),
FUNCTEXT_REFERENCE_NUMBER_TEXT = d.Rows[i][1].ToString(),
KASA = content
});
}
foreach (functext p in functexts)
{
await App.Database.saveFUNCTEXT(p);
}
}
if (d.TableName.Equals("ECRLOC"))
{
List <ecrloc> ecrlocs = await App.Database.getECRLOC();
int dlzka = d.Rows.Count;
ecrlocs.Clear();
for (int i = 0; i < dlzka; i++)
{
ecrlocs.Add(new ecrloc
{
ECRLOC = Convert.ToInt32(d.Rows[i][0]),
ECRLOC_LOCTYPE = d.Rows[i][1].ToString(),
ECRLOC_LOCDESC = d.Rows[i][2].ToString(),
ECRLOC_MUNICIPALITY = d.Rows[i][3].ToString(),
ECRLOC_STREETNAME = d.Rows[i][4].ToString(),
ECRLOC_BUILDINGNUMBER = d.Rows[i][5].ToString(),
ECRLOC_PROPERTYREGNUMBER = d.Rows[i][6].ToString(),
ECRLOC_POSTALCODE = d.Rows[i][7].ToString(),
KASA = content
});
}
foreach (ecrloc p in ecrlocs)
{
await App.Database.saveECRLOC(p);
}
}
if (d.TableName.Equals("TRAILLOG"))
{
List <traillog> traillogs = await App.Database.getTRAILLOG();
int dlzka = d.Rows.Count;
traillogs.Clear();
for (int i = 0; i < dlzka; i++)
{
traillogs.Add(new traillog
{
TRAILERTEXTLOGO = Convert.ToInt32(d.Rows[i][0]),
LOGOLINE1 = d.Rows[i][1].ToString(),
LOGOLINE2 = d.Rows[i][2].ToString(),
LOGOLINE3 = d.Rows[i][3].ToString(),
LOGOLINE4 = d.Rows[i][4].ToString(),
LOGOLINE5 = d.Rows[i][5].ToString(),
LOGOLINE6 = d.Rows[i][6].ToString(),
LOGOLINE7 = d.Rows[i][7].ToString(),
LOGOLINE8 = d.Rows[i][8].ToString(),
LOGOLINE9 = d.Rows[i][9].ToString(),
KASA = content
});
}
foreach (traillog p in traillogs)
{
await App.Database.saveTRAILLOG(p);
}
}
if (d.TableName.Equals("ADVERTXT"))
{
List <advertxt> advertxts = await App.Database.getADVERTXT();
int dlzka = d.Rows.Count;
advertxts.Clear();
for (int i = 0; i < dlzka; i++)
{
advertxts.Add(new advertxt
{
ADVERTEXT = Convert.ToInt32(d.Rows[i][0]),
ADVERTISEMENT_TEXT = d.Rows[i][1].ToString(),
ADVERTISEMENT_TYPE = d.Rows[i][2].ToString(),
ADVERTISEMENT_LOOKUP = d.Rows[i][3].ToString(),
KASA = content
});
}
foreach (advertxt p in advertxts)
{
await App.Database.saveADVERTXT(p);
}
}
}
loading.IsEnabled = false;
loading.IsVisible = false;
loading.IsRunning = false;
loadingLBL.IsVisible = false;
await Navigation.PushAsync(new Tabbed());
}
}
public void BackupModelLocallyUsingRevit(Document doc)
{
var handler = new BackupHandler();
handler.BackupModelLocallyUsingRevit(doc);
}
