public List <schedules> getSchedulesByServerId(int id)
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.schedules.Where(schedule => schedule.server_id == id).ToList());
}
}
public List <mysql_servers> getAllMySqlServers()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.mysql_servers.ToList());
}
}
public List <userinfo> getUserinfo()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.userinfo.ToList());
}
}
public List <schedules> getSchedules()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.schedules.ToList());
}
}
public List <logs> getLogs()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.logs.ToList());
}
}
public List <backup_locations> getBackupLocations()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.backup_locations.ToList());
}
}
public List <schedule_save_locations> getScheduleSaveLocations()
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.schedule_save_locations.ToList());
}
}
public void deleteUserinfo(userinfo usrinfo)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.userinfo.Remove(usrinfo);
context.SaveChanges();
}
}
public void deleteBackupLocation(backup_locations bloc)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.backup_locations.Remove(bloc);
context.SaveChanges();
}
}
public void deleteScedulesaveLocation(schedule_save_locations scl)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.schedule_save_locations.Remove(scl);
context.SaveChanges();
}
}
public void deleteSchedule(schedules schedule)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.schedules.Remove(schedule);
context.SaveChanges();
}
}
//-------------------DELETE METHODS---------------------------------
public void deleteMysqlServer(mysql_servers server)
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
contextdb.mysql_servers.Remove(server);
contextdb.SaveChanges();
}
}
public void deleteLogs(logs log)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.logs.Remove(log);
context.SaveChanges();
}
}
public mysql_servers getMysqlServerById(long id)
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
mysql_servers server = contextdb.mysql_servers.Find(id);
return(server);
}
}
public List <schedule_save_locations> getSheduleSaveLocationByBackupLocId(int id)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
return(context.schedule_save_locations.Where(
schedule_save => schedule_save.backup_location_id == id
).ToList());
}
}
//return the new id
public int saveMysqlServer(mysql_servers server)
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
contextdb.mysql_servers.Add(server);
contextdb.SaveChanges();
return((int)server.id);
}
}
public List <schedule_save_locations> getScheduleSaveLocationByScheduleId(int id)
{
using (firedumpdbEntities1 contextdb = new firedumpdbEntities1())
{
return(contextdb.schedule_save_locations.Where(
scheduleS => scheduleS.schedule_id == id
).ToList());
}
}
public void updateSchedule(schedules schedule)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
schedules original = context.schedules.Find(schedule.id);
context.Entry(original).CurrentValues.SetValues(schedule);
context.SaveChanges();
}
}
//-------------------UPDATE METHODS---------------------------------
public void updateMysqlServer(mysql_servers mysqlserver)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
mysql_servers original = context.mysql_servers.Find(mysqlserver.id);
context.Entry(original).CurrentValues.SetValues(mysqlserver);
context.SaveChanges();
}
}
public List <logs> getLogsByScheduleId(int id)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
return(context.logs.Where(
log => log.schedule_id == id
).ToList());
}
}
public List <userinfo> getUserinfoByScheduleId(int id)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
return(context.userinfo.Where(
usr => usr.schedule_id == id
).ToList());
}
}
