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(); }