/// <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);
}
}
/// <summary>
/// Description : GetMWOStatus from MWOStatus table
/// Created By : Shiva
/// Created Date : 18 July 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static WOStatusAndAssignmentInfo GetMWOStatus()
{
var data = new WOStatusAndAssignmentInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var getWorkOrderStatus = new List<WOStatusAndAssignment>();
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetMWOStatus");
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var WOStatus = new WOStatusAndAssignment();
WOStatus.FetchStatus(WOStatus, safe);
getWorkOrderStatus.Add(WOStatus);
}
data.WOStatusAndAssignmentInfoList = getWorkOrderStatus;
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
private WOStatusAndAssignment FetchUsersForAssignedTo(WOStatusAndAssignment Users, SafeDataReader dr)
{
Users.UserID = dr.GetInt32("UserID");
Users.UserName = dr.GetString("Name");
return Users;
}
private WOStatusAndAssignment FetchStatusHistory(WOStatusAndAssignment objStatus, SafeDataReader dr)
{
objStatus.WOCode = dr.GetString("WOCode");
objStatus.StatusCode = dr.GetString("StatusCode");
objStatus.Comment = dr.GetString("Comment");
objStatus.DateForHistory = dr.GetDateTime("StatusDate");
objStatus.StatusDate = objStatus.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
objStatus.StatusName = dr.GetString("Name");
objStatus.AssignedBy = dr.GetString("AssignedBy");
return objStatus;
}
private WOStatusAndAssignment FetchStatus(WOStatusAndAssignment objStatus, SafeDataReader dr)
{
objStatus.StatusCode = dr.GetString("Code");
objStatus.StatusName = dr.GetString("Name");
return objStatus;
}
private WOStatusAndAssignment FetchGroupHistory(WOStatusAndAssignment objAssignment, SafeDataReader dr)
{
objAssignment.WOCode = dr.GetString("WOCode");
objAssignment.GroupCode = dr.GetString("GroupCode");
objAssignment.AssignedBy = dr.GetString("CreatedBy");
objAssignment.DateForHistory = dr.GetDateTime("CreatedDate");
objAssignment.AssignedDate = objAssignment.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
return objAssignment;
}
/// <summary>
/// Description : Get WOStatus History by WOID
/// Created By : SHIVA
/// Created Date : 25 July 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns>WOStatus History by WOID</returns>
public static WOStatusAndAssignmentInfo GetWOStatusHistoryByWOID(int WOID)
{
var WOStatus = new WOStatusAndAssignmentInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var lstWOStatus = new List<WOStatusAndAssignment>();
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@WOID", WOID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetWOStatusHistoryByWOID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var getWOAssignment = new WOStatusAndAssignment();
getWOAssignment.FetchStatusHistory(getWOAssignment, safe);
lstWOStatus.Add(getWOAssignment);
}
WOStatus.WOStatusAndAssignmentInfoList = lstWOStatus;
return WOStatus;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WOStatus;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
