public int RefreshDatabaseFileSize(DataBaseServer srv, bGomlaDBreportEntities db)
{
var files = srv.DataBaseFiles;
if (!srv.Online)
{
return(0);
}
foreach (var file in files)
{
var fs = file.DataBaseFilesSizes.OrderByDescending(x => x.DateTaken).FirstOrDefault();
if (fs.DateTaken.Date != DateTime.Now.Date)
{
var curent = FileSizeMB(file); file.DataBaseFilesSizes.Add(new DataBaseFilesSize {
DateTaken = DateTime.Now, Size = curent
});
}
}
return(db.SaveChanges());
}
public int RefreshBackupLog(DataBaseServer srv, bGomlaDBreportEntities db)
{
_app.Files fe = new Files();
_app.Networking nt = new Networking();
int i = 0;
if (!srv.Online)
{
return(i);
}
foreach (var bkt in srv.ServerBackups)
{
// mark all files as do not exitis
if (bkt.LastFile.DateCreated.AddMinutes(bkt.intervalMin) < DateTime.Now)
{
foreach (var item in bkt.BackupLogs)
{
item.FileExists = false;
}
BackupLog log = new BackupLog();
var fls = fe.FilesInFolder(nt.RelosveFullPath(bkt.DataBaseServer, bkt.Location), bkt.BackupType.FilesExtintion);
foreach (var f in fls)
{
log = bkt.BackupLogs.FirstOrDefault(x => x.FileName == f.Name);
if (log == null)
{
log = new BackupLog
{
FileName = f.Name,
DateCreated = f.CreationTime,
SrvBkId = bkt.DbServerID,
FilePath = bkt.Location,
FileSize = fe.FileSizeMB(f),
};
bkt.BackupLogs.Add(log);
}
log.FileExists = true;
}
i += db.SaveChanges();
}
}
return(i);
}
public void TestSqlConnection(DataBaseServer server)
{
string str = @"data source={servername};initial catalog={dabasename};Integrated Security=false; User ID={userid}; Password={password};";
str = str.Replace("{servername}", server.Machine.MachineName);
str = str.Replace("{dabasename}", server.DataBaseName);
AccessAccount acc = new AccessAccount();
if (server.DBAccount == null)
{
bGomlaDBreportEntities db = new bGomlaDBreportEntities();
acc = db.AccessAccounts.FirstOrDefault(x => x.AccountID == server.DataBaseAccountID);
}
else
{
acc = server.DBAccount;
}
str = str.Replace("{userid}", acc.AccountName);
str = str.Replace("{password}", acc.AccountPassword);
SqlConnection con = new SqlConnection(str);
try
{
con.Open();
}
catch (Exception e)
{
addError(e.Message);
}
}
public int RefreshBackupLog(int serverid)
{
bGomlaDBreportEntities db = new bGomlaDBreportEntities();
return(RefreshBackupLog(db.DataBaseServers.Find(serverid), db));
}
public int RefreshDatabaseFileSize(int srvid)
{
bGomlaDBreportEntities db = new bGomlaDBreportEntities();
return(RefreshDatabaseFileSize(db.DataBaseServers.Find(srvid), db));
}
