public void TestDeleteScheduleItemPublishEditCopyRelationship_Accuracy()
{
HermesScheduleItem parent = AccuracyTestsHelper.CreateHermesScheduleItem();
instance.SaveActivityGroup(parent.Activity.ActivityType.ActivityGroup);
instance.SaveActivityType(parent.Activity.ActivityType);
instance.SaveActivity(parent.Activity);
instance.SaveScheduleItemRequestStatus(parent.ScheduleItemRequestStatus);
instance.SaveScheduleItemStatus(parent.ScheduleItemStatus);
instance.SaveScheduleItem(parent);
HermesScheduleItem editCopy = AccuracyTestsHelper.CreateHermesScheduleItem();
instance.SaveActivityGroup(editCopy.Activity.ActivityType.ActivityGroup);
instance.SaveActivityType(editCopy.Activity.ActivityType);
instance.SaveActivity(editCopy.Activity);
instance.SaveScheduleItemRequestStatus(editCopy.ScheduleItemRequestStatus);
instance.SaveScheduleItemStatus(editCopy.ScheduleItemStatus);
instance.SaveScheduleItem(editCopy);
instance.CreateScheduleItemPublishEditCopyRelationship(parent, editCopy);
// Verify
HermesScheduleItem dbEditCopy = instance.GetScheduleItemEditCopy(parent);
AccuracyTestsHelper.VerifyHermesScheduleItem(editCopy, dbEditCopy);
HermesScheduleItem dbParent = instance.GetScheduleItemParentCopy(editCopy);
AccuracyTestsHelper.VerifyHermesScheduleItem(parent, dbParent);
instance.DeleteScheduleItemPublishEditCopyRelationship(editCopy);
// Verify
dbEditCopy = instance.GetScheduleItemEditCopy(parent);
Assert.IsNull(dbEditCopy);
dbParent = instance.GetScheduleItemParentCopy(editCopy);
Assert.IsNull(dbParent);
}
public void Demo()
{
HermesScheduleItemPersistenceProvider hsipp = new HermesScheduleItemPersistenceProvider();
///////////////////INSERT UPDATE GET DELETE/////////////////////////////
// Create an activity group
HermesActivityGroup hag = new HermesActivityGroup();
hag.Id = new Guid("1234567890ABCDEF1234567890ABCDEF").ToString();
hag.Abbreviation = "HAG1";
hag.Name = "HermesActivityGroup1";
hag.LastModifiedBy = "hagUser";
hag.LastModifiedDate = new DateTime(2007, 7, 7);
//Save it into database
hsipp.SaveActivityGroup(hag);
//Get it from database
HermesActivityGroup getFromDb = hsipp.GetActivityGroup("1234567890ABCDEF1234567890ABCDEF");
//Delete it from database
hsipp.DeleteActivityGroup("1234567890ABCDEF1234567890ABCDEF");
//Create an activity type
HermesActivityType hat = new HermesActivityType();
hat.Id = new Guid("34563456345634563456345634563456").ToString();
hat.Abbreviation = "HAT1";
hat.Name = "HermesActivityType1";
hat.LastModifiedBy = "hatUser";
hat.LastModifiedDate = new DateTime(2007, 11, 7);
hat.ActivityGroup = hsipp.GetActivityGroup("11111111111111111111111111111111");
//Save it into database
hsipp.SaveActivityType(hat);
//Get it from database
HermesActivityType getFromDb2 = hsipp.GetActivityType("34563456345634563456345634563456");
//Delete it from database
hsipp.DeleteActivityType("34563456345634563456345634563456");
//Create an activity
HermesActivity activity = new HermesActivity();
activity.Id = new Guid("99887766998877669988776699887766").ToString();
activity.Abbreviation = "ACT";
activity.ActivityType = hsipp.GetActivityType("22222222222222222222222222222222");
activity.DefaultDuration = new decimal(33.45);
activity.DefaultExpireDays = 666;
activity.DefaultStartTime = 432;
activity.Enabled = true;
activity.ExclusiveFlag = true;
activity.LastModifiedBy = "ACTuser";
activity.LastModifiedDate = new DateTime(2007, 8, 8);
activity.Name = "CoolAndReallyNiceActivity";
activity.WorkDayAmount = 9966;
//Save it into database
hsipp.SaveActivity(activity);
//Get it from database
HermesActivity getFromDb3 = hsipp.GetActivity("99887766998877669988776699887766");
//Delete it from database
hsipp.DeleteActivity("99887766998877669988776699887766");
//Create a ScheduleItem and save
HermesScheduleItem hsiParent = new HermesScheduleItem();
hsiParent.Id = new Guid("19081908190819081908190819081908").ToString();
hsiParent.Activity = hsipp.GetActivity("33333333333333333333333333333333");
hsiParent.Duration = new decimal(546.89);
hsiParent.ExceptionFlag = 'Y';
hsiParent.ExpirationDate = new DateTime(2005, 12, 23);
hsiParent.LastModifiedBy = "ivern";
hsiParent.LastModifiedDate = new DateTime(2007, 12, 1);
HermesGenericNote note = new HermesGenericNote();
note.Id = new Guid("12340987123409871234098712340987").ToString();
hsiParent.Note = note;
hsiParent.ScheduleItemRequestStatus = hsipp.GetScheduleItemRequestStatus("55555555555555555555555555555555");
hsiParent.ScheduleItemStatus = hsipp.GetScheduleItemStatus("44444444444444444444444444444444");
hsiParent.Version = 1;
hsiParent.WorkDate = new DateTime(2004, 12, 12);
hsiParent.WorkDayAmount = new Decimal(86787.23);
hsipp.SaveScheduleItem(hsiParent);
//Create another ScheduleItem and save
HermesScheduleItem hsiEdit = new HermesScheduleItem();
hsiEdit.Id = new Guid("23451987234519872345198723451987").ToString();
hsiEdit.Activity = hsipp.GetActivity("33333333333333333333333333333333");
hsiEdit.Duration = new decimal(546.89);
hsiEdit.ExceptionFlag = 'Y';
hsiEdit.ExpirationDate = new DateTime(2005, 12, 23);
hsiEdit.LastModifiedBy = "ivern";
hsiEdit.LastModifiedDate = new DateTime(2007, 12, 1);
HermesGenericNote note2 = new HermesGenericNote();
note2.Id = new Guid("12340987123409871234098712340987").ToString();
hsiEdit.Note = note2;
hsiEdit.ScheduleItemRequestStatus = hsipp.GetScheduleItemRequestStatus("55555555555555555555555555555555");
hsiEdit.ScheduleItemStatus = hsipp.GetScheduleItemStatus("44444444444444444444444444444444");
hsiEdit.Version = 1;
hsiEdit.WorkDate = new DateTime(2004, 12, 12);
hsiEdit.WorkDayAmount = new Decimal(86787.23);
hsipp.SaveScheduleItem(hsiEdit);
//....and so on for other properties
/////////////////GET ALL ENTITIES//////////
IList <HermesScheduleItemRequestStatus> reqStats = hsipp.GetAllScheduleItemRequestStatuses();
IList <HermesScheduleItemStatus> statuses = hsipp.GetAllScheduleItemStatuses();
IList <HermesActivity> items = hsipp.GetAllActivities(false);
//....and so on for other properties
//////////////MANAGE SCHEDULE ITEMS RELATIONS////////////////
hsipp.CreateScheduleItemPublishEditCopyRelationship(hsiParent, hsiEdit);
hsipp.GetScheduleItemEditCopy(hsiParent);
hsipp.GetScheduleItemParentCopy(hsiEdit);
hsipp.DeleteScheduleItemPublishEditCopyRelationship(hsiEdit);
}
public void TestDeleteScheduleItemPublishEditCopyRelationship_ConnectionNameInvalidl()
{
invalidProvider.DeleteScheduleItemPublishEditCopyRelationship(CreateScheduleItem());
}
public void TestDeleteScheduleItemPublishEditCopyRelationship_EditCopyIsNull()
{
provider.DeleteScheduleItemPublishEditCopyRelationship(null);
}