//[002] code start /// <summary> /// Insert /// Calls [usp_insert_EPR] /// </summary> //public abstract Int32 Insert(System.Int32? clientNo, System.Int32? companyNo, System.Int32? contactNo, System.DateTime? dateOrdered, System.Int32? warehouseNo, System.Int32? currencyNo, System.Int32? buyer, System.Int32? shipViaNo, System.String account, System.Int32? termsNo, System.String expediteNotes, System.DateTime? expediteDate, System.Double? totalShipInCost, System.Int32? divisionNo, System.Int32? taxNo, System.String notes, System.String instructions, System.Boolean? paid, System.Boolean? confirmed, System.Int32? importCountryNo, System.String freeOnBoard, System.Int32? statusNo, System.Boolean? closed, System.Int32? incotermNo, System.Int32? updatedBy,System.String airwayBill); public abstract Int32 Insert(EPRDetails objEPR);
/// <summary> /// Update /// Calls [usp_Update_EPR] /// </summary> public abstract bool Update(EPRDetails objEPR);
/// <summary> /// Get /// Calls [usp_select_EPR] /// </summary> public static EPR Get(System.Int32?eprId) { Rebound.GlobalTrader.DAL.EPRDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.EPRProvider.Get(eprId); if (objDetails == null) { return(null); } else { EPR obj = new EPR(); obj.EPRId = objDetails.EPRId; obj.PurchaseOrderId = objDetails.PurchaseOrderId; obj.CompanyName = objDetails.CompanyName; obj.IsNew = objDetails.IsNew; obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.OrderValue = objDetails.OrderValue; obj.CurrencyCode = objDetails.CurrencyCode; obj.DeliveryDate = objDetails.DeliveryDate; obj.InAdvance = objDetails.InAdvance; obj.UponReceipt = objDetails.UponReceipt; obj.NetSpecify = objDetails.NetSpecify; obj.OtherSpecify = objDetails.OtherSpecify; obj.TT = objDetails.TT; obj.Cheque = objDetails.Cheque; obj.CreditCard = objDetails.CreditCard; obj.Comments = objDetails.Comments; obj.Name = objDetails.Name; obj.Address = objDetails.Address; obj.Tel = objDetails.Tel; obj.Fax = objDetails.Fax; obj.Email = objDetails.Email; obj.Name1 = objDetails.Name1; obj.Address1 = objDetails.Address1; obj.Tel1 = objDetails.Tel1; obj.Fax1 = objDetails.Fax1; obj.Email1 = objDetails.Email1; obj.Name2 = objDetails.Name2; obj.Address2 = objDetails.Address2; obj.Tel2 = objDetails.Tel2; obj.Fax2 = objDetails.Fax2; obj.Email2 = objDetails.Email2; obj.Comment = objDetails.Comment; obj.ProFormaAttached = objDetails.ProFormaAttached; obj.RaisedBy = objDetails.RaisedBy; obj.RaisedByDate = objDetails.RaisedByDate; obj.SORSigned = objDetails.SORSigned; obj.ForStock = objDetails.ForStock; obj.ValuesCorrect = objDetails.ValuesCorrect; obj.Authorized = objDetails.Authorized; obj.AuthorizedDate = objDetails.AuthorizedDate; obj.ERAIMember = objDetails.ERAIMember; obj.ERAIReported = objDetails.ERAIReported; obj.DebitNotes = objDetails.DebitNotes; obj.APOpenOrders = objDetails.APOpenOrders; obj.ACTotalValue = objDetails.ACTotalValue; obj.ACTotalValue1 = objDetails.ACTotalValue1; obj.SLComment = objDetails.SLComment; obj.SLTerms = objDetails.SLTerms; obj.SLOverdue = objDetails.SLOverdue; obj.SLTotalValue = objDetails.SLTotalValue; obj.PaymentAuthorizedBy = objDetails.PaymentAuthorizedBy; obj.Countersigned = objDetails.Countersigned; obj.PaymentAuthorizedDate = objDetails.PaymentAuthorizedDate; obj.SupplierCode = objDetails.SupplierCode; obj.IsRefAuthorise = string.IsNullOrEmpty(objDetails.Authorized) ? false : true; obj.IsCompleted = objDetails.EPRCompletedByNo.HasValue ? false : true; obj.EPRCompletedByName = objDetails.EPRCompletedByName; obj.EPRCompletedByNo = objDetails.EPRCompletedByNo; obj.RaisedByNo = objDetails.RaisedByNo; //[001] start obj.POLineSerialNo = objDetails.POLineSerialNo; //[001] end objDetails = null; return(obj); } }