/// <summary>
/// Description : Get UserID, Name from CSS1 for AssignedTo dropdown in WorkOrder.
/// Created By : Shiva
/// Created Date : 15 July 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static WOStatusAndAssignmentInfo GetCSS1UserDetailsForWOAssignment()
{
var WOAssignment = new WOStatusAndAssignmentInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var lstWOAssignment = new List<WOStatusAndAssignment>();
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetCSS1UserDetailsForAssignedTo");
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var getWOAssignment = new WOStatusAndAssignment();
getWOAssignment.FetchUsersForAssignedTo(getWOAssignment, safe);
lstWOAssignment.Add(getWOAssignment);
}
WOAssignment.WOStatusAndAssignmentInfoList = lstWOAssignment;
return WOAssignment;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WOAssignment;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
