private void DtgItems_SelectionChanged(object sender, Telerik.Windows.Controls.SelectionChangeEventArgs e)
{
if (dtgItems.SelectedItem != null)
{
var linkedServer = dtgItems.SelectedItem as LinkedServerDTO;
Message = linkedServer;
ShowMessage();
}
}
private LinkedServerDTO ToLinkedServer(LinkedServer linked)
{
LinkedServerDTO result = new LinkedServerDTO();
result.ID = linked.ID;
result.SourceDBServerID = linked.SourceDBServerID;
result.SourceDBServerName = linked.DBServer.Name;
result.TargetDBServerID = linked.TargetDBServerID;
result.TargetDBServerName = linked.DBServer1.Name;
result.Name = linked.Name;
return(result);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (Message == null)
{
Message = new LinkedServerDTO();
}
Message.SourceDBServerID = SourceServer.ID;
Message.TargetDBServerID = (int)lokTargetServer.SelectedValue;
Message.Name = txtTitle.Text;
Message.ID = bizDatabase.SaveLinkedServer(Message);
SetLinkedServers();
btnNew_Click(null, null);
}
public int SaveLinkedServer(LinkedServerDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbServer = projectContext.LinkedServer.FirstOrDefault(x => x.ID == message.ID);
if (dbServer == null)
{
dbServer = new LinkedServer();
}
dbServer.SourceDBServerID = message.SourceDBServerID;
dbServer.TargetDBServerID = message.TargetDBServerID;
dbServer.Name = message.Name;
if (dbServer.ID == 0)
{
projectContext.LinkedServer.Add(dbServer);
}
projectContext.SaveChanges();
return(dbServer.ID);
}
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
Message = new LinkedServerDTO();
ShowMessage();
}
private void GetDBServer(int linkedServerID)
{
Message = bizDatabase.GetLinkedServer(linkedServerID);
ShowMessage();
}
