public Sender CloneSender(Sender SenderToClone, String NewSenderName) { if (String.IsNullOrEmpty (NewSenderName)) NewSenderName = "Clone von " + SenderToClone.Name; DataSet NewSenderDataSet = DataWrapper.Instance.WPMediaAccess.GetCommonDataSet ("Select * from Sender where SenderID = '" + Guid.Empty.ToString () + "'"); NewSenderDataSet.Tables ["Sender"].ImportRow (SenderToClone.BasisRow); NewSenderDataSet.Tables ["Sender"].Rows[0].SetAdded(); NewSenderDataSet.Tables ["Sender"].Rows[0]["SenderID"] = Guid.NewGuid(); NewSenderDataSet.Tables ["Sender"].Rows[0] ["Name"] = NewSenderName; NewSenderDataSet.Tables ["Sender"].Rows[0] ["IsActive"] = "No"; String ErrorText = DataWrapper.Instance.WPMediaAccess.SetCommonDataSet (NewSenderDataSet.GetChanges()); if (!String.IsNullOrEmpty (ErrorText)) throw new Exception (ErrorText); DataSet ProgrammBloeckeZuSendern = DataWrapper.Instance.WPMediaAccess.GetCommonDataSet ("Select * from ProgrammBloeckeZuSender where SenderID = '" + SenderToClone.SenderID.ToString () + "'"); List<DataRow> RowsToAdd = new List<DataRow> (); foreach (DataRow OldEntry in ProgrammBloeckeZuSendern.Tables ["ProgrammBloeckeZuSender"].Rows) { String InsertStatement = "Insert into ProgrammBloeckeZuSender (ID, SenderID, BlockID) values " + "('" + Guid.NewGuid ().ToString () + "', '" + NewSenderDataSet.Tables ["Sender"].Rows [0] ["SenderID"].ToString () + "', '" + OldEntry ["BlockID"].ToString () + "')"; DataWrapper.Instance.WPMediaAccess.RunSQLBatch (InsertStatement); } WMB.DataWrapper.Instance.ProgrammConnectoren = null; return new Sender (this, NewSenderDataSet.Tables["Sender"].Rows[0]); }
public void DeleteSender (Sender SenderToDelete) { String SenderID = SenderToDelete.ID.ToString (); DataSet DeleteSenderDataSet = DataWrapper.Instance.WPMediaAccess.GetCommonMultiDataSet (new String [] { "Select * from ProgrammBloeckeZuSender where SenderID = '" + SenderID + "'", "Select * from Sender where SenderID = '" + SenderID + "'" }); foreach (DataRow ConnectionRow in DeleteSenderDataSet.Tables["ProgrammBloeckeZuSender"].Rows) ConnectionRow.Delete(); foreach (DataRow SenderRow in DeleteSenderDataSet.Tables["Sender"].Rows) SenderRow.Delete(); DataWrapper.Instance.WPMediaAccess.SetCommonDataSet (DeleteSenderDataSet.GetChanges()); AllSender.Remove (SenderToDelete); SelectedSender = null; }
public bool ModifySenderDataBase (Sender SenderToModify) { DataSet Changes = SenderToModify.BasisRow.Table.DataSet.GetChanges (); if (Changes != null) WMB.DataWrapper.Instance.WPMediaAccess.SetCommonDataSet (Changes); return true; }