void simconnect_OnTextEvent(SimConnect sender, SIMCONNECT_RECV_EVENT_TEXT data)
{
System.String s = "";
for (uint i = 0; i < data.dwUnitSize; ++i)
{
System.Byte?b = (data.rgMessage[i] as System.Byte?);
if (b != null)
{
System.Char?c = Convert.ToChar(b);
if (c != null)
{
if (c == '\0')
{
s += '\n';
}
else
{
s += c;
}
}
}
}
if (!String.IsNullOrWhiteSpace(s))
{
displayText(s);
}
}
public System.UInt32 SetDefaultTTL(System.Byte?inDefaultTTL)
{
var parameters = new CimMethodParametersCollection();
if (inDefaultTTL.HasValue)
{
parameters.Add(CimMethodParameter.Create("DefaultTTL", inDefaultTTL.Value, CimFlags.None));
}
var result = InfrastuctureObjectScope.CimSession.InvokeMethod(InnerCimInstance, "SetDefaultTTL", parameters);
return((System.UInt32)result.ReturnValue.Value);
}
public System.UInt32 UserControlService(System.Byte?inControlCode)
{
var parameters = new CimMethodParametersCollection();
if (inControlCode.HasValue)
{
parameters.Add(CimMethodParameter.Create("ControlCode", inControlCode.Value, CimFlags.None));
}
var result = InfrastuctureObjectScope.CimSession.InvokeMethod(InnerCimInstance, "UserControlService", parameters);
return((System.UInt32)result.ReturnValue.Value);
}
/// <summary>
/// Sets properties and attributes of class in accordance with Binary definition.
/// </summary>
/// <param name="Definition">Binary definition</param>
public override Task FromXml(XmlElement Definition)
{
if (System.Byte.TryParse(Definition.InnerText, out System.Byte Value))
{
this.value = Value;
this.script = null;
}
else
{
this.value = null;
this.script = new Expression(Definition.InnerText);
}
return(Task.CompletedTask);
}
public System.UInt32 AddFibreChannelChap(System.String[] inFcPortSettings, System.Byte?inSecretEncoding, System.Byte[] inSharedSecret)
{
var parameters = new CimMethodParametersCollection();
if (inFcPortSettings != null)
{
parameters.Add(CimMethodParameter.Create("FcPortSettings", inFcPortSettings, CimType.StringArray, inFcPortSettings == null ? CimFlags.NullValue : CimFlags.None));
}
if (inSecretEncoding.HasValue)
{
parameters.Add(CimMethodParameter.Create("SecretEncoding", inSecretEncoding.Value, CimFlags.None));
}
if (inSharedSecret != null)
{
parameters.Add(CimMethodParameter.Create("SharedSecret", inSharedSecret, CimType.UInt8Array, inSharedSecret == null ? CimFlags.NullValue : CimFlags.None));
}
var result = InfrastuctureObjectScope.CimSession.InvokeMethod(InnerCimInstance, "AddFibreChannelChap", parameters);
return((System.UInt32)result.ReturnValue.Value);
}
public static System.Byte?ToByteNullable(object x, bool useDefaultForNull = false, System.Byte @default = default(System.Byte))
{
System.Byte?result = null;
try
{
var s = x as string;
if (!(DBNull.Value.Equals(x) || x == null || (s != null && string.IsNullOrWhiteSpace(s))))
{
result = System.Convert.ToByte(x);
}
}
catch
{ }
if (result == null && useDefaultForNull)
{
result = @default;
}
return(result);
}
/// <summary>
/// Insert
/// Calls [usp_insert_History]
/// </summary>
public static Int32 Insert(System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.DateTime?originalEntryDate, System.Int32?salesman, System.Int32?offerStatusNo, System.DateTime?offerStatusChangeDate, System.Int32?offerStatusChangeLoginNo, System.Int32?supplierNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy)
{
Int32 objReturn = Rebound.GlobalTrader.DAL.SiteProvider.History.Insert(part, manufacturerNo, dateCode, productNo, packageNo, quantity, price, currencyNo, originalEntryDate, salesman, offerStatusNo, offerStatusChangeDate, offerStatusChangeLoginNo, supplierNo, rohs, notes, updatedBy);
return(objReturn);
}
/// <summary>
/// Update Offer
/// Calls [usp_update_Offer]
/// </summary>
public override bool Update(System.Int32?offerId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.Int32?salesman, System.Int32?offerStatusNo, System.Int32?supplierNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, bool?isPoHub)
{
SqlConnection cn = null;
SqlCommand cmd = null;
string proc = "usp_update_Offer";
try {
proc = isPoHub == true ? "usp_update_OfferPH" : proc;
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand(proc, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OfferId", SqlDbType.Int).Value = offerId;
cmd.Parameters.Add("@Part", SqlDbType.NVarChar).Value = part;
cmd.Parameters.Add("@ManufacturerNo", SqlDbType.Int).Value = manufacturerNo;
cmd.Parameters.Add("@DateCode", SqlDbType.NVarChar).Value = dateCode;
cmd.Parameters.Add("@ProductNo", SqlDbType.Int).Value = productNo;
cmd.Parameters.Add("@PackageNo", SqlDbType.Int).Value = packageNo;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = quantity;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = price;
cmd.Parameters.Add("@CurrencyNo", SqlDbType.Int).Value = currencyNo;
cmd.Parameters.Add("@Salesman", SqlDbType.Int).Value = salesman;
cmd.Parameters.Add("@OfferStatusNo", SqlDbType.Int).Value = offerStatusNo;
cmd.Parameters.Add("@SupplierNo", SqlDbType.Int).Value = supplierNo;
cmd.Parameters.Add("@ROHS", SqlDbType.TinyInt).Value = rohs;
cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy;
////cmd.Parameters.Add("@SupplierTotalQSA", SqlDbType.NVarChar).Value = supplierTotalQSA;
////cmd.Parameters.Add("@SupplierLTB", SqlDbType.NVarChar).Value = supplierLTB;
////cmd.Parameters.Add("@SupplierMOQ", SqlDbType.NVarChar).Value = supplierMOQ;
////cmd.Parameters.Add("@MSL", SqlDbType.NVarChar).Value = MSL;
////cmd.Parameters.Add("@SPQ", SqlDbType.NVarChar).Value = SPQ;
////cmd.Parameters.Add("@LeadTime", SqlDbType.NVarChar).Value = leadTime;
////cmd.Parameters.Add("@FactorySealed", SqlDbType.NVarChar).Value = factorySealed;
////cmd.Parameters.Add("@ROHSStatus", SqlDbType.NVarChar).Value = rohsStatus;
cmd.Parameters.Add("@RowsAffected", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return(ret > 0);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to update Offer", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Create a new row
/// Calls [usp_insert_OfferNew]
/// </summary>
public override Int32 IPOBOMInsert(System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.DateTime?originalEntryDate, System.Int32?salesman, System.Int32?supplierNo, System.String supplierName, System.Byte?rohs, System.Int32?offerStatusNo, System.String notes, System.Int32?updatedBy, System.Int32?cleintNo, bool?isPoHub, System.String supplierTotalQSA, System.String supplierMOQ, System.String supplierLTB, System.String msl, System.String spq, System.String leadTime, System.String factorySealed, System.String rohsStatus, System.Int32?mslLevelNo)
{
SqlConnection cn = null;
SqlCommand cmd = null;
string proc = "usp_insert_IPOOffer";
try
{
//proc = isPoHub == true ? "usp_ipobom_insert_OfferNewPH" : proc;
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand(proc, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Part", SqlDbType.NVarChar).Value = part;
cmd.Parameters.Add("@ManufacturerNo", SqlDbType.Int).Value = manufacturerNo;
cmd.Parameters.Add("@DateCode", SqlDbType.NVarChar).Value = dateCode;
cmd.Parameters.Add("@ProductNo", SqlDbType.Int).Value = productNo;
cmd.Parameters.Add("@PackageNo", SqlDbType.Int).Value = packageNo;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = quantity;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = price;
cmd.Parameters.Add("@CurrencyNo", SqlDbType.Int).Value = currencyNo;
cmd.Parameters.Add("@OriginalEntryDate", SqlDbType.DateTime).Value = originalEntryDate;
cmd.Parameters.Add("@Salesman", SqlDbType.Int).Value = salesman;
cmd.Parameters.Add("@SupplierNo", SqlDbType.Int).Value = supplierNo;
cmd.Parameters.Add("@SupplierName", SqlDbType.NVarChar).Value = supplierName;
cmd.Parameters.Add("@ROHS", SqlDbType.TinyInt).Value = rohs;
cmd.Parameters.Add("@OfferStatusNo", SqlDbType.Int).Value = offerStatusNo;
cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy;
cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = cleintNo;
cmd.Parameters.Add("@SupplierTotalQSA", SqlDbType.NVarChar).Value = supplierTotalQSA;
cmd.Parameters.Add("@SupplierLTB", SqlDbType.NVarChar).Value = supplierLTB;
cmd.Parameters.Add("@SupplierMOQ", SqlDbType.NVarChar).Value = supplierMOQ;
cmd.Parameters.Add("@MSL", SqlDbType.NVarChar).Value = msl;
cmd.Parameters.Add("@SPQ", SqlDbType.NVarChar).Value = spq;
cmd.Parameters.Add("@LeadTime", SqlDbType.NVarChar).Value = leadTime;
cmd.Parameters.Add("@FactorySealed", SqlDbType.NVarChar).Value = factorySealed;
cmd.Parameters.Add("@ROHSStatus", SqlDbType.NVarChar).Value = rohsStatus;
cmd.Parameters.Add("@IsPoHUB", SqlDbType.Bit).Value = isPoHub;
cmd.Parameters.Add("@MSLLevelNo", SqlDbType.Int).Value = mslLevelNo;
cmd.Parameters.Add("@OfferId", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return((Int32)cmd.Parameters["@OfferId"].Value);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to insert Offer", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Create a new row
/// Calls [usp_insert_CreditLine]
/// </summary>
public override Int32 Insert(System.Int32?creditNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?productNo, System.Int32?quantity, System.Double?price, System.Boolean?taxable, System.String customerPart, System.Double?landedCost, System.Int32?invoiceLineNo, System.Int32?customerRmaLineNo, System.Int32?stockNo, System.Int32?serviceNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Int32?ClientInvoiceLineId, out int creditId, out int creditNumber)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_insert_CreditLine", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CreditNo", SqlDbType.Int).Value = creditNo;
cmd.Parameters.Add("@Part", SqlDbType.NVarChar).Value = part;
cmd.Parameters.Add("@ManufacturerNo", SqlDbType.Int).Value = manufacturerNo;
cmd.Parameters.Add("@DateCode", SqlDbType.NVarChar).Value = dateCode;
cmd.Parameters.Add("@PackageNo", SqlDbType.Int).Value = packageNo;
cmd.Parameters.Add("@ProductNo", SqlDbType.Int).Value = productNo;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = quantity;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = price;
cmd.Parameters.Add("@Taxable", SqlDbType.Bit).Value = taxable;
cmd.Parameters.Add("@CustomerPart", SqlDbType.NVarChar).Value = customerPart;
cmd.Parameters.Add("@LandedCost", SqlDbType.Float).Value = landedCost;
cmd.Parameters.Add("@InvoiceLineNo", SqlDbType.Int).Value = invoiceLineNo;
cmd.Parameters.Add("@CustomerRMALineNo", SqlDbType.Int).Value = customerRmaLineNo;
cmd.Parameters.Add("@StockNo", SqlDbType.Int).Value = stockNo;
cmd.Parameters.Add("@ServiceNo", SqlDbType.Int).Value = serviceNo;
cmd.Parameters.Add("@ROHS", SqlDbType.TinyInt).Value = rohs;
cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = notes;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy;
cmd.Parameters.Add("@ClientInvoiceLineId", SqlDbType.Int).Value = ClientInvoiceLineId;
cmd.Parameters.Add("@CreditLineId", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CreditId", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CreditNumber", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
creditId = (Int32)(cmd.Parameters["@CreditId"].Value == null ? 0 : cmd.Parameters["@CreditId"].Value);
creditNumber = (Int32)(cmd.Parameters["@CreditNumber"].Value == null ? 0 : cmd.Parameters["@CreditNumber"].Value);
return((Int32)cmd.Parameters["@CreditLineId"].Value);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to insert CreditLine", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary> /// InsertForService /// Calls [usp_insert_InvoiceLine_for_Service] /// </summary> public abstract Int32 InsertForService(System.Int32?invoiceNo, System.Int32?salesOrderLineNo, System.Int32?shippedBy, System.DateTime?shippedDate, System.String notes, System.Int32?updatedBy, System.String fullPart, System.String part, System.String dateCode, System.Byte?rohs, System.Int32?manufacturerNo, System.Int32?packageNo, System.Int32?productNo, System.String taxable, System.Int32?quantity, System.Double?cost, System.Double?price, System.DateTime?datePromised, System.DateTime?requiredDate, System.Int32?salesOrderNo, System.Int32?serviceNo, System.Int32?stockNo, System.String instructions, System.String customerPart, System.Boolean?printHazardous);
/// <summary>
/// InsertAsAlternate
/// Calls [usp_insert_CustomerRequirement_as_Alternate]
/// </summary>
public abstract Int32 InsertAsAlternate(System.String customerRequirementName, System.Int32?customerRequirementNumber, System.Int32?clientNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.DateTime?receivedDate, System.Int32?salesman, System.DateTime?datePromised, System.String notes, System.String instructions, System.Boolean?shortage, System.Int32?companyNo, System.Int32?contactNo, System.Int32?usageNo, System.Int32?originalCustomerRequirementNo, System.Int32?reasonNo, System.Int32?productNo, System.String customerPart, System.Boolean?closed, System.Byte?rohs, System.Int32?updatedBy, System.Boolean?partWatch, System.Boolean?bom, System.String bomName,
System.Int32?salesmanno, System.Boolean?PQA, System.Boolean?ObsoleteChk, System.Boolean?LastTimeBuyChk, System.Boolean?RefirbsAcceptableChk, System.Boolean?TestingRequiredChk, System.Boolean?AlternativesAccepted, System.Boolean?RepeatBusiness, System.Double?CompetitorBestOffer, System.DateTime?CustomerDecisionDate, System.DateTime?RFQClosingDate, System.Int32?QuoteValidityRequired, System.Int32?Type, System.Boolean?OrderToPlace, System.Boolean?FactorySealed, System.String MSL, System.Int32?BOMNo, System.Int32?RequirementforTraceability, System.String EAU);
/// <summary> /// Insert /// Calls [usp_insert_GoodsInLine] /// </summary> public abstract Int32 Insert(System.Int32?goodsInNo, System.Int32?purchaseOrderLineNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Double?shipInCost, System.String qualityControlNotes, System.String location, System.Int32?lotNo, System.Int32?productNo, System.Int32?currencyNo, System.Int32?customerRmaLineNo, System.String supplierPart, System.Byte?rohs, System.Int32?countryOfManufacture, System.Boolean?unavailable, System.String notes, System.String changedFields, System.Int32?countingMethodNo, System.Boolean?serialNosRecorded, System.String partMarkings, System.Int32?updatedBy, System.Double?clientPrice, System.Boolean?reqSerialNo);
//[002] code start /// <summary> /// Update /// Calls [usp_update_SalesOrderLine] /// </summary> public abstract bool Update(System.Int32?salesOrderLineId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.DateTime?datePromised, System.DateTime?requiredDate, System.String instructions, System.Int32?productNo, System.String taxable, System.String customerPart, System.Boolean?shipAsap, System.Boolean?inactive, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Byte?productSource, System.DateTime?poDeliveryDate, System.Int16?serialNo, System.String mslLevel, System.String ContractNo, System.Boolean?printHazardous, bool?isFormChanged);
//[001],[002] code start /// <summary> /// Insert /// Calls [usp_insert_SalesOrderLine] /// </summary> public abstract Int32 Insert(System.Int32?salesOrderNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.DateTime?datePromised, System.DateTime?requiredDate, System.String instructions, System.Int32?productNo, System.String taxable, System.String customerPart, System.Boolean?posted, System.Boolean?shipAsap, System.Int32?serviceNo, System.Int32?stockNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Int32?QuoteLineNo, System.Byte?productSource, int?sourcingResultNo, System.DateTime?poDeliveryDate, System.String mslLevel, System.String ContractNo, System.Boolean?printHazardous);
/// <summary> /// InsertIdentityOff /// Calls [usp_insert_Stock_Identity_Off] /// </summary> public abstract Int32 InsertIdentityOff(System.Int32?stockId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?warehouseNo, System.Int32?clientNo, System.String qualityControlNotes, System.Int32?purchaseOrderNo, System.Int32?purchaseOrderLineNo, System.Int32?customerRmaNo, System.Int32?customerRmaLineNo, System.Int32?goodsInLineNo, System.Int32?quantityInStock, System.Int32?quantityOnOrder, System.Int32?productNo, System.Double?resalePrice, System.Boolean?unavailable, System.Int32?lotNo, System.Double?landedCost, System.String supplierPart, System.Byte?rohs, System.Int32?packageUnit, System.Int32?stockKeepingUnit, System.String stockLogChangeNotes, System.String location, System.Int32?updatedBy);
/// <summary> /// /// Calls [usp_Import_Excess] /// </summary> /// <summary> /// Insert /// Calls [usp_insert_ExcessNew] /// </summary> public abstract Int32 Insert(System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.DateTime?originalEntryDate, System.Int32?salesman, System.Int32?companyNo, System.String companyName, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Int32?clientNo, System.Int32?offerStatusNo, bool?isPoHub);
//[003] code start /// <summary> /// Update /// Calls [usp_update_Stock] /// </summary> public abstract bool Update(System.Int32?stockId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?warehouseNo, System.Int32?clientNo, System.String qualityControlNotes, System.Int32?purchaseOrderNo, System.Int32?purchaseOrderLineNo, System.Int32?customerRmaNo, System.Int32?customerRmaLineNo, System.Int32?quantityInStock, System.Int32?quantityOnOrder, System.Int32?productNo, System.Double?resalePrice, System.Boolean?unavailable, System.Int32?lotNo, System.Double?landedCost, System.String supplierPart, System.Byte?rohs, System.Int32?packageUnit, System.Int32?stockKeepingUnit, System.Int32?updatedBy, System.String stockLogDetail, System.String stockLogChangeNotes, System.Int32?stockLogReasonNo, System.String location, System.Int32?countryOfManufacture, System.Boolean?updateShipments, System.String partMarkings, System.Int32?countingMethodNo, System.Int32?divisionNo, System.Boolean?isClientUpdate, System.String mslLevel);
/// <summary> /// Insert /// Calls [usp_insert_PurchaseOrderLine] /// </summary> public abstract Int32 Insert(System.Int32?purchaseOrderNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.DateTime?deliveryDate, System.String receivingNotes, System.Boolean?taxable, System.Int32?productNo, System.Boolean?posted, System.Double?shipInCost, System.String supplierPart, System.Byte?rohs, System.String notes, System.DateTime?PromiseDate, System.Int32?updatedBy, System.Boolean?reqSerialNo, System.String mslLevel, System.Boolean?printHazardous);
/// <summary>
/// Insert
/// Calls [usp_insert_DebitLine]
/// </summary>
public static Int32 Insert(System.Int32?debitNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?productNo, System.Int32?quantity, System.Double?price, System.Boolean?taxable, System.String supplierPart, System.Double?landedCost, System.Int32?purchaseOrderLineNo, System.Int32?supplierRmaLineNo, System.Int32?stockNo, System.Int32?serviceNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, out int debitId, out int debitNumber)
{
Int32 objReturn = Rebound.GlobalTrader.DAL.SiteProvider.DebitLine.Insert(debitNo, part, manufacturerNo, dateCode, packageNo, productNo, quantity, price, taxable, supplierPart, landedCost, purchaseOrderLineNo, supplierRmaLineNo, stockNo, serviceNo, rohs, notes, updatedBy, out debitId, out debitNumber, false);
return(objReturn);
}
/// <summary>
/// Update
/// Calls [usp_update_History]
/// </summary>
public static bool Update(System.Int32?historyId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.Int32?offerStatusNo, System.Int32?supplierNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy)
{
return(Rebound.GlobalTrader.DAL.SiteProvider.History.Update(historyId, part, manufacturerNo, dateCode, productNo, packageNo, quantity, price, currencyNo, offerStatusNo, supplierNo, rohs, notes, updatedBy));
}
public (System.UInt32 retval, IEnumerable <MSFTNetRoute> outCmdletOutput) Create(System.UInt16?inAddressFamily, System.UInt32?inCompartmentId, System.String inDestinationPrefix, System.String inInterfaceAlias, System.UInt32?inInterfaceIndex, System.String inNextHop, System.Boolean?inPassThru, System.String inPolicyStore, System.DateTime?inPreferredLifetime, System.UInt16?inProtocol, System.Byte?inPublish, System.UInt16?inRouteMetric, System.DateTime?inValidLifetime)
{
var parameters = new CimMethodParametersCollection();
if (inAddressFamily.HasValue)
{
parameters.Add(CimMethodParameter.Create("AddressFamily", inAddressFamily.Value, CimFlags.None));
}
if (inCompartmentId.HasValue)
{
parameters.Add(CimMethodParameter.Create("CompartmentId", inCompartmentId.Value, CimFlags.None));
}
if (inDestinationPrefix != null)
{
parameters.Add(CimMethodParameter.Create("DestinationPrefix", inDestinationPrefix, CimType.String, inDestinationPrefix == null ? CimFlags.NullValue : CimFlags.None));
}
if (inInterfaceAlias != null)
{
parameters.Add(CimMethodParameter.Create("InterfaceAlias", inInterfaceAlias, CimType.String, inInterfaceAlias == null ? CimFlags.NullValue : CimFlags.None));
}
if (inInterfaceIndex.HasValue)
{
parameters.Add(CimMethodParameter.Create("InterfaceIndex", inInterfaceIndex.Value, CimFlags.None));
}
if (inNextHop != null)
{
parameters.Add(CimMethodParameter.Create("NextHop", inNextHop, CimType.String, inNextHop == null ? CimFlags.NullValue : CimFlags.None));
}
if (inPassThru.HasValue)
{
parameters.Add(CimMethodParameter.Create("PassThru", inPassThru.Value, CimFlags.None));
}
if (inPolicyStore != null)
{
parameters.Add(CimMethodParameter.Create("PolicyStore", inPolicyStore, CimType.String, inPolicyStore == null ? CimFlags.NullValue : CimFlags.None));
}
if (inPreferredLifetime.HasValue)
{
parameters.Add(CimMethodParameter.Create("PreferredLifetime", inPreferredLifetime.Value, CimFlags.None));
}
if (inProtocol.HasValue)
{
parameters.Add(CimMethodParameter.Create("Protocol", inProtocol.Value, CimFlags.None));
}
if (inPublish.HasValue)
{
parameters.Add(CimMethodParameter.Create("Publish", inPublish.Value, CimFlags.None));
}
if (inRouteMetric.HasValue)
{
parameters.Add(CimMethodParameter.Create("RouteMetric", inRouteMetric.Value, CimFlags.None));
}
if (inValidLifetime.HasValue)
{
parameters.Add(CimMethodParameter.Create("ValidLifetime", inValidLifetime.Value, CimFlags.None));
}
var result = InfrastuctureObjectScope.CimSession.InvokeMethod(InnerCimInstance, "Create", parameters);
return((System.UInt32)result.ReturnValue.Value, (IEnumerable <MSFTNetRoute>)InfrastuctureObjectScope.Mapper.CreateMany <MSFTNetRoute>(InfrastuctureObjectScope, (IEnumerable <CimInstance>)result.OutParameters["CmdletOutput"].Value));
}
/// <summary>
/// Insert
/// Calls [usp_insert_CreditLine]
/// </summary>
public static Int32 Insert(System.Int32?creditNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?productNo, System.Int32?quantity, System.Double?price, System.Boolean?taxable, System.String customerPart, System.Double?landedCost, System.Int32?invoiceLineNo, System.Int32?customerRmaLineNo, System.Int32?stockNo, System.Int32?serviceNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Int32?ClientInvoiceLineId, out int creditId, out int creditNumber)
{
Int32 objReturn = Rebound.GlobalTrader.DAL.SiteProvider.CreditLine.Insert(creditNo, part, manufacturerNo, dateCode, packageNo, productNo, quantity, price, taxable, customerPart, landedCost, invoiceLineNo, customerRmaLineNo, stockNo, serviceNo, rohs, notes, updatedBy, ClientInvoiceLineId, out creditId, out creditNumber);
return(objReturn);
}
public (System.UInt32 retval, IEnumerable <MSFTNetNeighbor> outCmdletOutput) Create(System.UInt16?inAddressFamily, System.String inInterfaceAlias, System.UInt32?inInterfaceIndex, System.String inIPAddress, System.String inLinkLayerAddress, System.Boolean?inPassThru, System.String inPolicyStore, System.Byte?inState)
{
var parameters = new CimMethodParametersCollection();
if (inAddressFamily.HasValue)
{
parameters.Add(CimMethodParameter.Create("AddressFamily", inAddressFamily.Value, CimFlags.None));
}
if (inInterfaceAlias != null)
{
parameters.Add(CimMethodParameter.Create("InterfaceAlias", inInterfaceAlias, CimType.String, inInterfaceAlias == null ? CimFlags.NullValue : CimFlags.None));
}
if (inInterfaceIndex.HasValue)
{
parameters.Add(CimMethodParameter.Create("InterfaceIndex", inInterfaceIndex.Value, CimFlags.None));
}
if (inIPAddress != null)
{
parameters.Add(CimMethodParameter.Create("IPAddress", inIPAddress, CimType.String, inIPAddress == null ? CimFlags.NullValue : CimFlags.None));
}
if (inLinkLayerAddress != null)
{
parameters.Add(CimMethodParameter.Create("LinkLayerAddress", inLinkLayerAddress, CimType.String, inLinkLayerAddress == null ? CimFlags.NullValue : CimFlags.None));
}
if (inPassThru.HasValue)
{
parameters.Add(CimMethodParameter.Create("PassThru", inPassThru.Value, CimFlags.None));
}
if (inPolicyStore != null)
{
parameters.Add(CimMethodParameter.Create("PolicyStore", inPolicyStore, CimType.String, inPolicyStore == null ? CimFlags.NullValue : CimFlags.None));
}
if (inState.HasValue)
{
parameters.Add(CimMethodParameter.Create("State", inState.Value, CimFlags.None));
}
var result = InfrastuctureObjectScope.CimSession.InvokeMethod(InnerCimInstance, "Create", parameters);
return((System.UInt32)result.ReturnValue.Value, (IEnumerable <MSFTNetNeighbor>)InfrastuctureObjectScope.Mapper.CreateMany <MSFTNetNeighbor>(InfrastuctureObjectScope, (IEnumerable <CimInstance>)result.OutParameters["CmdletOutput"].Value));
}
/// Insert /// Calls [usp_insert_ExcessClone] /// </summary> public abstract Int32 CloneTrustedAddToReq(System.Int32 trustedId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.DateTime?originalEntryDate, System.Int32?salesman, System.Int32?companyNo, System.String companyName, System.Byte?rohs, System.String notes, System.Int32?updatedBy, System.Int32?clientNo, System.Int32?offerStatusNo, bool?isPoHub, System.String supplierTotalQSA, System.String supplierMOQ, System.String supplierLTB, System.String msl, System.String spq, System.String leadTime, System.String factorySealed, System.String rohsStatus, System.Int32?customerRequirementNo, System.Int32?mslLevelNo);
/// <summary> /// Update /// Calls [usp_update_GoodsInLine] /// </summary> public abstract bool Update(System.Int32?goodsInLineId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Double?shipInCost, System.String qualityControlNotes, System.String location, System.Int32?lotNo, System.Int32?productNo, System.String supplierPart, System.Byte?rohs, System.Int32?countryOfManufacture, System.Int32?currencyNo, System.Boolean?unavailable, System.String changedFields, System.String notes, System.Int32?countingMethodNo, System.Boolean?serialNosRecorded, System.String partMarkings, System.Boolean?updateStock, System.Boolean?updateShipments, System.Int32?updatedBy, System.Double?clientPrice, System.Boolean?reqSerialNo, System.String mslLevel, System.Boolean?printHazardous);
/// <summary> /// Create Clone /// Calls [usp_insert_Clone_SalesOrderLine] /// </summary> public abstract Int32 CreateCloneSOLine(System.Int32?salesOrderNo, System.Int32?quantity, System.Double?price, System.DateTime?datePromised, System.DateTime?requiredDate, System.DateTime?poDeleveryDate, System.Int32?updatedBy, int?sourcingResultNo, int?SalesOrderLineID, System.Boolean?IsIPO, System.Int32?InternalPurchaseOrderNo, System.String Notes, System.String Instruction, Int32?Flag, System.Byte?productSource, out string Message);
/// <summary> /// Update /// Calls [usp_update_Excess] /// </summary> public abstract bool Update(System.Int32?excessId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.Int32?offerStatusNo, System.Int32?companyNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, bool?isPoHub);
/// <summary> /// Insert /// Calls [usp_insert_DebitLine] /// </summary> public abstract Int32 Insert(System.Int32?debitNo, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?packageNo, System.Int32?productNo, System.Int32?quantity, System.Double?price, System.Boolean?taxable, System.String supplierPart, System.Double?landedCost, System.Int32?purchaseOrderLineNo, System.Int32?supplierRmaLineNo, System.Int32?stockNo, System.Int32?serviceNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, out int debitId, out int debitNumber, System.Boolean?printHazardous);
/// <summary> /// Update /// Calls [usp_update_Excess] /// </summary> public abstract bool IPOBOMUpdate(System.Int32?excessId, System.String part, System.Int32?manufacturerNo, System.String dateCode, System.Int32?productNo, System.Int32?packageNo, System.Int32?quantity, System.Double?price, System.Int32?currencyNo, System.Int32?offerStatusNo, System.Int32?companyNo, System.Byte?rohs, System.String notes, System.Int32?updatedBy, bool?isPoHub, System.String supplierTotalQSA, System.String supplierMOQ, System.String supplierLTB, System.String MSL, System.String SPQ, System.String leadTime, System.String factorySealed, System.String rohsStatus, System.Int32?mslLevelNo);