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