/// <summary>
/// Description : Get WO Group History by WOID
/// Created By : SHIVA
/// Created Date : 22 Dec 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns>WO Group History by WOID</returns>
public static WOStatusAndAssignmentInfo GetWOGroupHistoryByWOID(int WOID)
{
var WOGroupHistory = new WOStatusAndAssignmentInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var lstWOGroupHistory = new List<WOStatusAndAssignment>();
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@WOID", WOID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetWOGroupHistoryByWOID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var getWOGroupHistory = new WOStatusAndAssignment();
getWOGroupHistory.FetchGroupHistory(getWOGroupHistory, safe);
lstWOGroupHistory.Add(getWOGroupHistory);
}
WOGroupHistory.WOStatusAndAssignmentInfoList = lstWOGroupHistory;
return WOGroupHistory;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WOGroupHistory;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
