예제 #1
0
 public DIFeeInvoicePreview FetchInvoicePreviewAddess(DIFeeInvoicePreview getDIInvoicePreviewAddress, SafeDataReader dr)
 {
     getDIInvoicePreviewAddress.Name = dr.GetString("Name");
     getDIInvoicePreviewAddress.AddressLine1 = dr.GetString("AddressLine1");
     getDIInvoicePreviewAddress.AddressLine2 = dr.GetString("AddressLine2");
     getDIInvoicePreviewAddress.AddressLine3 = dr.GetString("AddressLine3");
     return getDIInvoicePreviewAddress;
 }
예제 #2
0
        /// <summary>
        /// Description  : Get FeeItems Invoice preview by ID  
        /// Created By   : SHIVA
        /// Created Date : 4 Feb 2015
        /// Modified By  : 
        /// Modified Date: 
        /// </summary>
        /// <param name="ID">Get FeeItems Invoice preview details based on FeeID's</param>
        /// <returns></returns>
        public static WorkOrdersAndDItemsInfo GetInvoicePreviewDataByFeeID(string FeeIDs)
        {
            System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
            System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
            log.Debug("Start: " + methodBase.Name);
            var WorkOrdersAndDItemsInfo = new WorkOrdersAndDItemsInfo();
            try
            {
                SqlParameter[] sqlParams = new SqlParameter[1];
                sqlParams[0] = new SqlParameter("@FeeIDs", FeeIDs);

                var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SPInvoicePreviewDataByFee]", sqlParams);
                var safe = new SafeDataReader(reader);
                while (reader.Read())
                {
                    var InvoicePreview = new DIFeeInvoicePreview();
                    InvoicePreview.FetchInvoicePreview(InvoicePreview, safe);
                    WorkOrdersAndDItemsInfo.DiInvoicePreview.Add(InvoicePreview);
                }
                return WorkOrdersAndDItemsInfo;
            }
            catch (Exception ex)
            {
                log.Error("Error: " + ex);
                return WorkOrdersAndDItemsInfo;
            }
            finally
            {
                log.Debug("End: " + methodBase.Name);
            }
        }
예제 #3
0
 public DIFeeInvoicePreview FetchInvoicePreview(DIFeeInvoicePreview getDIInvoicePreview, SafeDataReader dr)
 {
     getDIInvoicePreview.Amount = dr.GetDecimal("Amount");
     getDIInvoicePreview.ACCPACCode = dr.GetString("ItemNumber");
     getDIInvoicePreview.Description = dr.GetString("Description");
     return getDIInvoicePreview;
 }