Exemple #1
0
        /// <summary>
        /// ItemSearch
        /// Calls [usp_itemsearch_CustomerRMALine]
        /// </summary>
        public static List <CustomerRmaLine> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?salesman, System.String crmaNotesSearch, System.Int32?invoiceNoLo, System.Int32?invoiceNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.DateTime?customerRmaDateFrom, System.DateTime?customerRmaDateTo)
        {
            List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, partSearch, contactSearch, cmSearch, salesman, crmaNotesSearch, invoiceNoLo, invoiceNoHi, customerRmaNoLo, customerRmaNoHi, customerRmaDateFrom, customerRmaDateTo);

            if (lstDetails == null)
            {
                return(new List <CustomerRmaLine>());
            }
            else
            {
                List <CustomerRmaLine> lst = new List <CustomerRmaLine>();
                foreach (CustomerRmaLineDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine();
                    obj.CustomerRMAId     = objDetails.CustomerRMAId;
                    obj.CustomerRMALineId = objDetails.CustomerRMALineId;
                    obj.CustomerRMANumber = objDetails.CustomerRMANumber;
                    obj.CompanyNo         = objDetails.CompanyNo;
                    obj.CompanyName       = objDetails.CompanyName;
                    obj.Part            = objDetails.Part;
                    obj.ROHS            = objDetails.ROHS;
                    obj.CustomerRMADate = objDetails.CustomerRMADate;
                    obj.Quantity        = objDetails.Quantity;
                    obj.SalesmanName    = objDetails.SalesmanName;
                    obj.InvoiceNumber   = objDetails.InvoiceNumber;
                    obj.RowNum          = objDetails.RowNum;
                    obj.RowCnt          = objDetails.RowCnt;
                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }
Exemple #2
0
        private static CustomerRmaLine PopulateFromDBDetailsObject(CustomerRmaLineDetails obj)
        {
            CustomerRmaLine objNew = new CustomerRmaLine();

            objNew.CustomerRMALineId = obj.CustomerRMALineId;
            objNew.CustomerRMANo     = obj.CustomerRMANo;
            objNew.InvoiceLineNo     = obj.InvoiceLineNo;
            objNew.ReturnDate        = obj.ReturnDate;
            objNew.Reason            = obj.Reason;
            objNew.Quantity          = obj.Quantity;
            objNew.Notes             = obj.Notes;
            objNew.UpdatedBy         = obj.UpdatedBy;
            objNew.DLUP                    = obj.DLUP;
            objNew.CustomerRMAId           = obj.CustomerRMAId;
            objNew.CustomerRMANumber       = obj.CustomerRMANumber;
            objNew.CustomerRMADate         = obj.CustomerRMADate;
            objNew.CompanyName             = obj.CompanyName;
            objNew.CompanyNo               = obj.CompanyNo;
            objNew.InvoiceNumber           = obj.InvoiceNumber;
            objNew.InvoiceNo               = obj.InvoiceNo;
            objNew.ROHS                    = obj.ROHS;
            objNew.Part                    = obj.Part;
            objNew.ContactName             = obj.ContactName;
            objNew.ContactNo               = obj.ContactNo;
            objNew.ManufacturerNo          = obj.ManufacturerNo;
            objNew.ManufacturerCode        = obj.ManufacturerCode;
            objNew.RowNum                  = obj.RowNum;
            objNew.RowCnt                  = obj.RowCnt;
            objNew.QuantityReceived        = obj.QuantityReceived;
            objNew.SalesmanName            = obj.SalesmanName;
            objNew.ClientNo                = obj.ClientNo;
            objNew.InvoiceDate             = obj.InvoiceDate;
            objNew.CurrencyNo              = obj.CurrencyNo;
            objNew.Salesman                = obj.Salesman;
            objNew.DivisionNo              = obj.DivisionNo;
            objNew.TeamNo                  = obj.TeamNo;
            objNew.QuantityAllocated       = obj.QuantityAllocated;
            objNew.ProductNo               = obj.ProductNo;
            objNew.ProductName             = obj.ProductName;
            objNew.ProductDescription      = obj.ProductDescription;
            objNew.ProductDutyCode         = obj.ProductDutyCode;
            objNew.FullPart                = obj.FullPart;
            objNew.CustomerPart            = obj.CustomerPart;
            objNew.ManufacturerName        = obj.ManufacturerName;
            objNew.PackageNo               = obj.PackageNo;
            objNew.DateCode                = obj.DateCode;
            objNew.PackageName             = obj.PackageName;
            objNew.PackageDescription      = obj.PackageDescription;
            objNew.Price                   = obj.Price;
            objNew.LandedCost              = obj.LandedCost;
            objNew.LineNotes               = obj.LineNotes;
            objNew.InvoiceLineAllocationId = obj.InvoiceLineAllocationId;
            return(objNew);
        }
Exemple #3
0
        /// <summary>
        /// GetQtyForCustomerRMA
        /// Calls [usp_GetQty_CustomerRMALine_for_CustomerRMA]
        /// </summary>
        public static CustomerRmaLine GetQtyForCustomerRMA(System.Int32?customerRMALineId, System.Int32?invoiceLineID)
        {
            CustomerRmaLineDetails lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetQtyForCustomerRMA(customerRMALineId, invoiceLineID);

            if (lstDetails == null)
            {
                return(new CustomerRmaLine());
            }
            else
            {
                Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine();
                obj.QuantityAvailable = lstDetails.QuantityAvailable;
                obj.QuantityShipped   = lstDetails.QuantityShipped;
                obj.QuantityReceived  = lstDetails.QuantityReceived;
                obj.QuantityCRMA      = lstDetails.QuantityCRMA;
                obj.InvoiceLineNo     = lstDetails.InvoiceLineNo;
                return(obj);
            }
        }
Exemple #4
0
        /// <summary>
        /// DataListNuggetReadyToReceive
        /// Calls [usp_datalistnugget_CustomerRMALine_ReadyToReceive]
        /// </summary>
        public static List <CustomerRmaLine> DataListNuggetReadyToReceive(System.Int32?clientId, System.Int32?pageIndex, System.Int32?pageSize, System.Int32?orderBy, System.Int32?sortDir, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?salesmanSearch, System.String crmaNotesSearch, System.Int32?invoiceNoLo, System.Int32?invoiceNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.DateTime?customerRmaDateFrom, System.DateTime?customerRmaDateTo, System.Int32?clientSearch, Boolean IsGlobalLogin)
        {
            List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.DataListNuggetReadyToReceive(clientId, pageIndex, pageSize, orderBy, sortDir, partSearch, contactSearch, cmSearch, salesmanSearch, crmaNotesSearch, invoiceNoLo, invoiceNoHi, customerRmaNoLo, customerRmaNoHi, customerRmaDateFrom, customerRmaDateTo, clientSearch, IsGlobalLogin);

            if (lstDetails == null)
            {
                return(new List <CustomerRmaLine>());
            }
            else
            {
                List <CustomerRmaLine> lst = new List <CustomerRmaLine>();
                foreach (CustomerRmaLineDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine();
                    obj.CustomerRMAId     = objDetails.CustomerRMAId;
                    obj.CustomerRMANumber = objDetails.CustomerRMANumber;
                    obj.CustomerRMADate   = objDetails.CustomerRMADate;
                    obj.CompanyName       = objDetails.CompanyName;
                    obj.CompanyNo         = objDetails.CompanyNo;
                    obj.InvoiceNumber     = objDetails.InvoiceNumber;
                    obj.InvoiceNo         = objDetails.InvoiceNo;
                    obj.Quantity          = objDetails.Quantity;
                    obj.QuantityReceived  = objDetails.QuantityReceived;
                    obj.ROHS             = objDetails.ROHS;
                    obj.Part             = objDetails.Part;
                    obj.ContactName      = objDetails.ContactName;
                    obj.ContactNo        = objDetails.ContactNo;
                    obj.ManufacturerNo   = objDetails.ManufacturerNo;
                    obj.ManufacturerCode = objDetails.ManufacturerCode;
                    obj.RowNum           = objDetails.RowNum;
                    obj.RowCnt           = objDetails.RowCnt;
                    obj.ClientNo         = objDetails.ClientNo;
                    obj.ClientName       = objDetails.ClientName;
                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }
Exemple #5
0
        // [001] code end
        /// <summary>
        /// GetListForReceiving
        /// Calls [usp_selectAll_CustomerRMALine_for_Receiving]
        /// </summary>
        public static List <CustomerRmaLine> GetListForReceiving(System.Int32?customerRmaNo)
        {
            List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetListForReceiving(customerRmaNo);

            if (lstDetails == null)
            {
                return(new List <CustomerRmaLine>());
            }
            else
            {
                List <CustomerRmaLine> lst = new List <CustomerRmaLine>();
                foreach (CustomerRmaLineDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine();
                    obj.CustomerRMAId      = objDetails.CustomerRMAId;
                    obj.CustomerRMANumber  = objDetails.CustomerRMANumber;
                    obj.CustomerRMALineId  = objDetails.CustomerRMALineId;
                    obj.CustomerRMADate    = objDetails.CustomerRMADate;
                    obj.ReturnDate         = objDetails.ReturnDate;
                    obj.ClientNo           = objDetails.ClientNo;
                    obj.Notes              = objDetails.Notes;
                    obj.Reason             = objDetails.Reason;
                    obj.InvoiceNumber      = objDetails.InvoiceNumber;
                    obj.InvoiceDate        = objDetails.InvoiceDate;
                    obj.InvoiceNo          = objDetails.InvoiceNo;
                    obj.InvoiceLineNo      = objDetails.InvoiceLineNo;
                    obj.CurrencyNo         = objDetails.CurrencyNo;
                    obj.Salesman           = objDetails.Salesman;
                    obj.SalesmanName       = objDetails.SalesmanName;
                    obj.DivisionNo         = objDetails.DivisionNo;
                    obj.TeamNo             = objDetails.TeamNo;
                    obj.CompanyNo          = objDetails.CompanyNo;
                    obj.CompanyName        = objDetails.CompanyName;
                    obj.ContactNo          = objDetails.ContactNo;
                    obj.ContactName        = objDetails.ContactName;
                    obj.Quantity           = objDetails.Quantity;
                    obj.QuantityReceived   = objDetails.QuantityReceived;
                    obj.QuantityAllocated  = objDetails.QuantityAllocated;
                    obj.ProductNo          = objDetails.ProductNo;
                    obj.ProductName        = objDetails.ProductName;
                    obj.ProductDescription = objDetails.ProductDescription;
                    obj.ProductDutyCode    = objDetails.ProductDutyCode;
                    obj.FullPart           = objDetails.FullPart;
                    obj.Part                    = objDetails.Part;
                    obj.CustomerPart            = objDetails.CustomerPart;
                    obj.ROHS                    = objDetails.ROHS;
                    obj.ManufacturerNo          = objDetails.ManufacturerNo;
                    obj.ManufacturerName        = objDetails.ManufacturerName;
                    obj.ManufacturerCode        = objDetails.ManufacturerCode;
                    obj.PackageNo               = objDetails.PackageNo;
                    obj.DateCode                = objDetails.DateCode;
                    obj.PackageName             = objDetails.PackageName;
                    obj.PackageDescription      = objDetails.PackageDescription;
                    obj.Price                   = objDetails.Price;
                    obj.LandedCost              = objDetails.LandedCost;
                    obj.LineNotes               = objDetails.LineNotes;
                    obj.InvoiceLineAllocationId = objDetails.InvoiceLineAllocationId;
                    obj.QuantityAllocated       = objDetails.QuantityAllocated;
                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }
Exemple #6
0
 /// <summary>
 /// GetForReceiving
 /// Calls [usp_select_CustomerRMALine_for_Receiving]
 /// </summary>
 public static CustomerRmaLine GetForReceiving(System.Int32?customerRmaLineNo)
 {
     Rebound.GlobalTrader.DAL.CustomerRmaLineDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetForReceiving(customerRmaLineNo);
     if (objDetails == null)
     {
         return(null);
     }
     else
     {
         CustomerRmaLine obj = new CustomerRmaLine();
         obj.CustomerRMAId      = objDetails.CustomerRMAId;
         obj.CustomerRMANumber  = objDetails.CustomerRMANumber;
         obj.CustomerRMALineId  = objDetails.CustomerRMALineId;
         obj.CustomerRMADate    = objDetails.CustomerRMADate;
         obj.ReturnDate         = objDetails.ReturnDate;
         obj.ClientNo           = objDetails.ClientNo;
         obj.Notes              = objDetails.Notes;
         obj.Reason             = objDetails.Reason;
         obj.InvoiceNumber      = objDetails.InvoiceNumber;
         obj.InvoiceDate        = objDetails.InvoiceDate;
         obj.InvoiceNo          = objDetails.InvoiceNo;
         obj.InvoiceLineNo      = objDetails.InvoiceLineNo;
         obj.CurrencyNo         = objDetails.CurrencyNo;
         obj.Salesman           = objDetails.Salesman;
         obj.SalesmanName       = objDetails.SalesmanName;
         obj.DivisionNo         = objDetails.DivisionNo;
         obj.TeamNo             = objDetails.TeamNo;
         obj.CompanyNo          = objDetails.CompanyNo;
         obj.CompanyName        = objDetails.CompanyName;
         obj.ContactNo          = objDetails.ContactNo;
         obj.ContactName        = objDetails.ContactName;
         obj.Quantity           = objDetails.Quantity;
         obj.QuantityReceived   = objDetails.QuantityReceived;
         obj.QuantityAllocated  = objDetails.QuantityAllocated;
         obj.ProductNo          = objDetails.ProductNo;
         obj.ProductName        = objDetails.ProductName;
         obj.ProductDescription = objDetails.ProductDescription;
         obj.ProductDutyCode    = objDetails.ProductDutyCode;
         obj.FullPart           = objDetails.FullPart;
         obj.Part                    = objDetails.Part;
         obj.CustomerPart            = objDetails.CustomerPart;
         obj.ROHS                    = objDetails.ROHS;
         obj.ManufacturerNo          = objDetails.ManufacturerNo;
         obj.ManufacturerName        = objDetails.ManufacturerName;
         obj.ManufacturerCode        = objDetails.ManufacturerCode;
         obj.PackageNo               = objDetails.PackageNo;
         obj.DateCode                = objDetails.DateCode;
         obj.PackageName             = objDetails.PackageName;
         obj.PackageDescription      = objDetails.PackageDescription;
         obj.Price                   = objDetails.Price;
         obj.LandedCost              = objDetails.LandedCost;
         obj.LineNotes               = objDetails.LineNotes;
         obj.InvoiceLineAllocationId = objDetails.InvoiceLineAllocationId;
         obj.QuantityAllocated       = objDetails.QuantityAllocated;
         obj.Reason1                 = objDetails.Reason1;
         obj.Reason2                 = objDetails.Reason2;
         obj.Reason1Val              = objDetails.Reason1Val;
         obj.Reason2Val              = objDetails.Reason2Val;
         obj.RootCause               = objDetails.RootCause;
         objDetails                  = null;
         return(obj);
     }
 }