/// <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); } }