public frmLinekedServer(int sourceServerID)
{
InitializeComponent();
SourceServer = bizDatabase.GetDBServer(sourceServerID);
lblSourceServer.Text = SourceServer.Name;
SetLinkedServers();
SetLookups();
dtgItems.SelectionChanged += DtgItems_SelectionChanged;
}
public frmDBServer(int serverID)
{
InitializeComponent();
if (serverID == 0)
{
Message = new DbServerDTO();
}
else
{
GetDBServer(serverID);
}
}
private DbServerDTO ToDBServerDTO(DBServer dbServer)
{
DbServerDTO result = new DbServerDTO();
result.ID = dbServer.ID;
result.Name = dbServer.Name;
result.Title = dbServer.Title;
result.IPAddress = dbServer.IPAddress;
foreach (var linked in dbServer.LinkedServer)
{
result.LinkedServers.Add(ToLinkedServer(linked));
}
return(result);
}
public int SaveServer(DbServerDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbServer = projectContext.DBServer.FirstOrDefault(x => x.ID == message.ID);
if (dbServer == null)
{
dbServer = new DBServer();
}
dbServer.Name = message.Name;
dbServer.Title = message.Title;
dbServer.IPAddress = message.IPAddress;
if (dbServer.ID == 0)
{
projectContext.DBServer.Add(dbServer);
}
projectContext.SaveChanges();
return(dbServer.ID);
}
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
Message = new DbServerDTO();
ShowMessage();
}
private void GetDBServer(int serverID)
{
Message = bizDatabase.GetDBServer(serverID);
ShowMessage();
}
