/// <summary> /// Description : Get Disbursement details by ID /// Created By : Shiva /// Created Date : 6 June 2014 /// Modified By : /// Modified Date: /// </summary> /// <param name="ID"></param> /// <returns></returns> public static WorkOrdersAndDItemsInfo GetDisbursementItemsByID(int ID, string VenderRefID) { var data = new WorkOrdersAndDItemsInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@ID", ID); sqlParams[1] = new SqlParameter("@VenderRefID", VenderRefID); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetDisbursementDataByID", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var SearchDisbursementItem = new DisbursementItem(); SearchDisbursementItem.FetchDisbursementItemsByID(SearchDisbursementItem, safe); data.OrdersList.Add(SearchDisbursementItem); } safe.NextResult(); while (reader.Read()) { data.VendorAmount = Convert.ToDecimal(reader["Amount"]); data.VendorReport = Convert.ToString(reader["VRID"]); } safe.NextResult(); while (reader.Read()) { data.OrdersCount = Convert.ToInt32(reader["RelatedDICount"]); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }