public static JobReferenceCollection GetJobReferencesFromClickKeys(int[] clickKeys)
{
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selJobReferencesFromClickKeys";
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("JobReferences", clickKeys);
colParameters.Add(objParameter);
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, null).Tables[0];
return Populate(dtResults);
}
public static JobReferenceCollection GetJobReferences(string sourceSystem, int[] sourceIDs)
{
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selJobReferencesFromWMSourceIDs";
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", sourceIDs);
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem));
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters).Tables[0];
return Populate(dtResults);
}
private bool SaveActivityAssociations()
{
DataAccess objADO = Domain.GetADOInstance(Domain.eConnectionName.Metadata);
ArrayList colParameters = new ArrayList();
DataAccess.ArrayListParameter arrayParameter = null;
string strStoredProcedure = "updProjectActivities";
int intReturn = 0;
// 1. Update Child Activities (remove current db records not in list passed in)
colParameters.Add(new SqlParameter("@ActivityID", this.ID));
if (mColAssociatedActivities != null && mColAssociatedActivities.Count > 0)
{
if (mColAssociatedActivities != null && mColAssociatedActivities.Count > 0)
{
int[] childActivities = new int[mColAssociatedActivities.Count];
for (int intIndex = 0; intIndex < mColAssociatedActivities.Count; intIndex++)
{
childActivities[intIndex] = mColAssociatedActivities[intIndex].ID;
}
arrayParameter = new DataAccess.ArrayListParameter("ChildActivities", childActivities);
}
}
if (arrayParameter != null)
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, arrayParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
// 2. Update LeadTime values for any AssociatedActivities present
if (mColAssociatedActivities != null && mColAssociatedActivities.Count > 0)
{
strStoredProcedure = "updProjectActivityAttributes";
colParameters.Clear();
foreach (AssociatedActivityReference activityReference in mColAssociatedActivities)
{
colParameters.Add(new SqlParameter("@ActivityID", this.ID));
colParameters.Add(new SqlParameter("@ChildActivityID", activityReference.ID));
colParameters.Add(new SqlParameter("@LeadTime", activityReference.LeadTime));
intReturn += objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
colParameters.Clear();
}
}
objADO = null;
return (intReturn > 0);
}
public bool Save(System.Xml.XmlDocument streamTemplate)
{
DataAccess objADO = Domain.GetADOInstance(Domain.eConnectionName.Metadata);
ArrayList colParameters = new ArrayList();
DataAccess.ArrayListParameter arrayParameter = null;
SqlParameter returnParameter = null;
SqlParameter xmlParameter = null;
string strStoredProcedure = "updActivity";
int intReturn = 0;
if (this.ID > 0)
{
colParameters.Add(new SqlParameter("@ActivityID", this.ID));
}
else
{
strStoredProcedure = "insActivity";
returnParameter = new SqlParameter("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
colParameters.Add(returnParameter);
}
colParameters.Add(new SqlParameter("@ActivityCode", this.Code));
colParameters.Add(new SqlParameter("@CategoryID", mintParentCategoryID));
colParameters.Add(new SqlParameter("@ActivityDesc", this.Description));
colParameters.Add(new SqlParameter("@IsReactive", mblnIsReactive));
colParameters.Add(new SqlParameter("@IsVisibleInClick", mblnIsVisibleInClick));
colParameters.Add(new SqlParameter("@IsVisibleInField", mblnIsVisibleInField));
colParameters.Add(new SqlParameter("@AreUtilityPlansRequired", mblnAreUtilityPlansRequired));
colParameters.Add(new SqlParameter("@IsProject", mblnIsProject));
colParameters.Add(new SqlParameter("@Duration", mintDuration));
colParameters.Add(new SqlParameter("@Comments", mstrComments));
colParameters.Add(new SqlParameter("@MethodOfDetection", mstrMethodOfDetection));
colParameters.Add(new SqlParameter("@AreSkillsMappedAtActivityLevel", mblnAreSkillsMappedAtActivityLevel)); // AT release 3
colParameters.Add(new SqlParameter("@IsFailure", mblnIsFailure));
if (!string.IsNullOrEmpty(this.DistrictGroup))
{
colParameters.Add(new SqlParameter("@DistrictGroup", this.DistrictGroup));
}
if (!mblnIsProject)
{
colParameters.Add(new SqlParameter("@SchedulingPriorityID", mobjSchedulingPriority.ID));
colParameters.Add(new SqlParameter("@DispatchPriorityID", mobjDispatchPriority.ID));
if (mstrEarlyStartTime != null && mstrEarlyStartTime != string.Empty)
{
colParameters.Add(new SqlParameter("@EarlyStartTime", mstrEarlyStartTime));
}
colParameters.Add(new SqlParameter("@IsDueDateFixed", mblnIsDueDateFixed));
colParameters.Add(new SqlParameter("@EarlyStartDaysBeforeDue", mintEarlyStartDaysBeforeDue));
if (mColOnHoldReasons != null && mColOnHoldReasons.Count > 0)
{
int[] onHoldReasonIDs = new int[mColOnHoldReasons.Count];
for (int intIndex = 0; intIndex < mColOnHoldReasons.Count; intIndex++)
{
onHoldReasonIDs[intIndex] = mColOnHoldReasons[intIndex].ID;
}
arrayParameter = new DataAccess.ArrayListParameter("OnHoldReasons", onHoldReasonIDs);
}
}
if (streamTemplate != null)
{
xmlParameter = new SqlParameter("@StreamTemplate", SqlDbType.Xml);
xmlParameter.Value = new System.Data.SqlTypes.SqlXml(new System.Xml.XmlTextReader(streamTemplate.OuterXml, System.Xml.XmlNodeType.Document, null));
colParameters.Add(xmlParameter);
}
if (arrayParameter != null)
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, arrayParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
objADO = null;
if (returnParameter != null && !returnParameter.Value.Equals(DBNull.Value))
{
this.ID = (int)returnParameter.Value;
}
if (mblnIsProject)
{
SaveActivityAssociations();
}
FileAssociationCollection currentFileAssociations = GetFileAssociations();
if (mColFileAssociations == null || mColFileAssociations.Count < 1)
{
if (currentFileAssociations != null && currentFileAssociations.Count > 0)
{
// Remove all existing File Associations from database
foreach (FileAssociation fileToRemove in currentFileAssociations)
{
currentFileAssociations.Remove(fileToRemove, this.ID);
}
}
}
else
{
mColFileAssociations.Save(this.ID);
if (currentFileAssociations != null && currentFileAssociations.Count > 0)
{
// Remove any File Associations not in ATM updated set from database
foreach (FileAssociation fileToRemove in currentFileAssociations)
{
bool fileFound = false;
foreach (FileAssociation fileToKeep in mColFileAssociations)
{
if (fileToRemove.Path == fileToKeep.Path)
{
fileFound = true;
break;
}
}
if (!fileFound)
{
currentFileAssociations.Remove(fileToRemove, this.ID);
}
}
}
}
// AT 160911 need to save skills matrix here
// Child collection special case - Skills
if (this.AreSkillsMappedAtActivityLevel)
{
SaveSkillsMatrix();
}
return (intReturn > 0);
}
public bool Save()
{
DataAccess objADO = null;
ArrayList colParameters = new ArrayList();
DataAccess.ArrayListParameter arrayParameter = null;
SqlParameter returnParameter = null;
string strStoredProcedure = "insAssignmentContraints";
int returnID = 0;
//SQL SP Paremeters as per below...
//=======================================
//@AssignmentConstraintID int = null,
//@WMSourceID int,
//@InstanceNumber int,
//@TimeWindow varchar(20)= null,
//@Duration int= null,
//@StartTime datetime= null,
//@EndTime datetime= null,
//@SpecificStartTime datetime= null,
//@MustBeCompletedByTime datetime= null
//@StartTime_IsUserSet bit = null
//@SkillCodes varchar(8000) = null
if (this.UpdateInsideTransaction && this.AssignmentConstraintsDataAccess != null)
{
objADO = this.AssignmentConstraintsDataAccess;
}
else
{
objADO = new DataAccess();
}
if (this == null)
{
return false;
}
if (this.ID > 0)
{
colParameters.Add(new SqlParameter("@AssignmentConstraintID", this.ID));
}
colParameters.Add(new SqlParameter("@WMSourceID", this.WMSourceID));
colParameters.Add(new SqlParameter("@InstanceNumber", this.Instance));
colParameters.Add(new SqlParameter("@TimeWindow", this.TimeWindow.ToString()));
colParameters.Add(new SqlParameter("@Duration", this.Duration));
if (this.StartTime != DateTime.MinValue)
{
colParameters.Add(new SqlParameter("@StartTime", this.StartTime));
}
if (this.EndTime != DateTime.MinValue)
{
colParameters.Add(new SqlParameter("@EndTime", this.EndTime));
}
if (this.SpecificStartTime != DateTime.MinValue)
{
colParameters.Add(new SqlParameter("@SpecificStartTime", this.SpecificStartTime));
}
if (this.MustBeCompletedByTime != DateTime.MinValue)
{
colParameters.Add(new SqlParameter("@MustBeCompletedByTime", this.MustBeCompletedByTime));
}
colParameters.Add(new SqlParameter("@StartTime_IsUserSet", this.IsUserSetStartDate));
//Skills
if (this.Skills != null && this.Skills.Count > 0)
{
string[] skillCodes = new string[this.Skills.Count];
for (int intIndex = 0; intIndex < this.Skills.Count; intIndex++)
{
skillCodes[intIndex] = this.Skills[intIndex].Code;
}
arrayParameter = new DataAccess.ArrayListParameter("SkillCodes", skillCodes);
}
returnParameter = new SqlParameter("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
colParameters.Add(returnParameter);
if (arrayParameter != null)
{
returnID = objADO.ExecuteSQL(strStoredProcedure, arrayParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
returnID = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
if (!this.UpdateInsideTransaction)
{
objADO = null;
}
return (returnID > 0);
}
/// <summary>
/// Release 3 : work item 2422: Added ActivityId parament to save method
/// </summary>
/// <param name="ActivityID"></param>
/// <returns></returns>
public bool Save(int ActivityID)
{
DataAccess objADO = Domain.GetADOInstance(Domain.eConnectionName.Metadata);
ArrayList colParameters = new ArrayList();
DataAccess.ArrayListParameter arrayParameter = null;
SqlParameter returnParameter = null;
string strStoredProcedure = "updTaskLibrary";
int intReturn = 0;
if (this.ID > 0)
{
colParameters.Add(new SqlParameter("@TaskID", this.ID));
}
else
{
strStoredProcedure = "insTaskLibrary";
returnParameter = new SqlParameter("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
colParameters.Add(returnParameter);
}
colParameters.Add(new SqlParameter("@Duration", this.Duration));
colParameters.Add(new SqlParameter("@IsCritical", this.IsCritical));
colParameters.Add(new SqlParameter("@TaskDesc", this.Description));
if (ActivityID != -1)
{
colParameters.Add(new SqlParameter("@ActivityID", ActivityID));
}
if (this.TaskUpdateType != null)
{
colParameters.Add(new SqlParameter("@TypeName", this.TaskUpdateType.Name));
}
// Child collections
if (this.MaterialsRequired != null && this.MaterialsRequired.Count > 0)
{
string commaSeparatedList = string.Empty;
for (int intIndex = 0; intIndex < this.MaterialsRequired.Count; intIndex++)
{
commaSeparatedList += this.MaterialsRequired[intIndex].ID.ToString() + ",";
}
commaSeparatedList = commaSeparatedList.Substring(0, commaSeparatedList.Length - 1);
colParameters.Add(new SqlParameter("@Materials", commaSeparatedList));
}
if (mColAssociatedActivities != null && mColAssociatedActivities.Count > 0)
{
int[] activities = new int[mColAssociatedActivities.Count];
for (int intIndex = 0; intIndex < activities.Length; intIndex++)
{
activities[intIndex] = mColAssociatedActivities[intIndex].ID;
}
arrayParameter = new DataAccess.ArrayListParameter("Activities", activities);
}
// Execute SQL
if (arrayParameter != null)
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, arrayParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
intReturn = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
if (returnParameter != null && !returnParameter.Value.Equals(DBNull.Value))
{
this.ID = (int)returnParameter.Value;
}
objADO = null;
// Child collection special case - Skills
SaveSkillsMatrix();
objADO = null;
return (intReturn > 0);
}
public static List<Job> GetJobsByReference(string[] sourceIDs, eWMSourceSystem sourceSystem, Type inheritedType, bool includeArchived)
{
List<Job> colJobs = new List<Job>();
Job deserializedJob = null;
DataTable dtResults = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
System.Data.SqlClient.SqlParameter[] arrParameters = null;
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selJobsByReference";
objADO = Domain.GetADOInstance();
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", sourceIDs);
//If Source System is UnSpecified then it is not relevant .. so any will be returned
if (sourceSystem != eWMSourceSystem.Unspecified)
{
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem.ToString()));
}
if (includeArchived)
{
colParameters.Add(new SqlParameter("@IncludeArchived", includeArchived));
}
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters).Tables[0];
objADO = null;
foreach (DataRow drSerializedJob in dtResults.Rows)
{
Type inheritedTypeToUse = null;
if (inheritedType == null)
{
inheritedTypeToUse = Type.GetType(drSerializedJob["TypeName"].ToString());
}
else
{
inheritedTypeToUse = inheritedType;
}
if (!drSerializedJob["Serialized"].Equals(DBNull.Value))
{
System.Xml.XmlDocument objDOM = new System.Xml.XmlDocument();
objDOM.LoadXml(drSerializedJob["Serialized"].ToString());
deserializedJob = (Job)BusinessObjects.Base.Deserialize(inheritedTypeToUse, objDOM);
if (!drSerializedJob["DateReopened"].Equals(DBNull.Value))
{
deserializedJob.DateReopened = (DateTime)drSerializedJob["DateReopened"];
}
// NB: Set properties that are Instance specific to empty\default to avoid confusion
deserializedJob.Appointment = null;
colJobs.Add(deserializedJob);
}
}
return colJobs;
}
public static DataTable GetTravelRelations(int[] jobIDs)
{
DataAccess objADO = new DataAccess();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selTravelRelations";
DataSet dsResults = null;
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", jobIDs);
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dsResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters);
objADO = null;
return dsResults.Tables[0];
}
public static List<AssignmentConstraints> FindAssignmentConstraints(string[] sourceIDs)
{
DataAccess objADO = new DataAccess();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selAssignmentContraintsFromSourceIDs";
DataSet dsResults = null;
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", sourceIDs);
colParameters.Add(new SqlParameter("@InstanceNumber", 0));
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dsResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters);
objADO = null;
return PopulateAssignmentConstraintsList(dsResults);
}
public static List<Location> GetGeoDataForJobs(string[] sourceIDs)
{
List<Location> colLocations = new List<Location>();
DataTable dtResults = null;
DataAccess objADO = new DataAccess();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selGeoDataForJobs";
objADO = Domain.GetADOInstance();
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", sourceIDs);
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, null).Tables[0];
objADO = null;
Location location = null;
foreach (DataRow locationRow in dtResults.Rows)
{
location = new Location();
location.ID = int.Parse(locationRow["WMSourceID"].ToString());
location.PostCode = locationRow["PostCode"].ToString();
if (!locationRow["Latitude"].Equals(DBNull.Value))
{
location.Latitude = double.Parse(locationRow["Latitude"].ToString());
}
if (!locationRow["Longitude"].Equals(DBNull.Value))
{
location.Longitude = double.Parse(locationRow["Longitude"].ToString());
}
if (!locationRow["Town"].Equals(DBNull.Value))
{
location.Town = locationRow["Town"].ToString();
}
if (!locationRow["Street"].Equals(DBNull.Value))
{
location.Street = locationRow["Street"].ToString();
}
if (!locationRow["HouseNo"].Equals(DBNull.Value))
{
int parseResult = 0;
if (int.TryParse(locationRow["HouseNo"].ToString(), out parseResult))
{
location.HouseNo = parseResult;
}
}
colLocations.Add(location);
}
return colLocations;
}
public static AssignmentDetailsCollection GetAssignmentsSupportingDataChanged(string userID, string sourceSystem, DateTime lastRunDate, out Hashtable SupportingDataChangeDates)
{
AssignmentDetailsCollection assignments = new AssignmentDetailsCollection();
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
DataSet dsResults = null;
int[] wmSourceIDs = null;
int[] candidateWMSourceIDs = null;
string strStoredProcedure = "selSupportingDataChanged";
SupportingDataChangeDates = new Hashtable();
//Get a list of all unacknowledged Assignment IDs from Mobile WIP
candidateWMSourceIDs = GetUnAcknowledgedSupportingDataAssignmentIDs(userID);
// Assemble Parameters
colParameters.Add(new SqlParameter("@UserID", userID));
colParameters.Add(new SqlParameter("@LastRunDate", lastRunDate));
if (sourceSystem != null)
{
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem));
}
if (candidateWMSourceIDs != null && candidateWMSourceIDs.Length > 0)
{
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", candidateWMSourceIDs);
dsResults = objADO.GetDataSet(strStoredProcedure, objParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
dsResults = objADO.GetDataSet(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
if (dsResults != null && dsResults.Tables.Count > 0 && dsResults.Tables[0].Rows.Count > 0)
{
wmSourceIDs = PopulateSupportingDataAssignmentIDs(dsResults.Tables[0], out SupportingDataChangeDates);
assignments = GetAssignments(userID, wmSourceIDs);
}
return assignments;
}
public static AssignmentDetailsCollection GetAssignments(int[] sourceIDs)
{
AssignmentDetailsCollection assignments = new AssignmentDetailsCollection();
DataSet dsResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
DataRow[] filteredRows = null;
string strStoredProcedure = "selAssignmentsByJobAndUser";
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", sourceIDs);
//colParameters.Add(new SqlParameter("@UserID", userID));
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dsResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters);
dsResults.Tables[0].TableName = "Assignments";
dsResults.Tables[1].TableName = "Assignees";
dsResults.Tables[2].TableName = "Appointments";
foreach (DataRow drAssignment in dsResults.Tables["Assignments"].Rows)
{
assignments.Add(new AssignmentDetails());
assignments[assignments.Count - 1].ID = int.Parse(drAssignment["WMSourceID"].ToString());
assignments[assignments.Count - 1].SourceSystem = (eWMSourceSystem)Enum.Parse(typeof(eWMSourceSystem), drAssignment["WMSourceSystem"].ToString());
if (!drAssignment["DueDate"].Equals(DBNull.Value))
{
assignments[assignments.Count - 1].DueDate = (DateTime)drAssignment["DueDate"];
}
assignments[assignments.Count - 1].Status = (eJobStatus)Enum.Parse(typeof(eJobStatus), drAssignment["JobStatus"].ToString());
filteredRows = dsResults.Tables["Assignees"].Select(string.Format("WMSourceID='{0}'", assignments[assignments.Count - 1].ID));
if (filteredRows.Length > 0)
{
int userIDJobInstanceNumber = 0;
assignments[assignments.Count - 1].Workers = new WorkerCollection();
for (int assigneeIndex = 0; assigneeIndex < filteredRows.Length; assigneeIndex++)
{
assignments[assignments.Count - 1].Workers.Add(new Worker());
assignments[assignments.Count - 1].Workers[assigneeIndex].LoginName = filteredRows[assigneeIndex]["UserID"].ToString();
if (!filteredRows[assigneeIndex]["EmpSurname"].Equals(DBNull.Value))
{
assignments[assignments.Count - 1].Workers[assigneeIndex].Surname = filteredRows[assigneeIndex]["EmpSurname"].ToString();
}
if (!filteredRows[assigneeIndex]["EmpForenames"].Equals(DBNull.Value))
{
assignments[assignments.Count - 1].Workers[assigneeIndex].Forenames = filteredRows[assigneeIndex]["EmpForenames"].ToString();
}
if (!filteredRows[assigneeIndex]["EmpNo"].Equals(DBNull.Value))
{
assignments[assignments.Count - 1].Workers[assigneeIndex].EmpNo = filteredRows[assigneeIndex]["EmpNo"].ToString();
}
//if (filteredRows[assigneeIndex]["UserID"].ToString().ToUpper() == userID.ToUpper())
//{
userIDJobInstanceNumber = int.Parse(filteredRows[assigneeIndex]["JobInstanceNumber"].ToString());
//}
}
assignments[assignments.Count - 1].InstanceNumber = userIDJobInstanceNumber;
}
filteredRows = dsResults.Tables["Appointments"].Select(string.Format("WMSourceID={0}", assignments[assignments.Count - 1].ID));
if (filteredRows.Length > 0)
{
foreach (DataRow drSerializedInstance in filteredRows)
{
if (!drSerializedInstance["Appointment"].Equals(DBNull.Value))
{
System.Xml.XmlDocument objDOM = new System.Xml.XmlDocument();
objDOM.LoadXml(drSerializedInstance["Appointment"].ToString()); //.Replace(" xmlns=\"http://FinalBuild.co.uk/BusinessObjects.WorkManagement\"", string.Empty));
assignments[assignments.Count - 1].Appointment = (Appointment)BusinessObjects.Base.Deserialize(typeof(Appointment), objDOM);
}
}
}
}
return assignments;
}
public static bool RemoveAssignees(int wmSourceID, eWMSourceSystem sourceSystem, string[] userList)
{
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "delJobAssignees";
int intRowsAffected = 0;
colParameters.Add(new SqlParameter("@WMSourceID", wmSourceID));
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem.ToString()));
if (userList != null)
{
DataAccess.ArrayListParameter objParameter = new DataAccess.ArrayListParameter("UserList", userList);
intRowsAffected = objADO.ExecuteSQL(strStoredProcedure, objParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
intRowsAffected = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
objADO = null;
return (intRowsAffected > 0);
}
public static int UpdatePostScheduling(int wmSourceID, eWMSourceSystem sourceSystem, DateTime dateScheduled, string[] assignedEngineers, DateTime assignmentStartDate,
int jobInstanceNumber, bool updateDateChangeDetected)
{
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "updJobPostClickScheduling";
int intRowsAffected = 0;
colParameters.Add(new SqlParameter("@WMSourceID", wmSourceID));
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem.ToString()));
colParameters.Add(new SqlParameter("@ClickDateScheduled", dateScheduled));
if (assignedEngineers != null && assignedEngineers.Length > 0)
{
objParameter = new DataAccess.ArrayListParameter("JobAssignees", assignedEngineers);
}
if (assignmentStartDate != null && assignmentStartDate != DateTime.MinValue)
{
colParameters.Add(new SqlParameter("@TargetStartDate", assignmentStartDate));
}
colParameters.Add(new SqlParameter("@JobInstanceNumber", jobInstanceNumber));
if (updateDateChangeDetected)
{
colParameters.Add(new SqlParameter("@UpdateDateChangeDetected", true));
}
//Updated : AP : ExecuteSQL method used below is dependent on having Engineers or not
if (objParameter != null)
{
intRowsAffected = objADO.ExecuteSQL(strStoredProcedure, objParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
else
{
intRowsAffected = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
}
objADO = null;
return intRowsAffected;
}
public static System.Collections.Generic.SortedList<int, eJobStatus> GetStatusesOfJobs(int[] jobIDs)
{
System.Collections.Generic.SortedList<int, eJobStatus> jobStatusesList = new System.Collections.Generic.SortedList<int, eJobStatus>();
DataTable dtResults = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
System.Data.SqlClient.SqlParameter[] arrParameters = null;
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selStatusesForWMSourceIDs";
objADO = Domain.GetADOInstance();
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", jobIDs);
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, arrParameters).Tables[0];
objADO = null;
if (dtResults.Rows.Count > 0)
{
foreach (DataRow drJobStatusInfo in dtResults.Rows)
{
jobStatusesList.Add(int.Parse(drJobStatusInfo["WMSourceID"].ToString()), (eJobStatus)Enum.Parse(typeof(eJobStatus),drJobStatusInfo["JobStatus"].ToString()));
}
}
return jobStatusesList;
}
public static Appointment GetAppointment(int jobID, int jobInstanceNumber)
{
Appointment deserializedAppointment = null;
System.Xml.XmlDocument objDOM = null;
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
DataAccess.ArrayListParameter objParameter = null;
string strStoredProcedure = "selAppointmentsMatchingCriteria";
// Assemble Parameters
objParameter = new DataAccess.ArrayListParameter("WMSourceIDs", new int[]{jobID});
colParameters.Add(new SqlParameter("@JobInstanceNumber", jobInstanceNumber));
dtResults = objADO.GetDataSet(strStoredProcedure, objParameter, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter))).Tables[0];
if (dtResults.Rows.Count > 0)
{
foreach (DataRow drSerializedAppointment in dtResults.Rows)
{
if (!drSerializedAppointment["Appointment"].Equals(DBNull.Value))
{
objDOM = new System.Xml.XmlDocument();
objDOM.LoadXml(drSerializedAppointment["Appointment"].ToString());
deserializedAppointment = (Appointment)BusinessObjects.Base.Deserialize(typeof(Appointment), objDOM);
}
break; // This routine only interested in first (current) Appointment value
}
}
return deserializedAppointment;
}
