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