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