/// <summary> /// Description : To get MWOType by Category Code. /// Created By : Shiva /// Created Date : 15 July 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static WorkOrderInfo GetMWOTypeByCategoryCode(string CategoryCode) { var WOTypeByCategoryCodeData = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var lstWOType = new List<WorkOrders>(); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@CategoryCode", CategoryCode); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetMWOTypeByCategoryCode", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var GetMWOType = new WorkOrders(); GetMWOType.FetchWOTypeOrCategory(GetMWOType, safe); lstWOType.Add(GetMWOType); } WOTypeByCategoryCodeData.WorkOrdersList = lstWOType; return WOTypeByCategoryCodeData; } catch (Exception ex) { log.Error("Error: " + ex); return WOTypeByCategoryCodeData; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : Get Code and Name from MWOCategory from database for Category dropdown in WorkOrder. /// Created By : Shiva /// Created Date :15 July 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static WorkOrderInfo GetMWOCategory() { var categoryData = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var lstWorkOrder = new List<WorkOrders>(); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetMWOCategory"); var safe = new SafeDataReader(reader); while (reader.Read()) { var getCategory = new WorkOrders(); getCategory.FetchWOTypeOrCategory(getCategory, safe); lstWorkOrder.Add(getCategory); } categoryData.WorkOrdersList = lstWorkOrder; return categoryData; } catch (Exception ex) { log.Error("Error: " + ex); return categoryData; } finally { log.Debug("End: " + methodBase.Name); } }