public DataValidatorReturn Create(string activityDescription, int activityTypeID)
{
DVR = MethodHelper.IsParameterEmpty("Activity", activityDescription);
if (DVR.IsValid == false)
{
return(DVR);
}
if (Find(activityDescription).ItemFound)
{
DVR.IsValid = false;
DVR.ReturnText = activityDescription + " already exists.";
DVR.ItemFound = true;
return(DVR);
}
BO_ActivityType bO_ActivityType = new BO_ActivityType();
DVR = bO_ActivityType.Find(activityTypeID);
if (DVR.ItemFound == false)
{
return(DVR);
}
using (var context = new WorkOrderLogEntities())
{
Activity activity = new Activity()
{
ActivityDescription = activityDescription,
ActivityTypeID = activityTypeID
};
try
{
context.Activities.Add(activity);
context.SaveChanges();
DVR.IsValid = true;
DVR.ReturnText = "Activity: " + activityDescription + " Added to the Database.";
DVR.ReturnType = activity;
}
catch (Exception exception)
{
DVR.IsValid = false;
DVR.ReturnText = exception.Message;
}
}
return(DVR);
}
public DataValidatorReturn Find(int activityTypeID)
{
DVR = MethodHelper.IsGreaterThanZero("Activity Type ID", activityTypeID);
if (DVR.IsValid == false)
{
return(DVR);
}
BO_ActivityType bo_ActivityType = new BO_ActivityType();
DVR = bo_ActivityType.Find(activityTypeID);
if (DVR.ItemFound == false)
{
return(DVR);
}
try
{
List <SourceScriptHdr> sourceScriptHdrs = new List <SourceScriptHdr>();
using (var context = new WorkOrderLogEntities())
{
sourceScriptHdrs = context.SourceScriptHdrs.Include(x => x.SourceScriptDtls.Select(c => c.Client)).Where(x => x.ActivityTypeID == activityTypeID).ToList();
}
DVR.ItemFound = sourceScriptHdrs.Any();
DVR.IsValid = true;
DVR.ReturnType = sourceScriptHdrs.FirstOrDefault();
if (DVR.ItemFound)
{
DVR.ReturnText = sourceScriptHdrs.Count().ToString() + " Source Script Headers Found.";
DVR.ReturnType = sourceScriptHdrs.FirstOrDefault();
}
else
{
DVR.ReturnText = "Source Script Header Not Found.";
}
}
catch (Exception exception)
{
DVR.IsValid = false;
DVR.ReturnText = exception.Message;
}
return(DVR);
}
