/// <summary>
/// Performs input validation and gets activity categories by ID, Name or by ID & Name.
/// </summary>
/// <param name="request">Request.</param>
/// <returns>List of activity categories found.</returns>
public static List<ActivityCategoryByNameGetReplyDC> GetActivityCategories(ActivityCategoryByNameGetRequestDC request)
{
List<ActivityCategoryByNameGetReplyDC> reply = null;
try
{
// Validates the input and throws ValidationException for any issues found.
request.ValidateRequest();
reply = ActivityCategoryRepositoryService.GetActivityCategories(request);
}
catch (ValidationException e)
{
e.HandleException();
}
catch (DataAccessException e)
{
e.HandleException();
}
return reply;
}
/// <summary>
/// Gets activity categories by ID, Name or by ID & Name.
/// </summary>
/// <param name="request">Request.</param>
/// <returns>List of activity categories found.</returns>
public static List<ActivityCategoryByNameGetReplyDC> GetActivityCategories(ActivityCategoryByNameGetRequestDC request)
{
List<ActivityCategoryByNameGetReplyDC> reply = null;
try
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand command = database.GetStoredProcCommand(StoredProcNames.ActivityCategoryGet);
database.AddParameter(command, StoredProcParamNames.Id, DbType.Int32, ParameterDirection.Input, null, DataRowVersion.Default, request.InId);
database.AddParameter(command, StoredProcParamNames.Name, DbType.String, ParameterDirection.Input, null, DataRowVersion.Default, request.InName);
using (IDataReader reader = database.ExecuteReader(command))
{
ActivityCategoryByNameGetReplyDC activityCategoryEntry = null;
reply = new List<ActivityCategoryByNameGetReplyDC>();
while (reader.Read())
{
activityCategoryEntry = new ActivityCategoryByNameGetReplyDC();
activityCategoryEntry.Guid = new Guid(Convert.ToString(reader[DataColumnNames.Guid]));
activityCategoryEntry.Description = Convert.ToString(reader[DataColumnNames.Description]) ?? string.Empty;
activityCategoryEntry.Id = Convert.ToInt32(reader[DataColumnNames.Id]);
activityCategoryEntry.MetaTags = Convert.ToString(reader[DataColumnNames.MetaTags]) ?? string.Empty;
activityCategoryEntry.Name = Convert.ToString(reader[DataColumnNames.Name]);
activityCategoryEntry.AuthGroupId = Convert.ToInt32(reader[DataColumnNames.AuthGroupId]);
activityCategoryEntry.AuthGroupName = Convert.ToString(reader[DataColumnNames.AuthGroupName]);
reply.Add(activityCategoryEntry);
}
}
}
catch (SqlException e)
{
e.HandleException();
}
return reply;
}
/// <summary>
/// Verify GET FROM ltblActivityCategory Table for Valid IDs
/// </summary>
/// <param name="id">id of row to do a get on</param>
private void GetActivityCategoriesForValidIDs(int id)
{
getByNameRequest = new ActivityCategoryByNameGetRequestDC();
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>();
getByNameRequest.Incaller = IN_CALLER;
getByNameRequest.IncallerVersion = IN_CALLER_VERSION;
getByNameRequest.InId = id;
try
{
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>(devBranchProxy.ActivityCategoryGet(getByNameRequest));
}
catch (FaultException ex)
{
Assert.Fail("Caught WCF FaultException: Message: {0} \n Stack Trace: {1}", ex.Message, ex.StackTrace);
}
catch (Exception e)
{
Assert.Fail("Caught Exception Invoking the Service. Message: {0} \n Stack Trace: {1}", e.Message, e.StackTrace);
}
// Validate
Assert.IsNotNull(getByNameReplyList, "getByNameReplyList is null.");
Assert.AreEqual(1, getByNameReplyList.Count, "getByNameReplyList.Count is not 1.");
Assert.IsNotNull(getByNameReplyList[0].StatusReply, "getByNameReplyList[0].StatusReply is null");
Assert.AreEqual(0, getByNameReplyList[0].StatusReply.Errorcode, "StatusReply.Errorcode is not 0. Instead it is {0}.", getByNameReplyList[0].StatusReply.Errorcode);
Assert.IsTrue(string.IsNullOrEmpty(getByNameReplyList[0].StatusReply.ErrorMessage), "Error Message is not null. Error Message: {0}", getByNameReplyList[0].StatusReply.ErrorMessage);
Assert.IsTrue(string.IsNullOrEmpty(getByNameReplyList[0].StatusReply.ErrorGuid), "ErrorGuid is not null. ErrorGuid: {0}", getByNameReplyList[0].StatusReply.ErrorGuid);
Assert.AreEqual(getByNameRequest.InId, getByNameReplyList[0].Id, "Service returned the wrong record. Expected Id: {0}, Actual Id: {1}", getByNameRequest.InId, getByNameReplyList[0].Id);
}
/// <summary>
/// Verify GET FROM ltblActivityCategory Table for a valid name
/// </summary>
/// <param name="name">name from row to do a get on</param>
/// <returns>returns the id of this row</returns>
private int GetActivityCategoriesForValidName(string name)
{
getByNameRequest = new ActivityCategoryByNameGetRequestDC();
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>();
getByNameRequest.Incaller = IN_CALLER;
getByNameRequest.IncallerVersion = IN_CALLER_VERSION;
getByNameRequest.InName = name;
try
{
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>(devBranchProxy.ActivityCategoryGet(getByNameRequest));
}
catch (FaultException ex)
{
Assert.Fail("Caught WCF FaultException: Message: {0} \n Stack Trace: {1}", ex.Message, ex.StackTrace);
}
catch (Exception e)
{
Assert.Fail("Caught Exception Invoking the Service. Message: {0} \n Stack Trace: {1}", e.Message, e.StackTrace);
}
// Validate
Assert.IsNotNull(getByNameReplyList, "getByNameReplyList is null.");
Assert.AreNotEqual(0, getByNameReplyList.Count, "getByNameReplyList.Count is 0");
Assert.IsNotNull(getByNameReplyList[0].StatusReply, "getByNameReplyList[0].StatusReply is null");
Assert.IsTrue(string.IsNullOrEmpty(getByNameReplyList[0].StatusReply.ErrorMessage), "Error Message is not null. Error Message: {0}", getByNameReplyList[0].StatusReply.ErrorMessage);
Assert.IsTrue(string.IsNullOrEmpty(getByNameReplyList[0].StatusReply.ErrorGuid), "ErrorGuid is not null. ErrorGuid: {0}", getByNameReplyList[0].StatusReply.ErrorGuid);
int id = getByNameReplyList[0].Id;
return id;
}
/// <summary>
/// Verify GET FROM ltblActivityCategory Table for softDeleted IDs
/// </summary>
/// <param name="getByNameRequest">object to do a get on</param>
private void GetActivityCategoriesForSoftDeletedIDs(ActivityCategoryByNameGetRequestDC getByNameRequest)
{
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>();
try
{
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>(devBranchProxy.ActivityCategoryGet(getByNameRequest));
}
catch (FaultException ex)
{
Assert.Fail("Caught WCF FaultException: Message: {0} \n Stack Trace: {1}", ex.Message, ex.StackTrace);
}
catch (Exception e)
{
Assert.Fail("Caught Exception Invoking the Service. Message: {0} \n Stack Trace: {1}", e.Message, e.StackTrace);
}
int errorConstant = GetErrorConstantSoftDeletedID();
// Validate
Assert.IsNotNull(getByNameReplyList, "getByNameReplyList is null.");
Assert.AreNotEqual(0, getByNameReplyList.Count, "getByNameReplyList.Count is 0");
Assert.IsNotNull(getByNameReplyList[0].StatusReply, "getByNameReplyList[0].StatusReply is null");
Assert.IsNotNull(getByNameReplyList[0].StatusReply.ErrorMessage, "Error Message is null.");
Assert.AreEqual(errorConstant, getByNameReplyList[0].StatusReply.Errorcode, "Returned the wrong status error code. InId: {0}", getByNameRequest.InId);
}
/// <summary>
/// Verify GET FROM ltblActivityCategory Table for softDeleted IDs
/// </summary>
/// <param name="softDeletedID">id of row to do a get on</param>
private void GetActivityCategoriesForSoftDeletedIDs(int softDeletedID)
{
getByNameRequest = new ActivityCategoryByNameGetRequestDC();
getByNameRequest.Incaller = IN_CALLER;
getByNameRequest.IncallerVersion = IN_CALLER_VERSION;
getByNameRequest.InId = softDeletedID;
GetActivityCategoriesForSoftDeletedIDs(getByNameRequest);
}
/// <summary>
/// Verify GET FROM ltblActivityCategory Table for Invalid IDs
/// </summary>
/// <param name="nonExistingID">id of row to do a get on</param>
private void GetActivityCategoriesForInvalidIDs(int nonExistingID)
{
bool isFaultException = false;
getByNameRequest = new ActivityCategoryByNameGetRequestDC();
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>();
getByNameRequest.Incaller = IN_CALLER;
getByNameRequest.IncallerVersion = IN_CALLER_VERSION;
getByNameRequest.InId = nonExistingID;
try
{
getByNameReplyList = new List<ActivityCategoryByNameGetReplyDC>(devBranchProxy.ActivityCategoryGet(getByNameRequest));
}
catch (FaultException ex)
{
Assert.Fail("Caught WCF FaultException: Message: {0} \n Stack Trace: {1}", ex.Message, ex.StackTrace);
}
catch (Exception e)
{
Assert.Fail("Caught Exception Invoking the Service. Message: {0} \n Stack Trace: {1}", e.Message, e.StackTrace);
}
if (!isFaultException)
{
// Validate
Assert.IsNotNull(getByNameReplyList, "getByNameReplyList is null.");
Assert.AreNotEqual(0, getByNameReplyList.Count, "getByNameReplyList.Count is 0");
Assert.IsNotNull(getByNameReplyList[0].StatusReply, "getByNameReplyList[0].StatusReply is null");
Assert.IsTrue(string.IsNullOrEmpty(getByNameReplyList[0].StatusReply.ErrorMessage), "Error Message is null.");
int id = getByNameReplyList[0].Id;
Assert.IsFalse(id > 1, "Id should be gereater than 1");
//int errorConstant = GetErrorConstantInvalidID(nonExistingID);
//Assert.AreNotEqual(errorConstant, getByNameReplyList[0].StatusReply.Errorcode, "Returned the wrong status error code. InId: {0}", nonExistingID);
}
}
public void BALActivityCategoryGet()
{
List<CWF.DataContracts.ActivityCategoryByNameGetReplyDC> reply = null;
try
{
CWF.DataContracts.ActivityCategoryByNameGetRequestDC request = new CWF.DataContracts.ActivityCategoryByNameGetRequestDC();
request.Incaller = INCALLER;
request.IncallerVersion = "1.0.0.0";
request.InName = "OAS Basic Controls";
try
{
reply = ActivityCategoryBusinessService.GetActivityCategories(request);
}
catch (Exception ex)
{
string faultMessage = ex.Message;
Assert.Fail(faultMessage + "-catch (Exception ex) in reply = CWF.DAL.Activities.ActivityCategoryGet(request);");
}
}
catch (Exception ex)
{
string faultMessage = ex.Message;
}
Assert.IsNotNull(reply);
Assert.AreEqual(reply[0].StatusReply.Errorcode, SprocValues.REPLY_ERRORCODE_VALUE_OK);
}
/// <summary>
/// Get a list of activity categories from the asset store.
/// </summary>
public static bool GetActivityCategories()
{
using (var client = WorkflowsQueryServiceUtility.GetWorkflowQueryServiceClient())
{
var request = new ActivityCategoryByNameGetRequestDC
{
Incaller = Assembly.GetExecutingAssembly().GetName().Name,
IncallerVersion = Assembly.GetExecutingAssembly().GetName().Version.ToString(),
InInsertedByUserAlias = Environment.UserName,
InUpdatedByUserAlias = Environment.UserName
};
var categoriesCollection = client.ActivityCategoryGet(request);
categoriesCollection.Add(new ActivityCategoryByNameGetReplyDC { Name = String.Empty }); // we need a blank entry in the import wizard on step #2
Categories.Assign(from category in categoriesCollection select category.Name);
ActivityCategories = new CollectionViewSource { Source = Categories };
ActivityCategories.SortDescriptions.Add(new SortDescription("", ListSortDirection.Ascending));
return true;
}
}