public ServerBackup ReturnServerBackup(int backupId)
{
using (SqlConnection con = new SqlConnection(constring))
using (SqlCommand cmd = new SqlCommand("ReturnServerBackup", con))
{
ServerBackup backup = new ServerBackup();
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter id = new SqlParameter("@BackupID", SqlDbType.Int);
id.Value = backupId;
cmd.Parameters.Add(id);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
DataRow row = dt.Rows[0];
backup = new ServerBackup()
{
BackupID = (int)row["BackupID"],
Name = (string)row["Name"],
ScheduledTime = (DateTime)row["ScheduledTime"],
Frequency = (string)row["Frequency"],
BackupType = (string)row["BackupType"],
ExpirationDate = (DateTime)row["ExpirationDate"],
SQLBackupID = (int)row["SQLBackupID"]
};
}
return(backup);
}
}
public ActionResult AddPlan(ServerBackup backup)
{
if (ModelState.IsValid)
{
backup.DataBaseServer = null;
db.ServerBackups.Add(backup);
db.SaveChanges();
_app.Backups bk = new _app.Backups();
bk.RefreshBackupLog(backup.DbServerID);
return(RedirectToAction("index", new { id = backup.DbServerID }));
}
var srv = db.DataBaseServers.Find(backup.DbServerID);
var btl = db.BackupTypes.Where(x => !srv.ServerBackups.Any(y => x.typeID == y.BackupTypeID)).ToList();
if (btl.Count > 0)
{
ViewBag.BackupTypeID = new SelectList(btl,
"typeID", "typeName");
ServerBackup bk = new ServerBackup();
bk.DataBaseServer = srv;
bk.DbServerID = srv.ServerID;
bk.intervalMin = 1440;
}
return(View(backup));
}
public ActionResult AddPlan(int id)
{
var srv = db.ServerBackups.Where(x => x.DbServerID == id);
// var btl = db.BackupTypes.Where(x => !srv.ServerBackups.Any(y => x.typeID == y.BackupTypeID)).ToList();
//var result = peopleList2.Where(p => !peopleList1.Any(p2 => p2.ID == p.ID));
var btl = db.BackupTypes.Where(x => !srv.Any(y => x.typeID == y.BackupTypeID)).ToList();
// var btl = (from bt in db.BackupTypes where(!srv.ServerBackups.Any(x=> x.BackupTypeID == bt.typeID) ) select new { bt.typeID , bt.typeName }).ToList() ;
if (btl.Count > 0)
{
ViewBag.BackupTypeID = new SelectList(btl,
"typeID", "typeName");
ServerBackup bk = new ServerBackup();
bk.DataBaseServer = db.DataBaseServers.Find(id);
bk.DbServerID = id;
bk.intervalMin = 1440;
return(View(bk));
}
return(View());
}
public ActionResult Create(ServerBackup serverBackup)
{
if (ModelState.IsValid)
{
sprocs.MergeBackup(serverBackup);
return(RedirectToAction("Index", new { serverId = sprocs.ReturnSQLServer(serverBackup.SQLBackupID).Server_ServerID }));
}
//ServerBackupVM vm = new ServerBackupVM(0, serverId);
//ViewBag.Frequency = vm.frequency;
//ViewBag.BackupType = vm.type;
//ViewBag.SQLBackup = vm.SQLServer;
return(View(serverBackup));
}
// GET: ServerBackups/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ServerBackup serverBackup = sprocs.ReturnServerBackup((int)id);
if (serverBackup == null)
{
return(HttpNotFound());
}
return(View(serverBackup));
}
public void MergeBackup(ServerBackup serverBackup)
{
using (SqlConnection con = new SqlConnection(connectionString))
using (SqlCommand cmd = new SqlCommand("MergeBackup", con))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter id = new SqlParameter("@BackupID", SqlDbType.Int);
SqlParameter name = new SqlParameter("@Name", SqlDbType.VarChar, 25);
SqlParameter scheduledTime = new SqlParameter("@ScheduledTime", SqlDbType.DateTime);
SqlParameter frequency = new SqlParameter("@Frequency", SqlDbType.VarChar, 10);
SqlParameter backupType = new SqlParameter("@BackupType", SqlDbType.VarChar, 25);
SqlParameter expirationDate = new SqlParameter("@ExpirationDate", SqlDbType.Date);
SqlParameter sqlBackupID = new SqlParameter("@SQLBackupID", SqlDbType.Int);
id.Value = serverBackup.BackupID;
name.Value = serverBackup.Name;
scheduledTime.Value = serverBackup.ScheduledTime;
frequency.Value = serverBackup.Frequency;
backupType.Value = serverBackup.BackupType;
expirationDate.Value = serverBackup.ExpirationDate;
sqlBackupID.Value = serverBackup.SQLBackupID;
cmd.Parameters.Add(id);
cmd.Parameters.Add(name);
cmd.Parameters.Add(scheduledTime);
cmd.Parameters.Add(frequency);
cmd.Parameters.Add(backupType);
cmd.Parameters.Add(expirationDate);
cmd.Parameters.Add(sqlBackupID);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
}
finally
{
cmd.Dispose();
con.Close();
}
}
}
public ActionResult Edit(ServerBackup backup)
{
if (ModelState.IsValid)
{
var old = db.ServerBackups.Find(backup.SrvBkID);
old.Location = backup.Location;
old.intervalMin = backup.intervalMin;
backup.DataBaseServer = null;
db.Entry(old).State = System.Data.Entity.EntityState.Modified;
// db.ServerBackups.Add(backup);
db.SaveChanges();
return(RedirectToAction("index", new { id = backup.DbServerID }));
}
return(View(backup));
}
public ActionResult DeleteConfirmed(ServerBackup serverBackup)
{
sprocs.DeleteServerBackup(serverBackup.BackupID);
return(RedirectToAction("Index", new { serverId = sprocs.ReturnSQLServer(serverBackup.SQLBackupID).Server_ServerID }));
}
private void Setup(int id, int serverId)
{
if (id != 0)
{
backup = sprocs.ReturnServerBackup(id);
}
list = sprocs.ReturnSQLServers(serverId);
bool selectedSQL = false;
SQLServer.Add(new SelectListItem()
{
Text = "----Select SQL Database----", Value = "----Select SQL Database----"
});
foreach (SQLBackupServer item in list)
{
if (item.SQLBackupID == backup.SQLBackupID)
{
selectedSQL = true;
}
SQLServer.Add(new SelectListItem()
{
Text = item.DatabaseName, Value = item.SQLBackupID.ToString(), Selected = selectedSQL
});
selectedSQL = false;
}
//if (id != 0)
//{
// if (backup.Frequency.Equals("Daily"))
// {
// frequency.Add(new SelectListItem() { Text = "----Select Frequency----", Value = "----Select Frequency----" });
// frequency.Add(new SelectListItem() { Text = "Daily", Value = "Daily", Selected = true });
// frequency.Add(new SelectListItem() { Text = "Weekly", Value = "Weekly" });
// frequency.Add(new SelectListItem() { Text = "Monthly", Value = "Monthly" });
// }
// else if (backup.Frequency.Equals("Weekly"))
// {
// frequency.Add(new SelectListItem() { Text = "----Select Frequency----", Value = "----Select Frequency----" });
// frequency.Add(new SelectListItem() { Text = "Daily", Value = "Daily" });
// frequency.Add(new SelectListItem() { Text = "Weekly", Value = "Weekly", Selected = true });
// frequency.Add(new SelectListItem() { Text = "Monthly", Value = "Monthly" });
// }
// else if (backup.Frequency.Equals("Monthly"))
// {
// frequency.Add(new SelectListItem() { Text = "----Select Frequency----", Value = "----Select Frequency----" });
// frequency.Add(new SelectListItem() { Text = "Daily", Value = "Daily" });
// frequency.Add(new SelectListItem() { Text = "Weekly", Value = "Weekly" });
// frequency.Add(new SelectListItem() { Text = "Monthly", Value = "Monthly", Selected = true });
// }
// if (backup.BackupType.Equals("Full Backup"))
// {
// type.Add(new SelectListItem() { Text = "----Select Backup Type----", Value = "----Select Backup Type----" });
// type.Add(new SelectListItem() { Text = "Full Backup", Value = "Full Backup", Selected = true });
// type.Add(new SelectListItem() { Text = "Incremental Backup", Value = "Incremental Backup" });
// }
// else if (backup.BackupType.Equals("Full Backup"))
// {
// type.Add(new SelectListItem() { Text = "----Select Backup Type----", Value = "----Select Backup Type----" });
// type.Add(new SelectListItem() { Text = "Full Backup", Value = "Full Backup" });
// type.Add(new SelectListItem() { Text = "Incremental Backup", Value = "Incremental Backup", Selected = true });
// }
//}
//else
//{
frequency.Add(new SelectListItem()
{
Text = "----Select Frequency----", Value = "----Select Frequency----"
});
frequency.Add(new SelectListItem()
{
Text = "Daily", Value = "Daily"
});
frequency.Add(new SelectListItem()
{
Text = "Weekly", Value = "Weekly"
});
frequency.Add(new SelectListItem()
{
Text = "Monthly", Value = "Monthly"
});
type.Add(new SelectListItem()
{
Text = "----Select Backup Type----", Value = "----Select Backup Type----"
});
type.Add(new SelectListItem()
{
Text = "Full Backup", Value = "Full Backup"
});
type.Add(new SelectListItem()
{
Text = "Incremental Backup", Value = "Incremental Backup"
});
//}
}
