/// <summary> /// Saves a record to the sol_Customers table. /// </summary> public virtual void Insert(Sol_Customer sol_Customer) { ValidationUtility.ValidateArgument("sol_Customer", sol_Customer); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CustomerCode", sol_Customer.CustomerCode), new SqlParameter("@Name", sol_Customer.Name), new SqlParameter("@Contact", sol_Customer.Contact), new SqlParameter("@Address1", sol_Customer.Address1), new SqlParameter("@Address2", sol_Customer.Address2), new SqlParameter("@City", sol_Customer.City), new SqlParameter("@Province", sol_Customer.Province), new SqlParameter("@Country", sol_Customer.Country), new SqlParameter("@PostalCode", sol_Customer.PostalCode), new SqlParameter("@Email", sol_Customer.Email), new SqlParameter("@LoweredEmail", sol_Customer.LoweredEmail), new SqlParameter("@IsActive", sol_Customer.IsActive), new SqlParameter("@PhoneNumber", sol_Customer.PhoneNumber), new SqlParameter("@Notes", sol_Customer.Notes), new SqlParameter("@Password", sol_Customer.Password), new SqlParameter("@DepotID", sol_Customer.DepotID), new SqlParameter("@CardNumber", sol_Customer.CardNumber), new SqlParameter("@CardTypeID", sol_Customer.CardTypeID), new SqlParameter("@SolumCustomer", sol_Customer.SolumCustomer), new SqlParameter("@QuickDropCustomer", sol_Customer.QuickDropCustomer) // , //new SqlParameter("@IsNew", sol_Customer.IsNew) }; sol_Customer.CustomerID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_Customers_Insert", parameters); }
/// <summary> /// Saves a record to the sol_CategoryButtons table. /// </summary> public virtual void Insert(Sol_CategoryButton sol_CategoryButton) { ValidationUtility.ValidateArgument("sol_CategoryButton", sol_CategoryButton); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@WorkStationID", sol_CategoryButton.WorkStationID), new SqlParameter("@ControlType", sol_CategoryButton.ControlType), new SqlParameter("@Description", sol_CategoryButton.Description), new SqlParameter("@DefaultQuantity", sol_CategoryButton.DefaultQuantity), new SqlParameter("@CategoryID", sol_CategoryButton.CategoryID), new SqlParameter("@LocationX", sol_CategoryButton.LocationX), new SqlParameter("@LocationY", sol_CategoryButton.LocationY), new SqlParameter("@Width", sol_CategoryButton.Width), new SqlParameter("@Height", sol_CategoryButton.Height), new SqlParameter("@Font", sol_CategoryButton.Font), new SqlParameter("@FontStyle", sol_CategoryButton.FontStyle), new SqlParameter("@ForeColor", sol_CategoryButton.ForeColor), new SqlParameter("@BackColor", sol_CategoryButton.BackColor), new SqlParameter("@ImageIndex", sol_CategoryButton.ImageIndex), new SqlParameter("@ImagePath", sol_CategoryButton.ImagePath), new SqlParameter("@SubContainerMaxCount", sol_CategoryButton.SubContainerMaxCount), new SqlParameter("@SubContainerCounter", sol_CategoryButton.SubContainerCounter), new SqlParameter("@ImageSize", sol_CategoryButton.ImageSize), new SqlParameter("@SubContainerCountDown", sol_CategoryButton.SubContainerCountDown), new SqlParameter("@MaxCountPerLine", sol_CategoryButton.MaxCountPerLine) //new SqlParameter("@ForeColorArgb", sol_CategoryButton.ForeColorArgb), //new SqlParameter("@BackColorArgb", sol_CategoryButton.BackColorArgb) }; sol_CategoryButton.CategoryButtonID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_CategoryButtons_Insert", parameters); }
/// <summary> /// Saves a record to the sol_Stage table. /// </summary> public virtual void Insert(Sol_Stage sol_Stage) { ValidationUtility.ValidateArgument("sol_Stage", sol_Stage); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ShipmentID", sol_Stage.ShipmentID), new SqlParameter("@UserID", sol_Stage.UserID), new SqlParameter("@UserName", sol_Stage.UserName), new SqlParameter("@Date", sol_Stage.Date), new SqlParameter("@TagNumber", sol_Stage.TagNumber), new SqlParameter("@ContainerID", sol_Stage.ContainerID), new SqlParameter("@ContainerDescription", sol_Stage.ContainerDescription), new SqlParameter("@ProductID", sol_Stage.ProductID), new SqlParameter("@ProductName", sol_Stage.ProductName), new SqlParameter("@Dozen", sol_Stage.Dozen), new SqlParameter("@Quantity", sol_Stage.Quantity), new SqlParameter("@Price", sol_Stage.Price), new SqlParameter("@Remarks", sol_Stage.Remarks), new SqlParameter("@Status", sol_Stage.Status), new SqlParameter("@DateClosed", sol_Stage.DateClosed) }; sol_Stage.StageID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_Stage_Insert", parameters); }
/// <summary> /// Saves a record to the sol_Shipment table. /// </summary> public virtual void Insert(Sol_Shipment sol_Shipment) { ValidationUtility.ValidateArgument("sol_Shipment", sol_Shipment); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", sol_Shipment.UserID), new SqlParameter("@UserName", sol_Shipment.UserName), new SqlParameter("@RBillNumber", sol_Shipment.RBillNumber), new SqlParameter("@Date", sol_Shipment.Date), new SqlParameter("@AgencyID", sol_Shipment.AgencyID), new SqlParameter("@AgencyName", sol_Shipment.AgencyName), new SqlParameter("@AgencyAddress1", sol_Shipment.AgencyAddress1), new SqlParameter("@AgencyAddress2", sol_Shipment.AgencyAddress2), new SqlParameter("@AgencyCity", sol_Shipment.AgencyCity), new SqlParameter("@AgencyProvince", sol_Shipment.AgencyProvince), new SqlParameter("@AgencyCountry", sol_Shipment.AgencyCountry), new SqlParameter("@AgencyPostalCode", sol_Shipment.AgencyPostalCode), new SqlParameter("@Status", sol_Shipment.Status), new SqlParameter("@CarrierID", sol_Shipment.CarrierID), new SqlParameter("@PlantID", sol_Shipment.PlantID), new SqlParameter("@TrailerNumber", sol_Shipment.TrailerNumber), new SqlParameter("@ProBillNumber", sol_Shipment.ProBillNumber), new SqlParameter("@ShippedDate", sol_Shipment.ShippedDate), new SqlParameter("@SealNumber", sol_Shipment.SealNumber), new SqlParameter("@LoadReference", sol_Shipment.LoadReference), new SqlParameter("@eRBillTransmitted", sol_Shipment.ERBillTransmitted) }; sol_Shipment.ShipmentID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_Shipment_Insert", parameters); }
/// <summary> /// Saves a record to the sol_OrdersDetail table. /// </summary> public virtual void Insert(Sol_OrdersDetail sol_OrdersDetail) { ValidationUtility.ValidateArgument("sol_OrdersDetail", sol_OrdersDetail); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@OrderID", sol_OrdersDetail.OrderID), new SqlParameter("@OrderType", sol_OrdersDetail.OrderType), new SqlParameter("@Date", sol_OrdersDetail.Date), new SqlParameter("@CategoryID", sol_OrdersDetail.CategoryID), new SqlParameter("@ProductID", sol_OrdersDetail.ProductID), new SqlParameter("@Description", sol_OrdersDetail.Description), new SqlParameter("@Quantity", sol_OrdersDetail.Quantity), new SqlParameter("@Price", sol_OrdersDetail.Price), new SqlParameter("@Amount", sol_OrdersDetail.Amount), new SqlParameter("@Status", sol_OrdersDetail.Status), new SqlParameter("@CategoryButtonID", sol_OrdersDetail.CategoryButtonID), new SqlParameter("@BagID", sol_OrdersDetail.BagID), //new SqlParameter("@IsNew", sol_OrdersDetail.IsNew), new SqlParameter("@ConveyorID", sol_OrdersDetail.ConveyorID), new SqlParameter("@StageID", sol_OrdersDetail.StageID) }; sol_OrdersDetail.DetailID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_OrdersDetail_Insert", parameters); }
/// <summary> /// Saves a record to the Location table. /// </summary> public virtual void Insert(Location location) { ValidationUtility.ValidateArgument("location", location); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Code", location.Code), new SqlParameter("@Name", location.Name), new SqlParameter("@MapLatitude", location.MapLatitude), new SqlParameter("@MapLongitude", location.MapLongitude), new SqlParameter("@IsApproved", location.IsApproved), new SqlParameter("@IsActive", location.IsActive), new SqlParameter("@AuthorComments", location.AuthorComments), new SqlParameter("@ApproverComments", location.ApproverComments), new SqlParameter("@Comments", location.Comments), new SqlParameter("@LocationType", location.LocationType), new SqlParameter("@Polygon", location.Polygon), new SqlParameter("@InternalComment", location.InternalComment), new SqlParameter("@CreatedBy", location.CreatedBy), new SqlParameter("@CreatedOn", location.CreatedOn), new SqlParameter("@AuditActionBy", location.AuditActionBy), new SqlParameter("@AuditActionOn", location.AuditActionOn) }; location.ID = Convert.ToInt32(SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "LocationInsert", parameters)); }
/// <summary> /// Saves a record to the Sac_Log table. /// </summary> public virtual void Insert(Sac_Log sac_Log) { ValidationUtility.ValidateArgument("sac_Log", sac_Log); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@EntryType", sac_Log.EntryType), new SqlParameter("@OrderNumber", sac_Log.OrderNumber), new SqlParameter("@OrderAmount", sac_Log.OrderAmount), new SqlParameter("@Description", sac_Log.Description), new SqlParameter("@Quantityof50", sac_Log.Quantityof50), new SqlParameter("@Quantityof20", sac_Log.Quantityof20), new SqlParameter("@Quantityof10", sac_Log.Quantityof10), new SqlParameter("@Quantityof5", sac_Log.Quantityof5), new SqlParameter("@QuantityofToonie", sac_Log.QuantityofToonie), new SqlParameter("@QuantityofLoonie", sac_Log.QuantityofLoonie), new SqlParameter("@QuantityofQuarter", sac_Log.QuantityofQuarter), new SqlParameter("@QuantityofDime", sac_Log.QuantityofDime), new SqlParameter("@QuantityofNickel", sac_Log.QuantityofNickel), new SqlParameter("@TotalValue", sac_Log.TotalValue), new SqlParameter("@Remaining50", sac_Log.Remaining50), new SqlParameter("@Remaining20", sac_Log.Remaining20), new SqlParameter("@Remaining10", sac_Log.Remaining10), new SqlParameter("@Remaining5", sac_Log.Remaining5), new SqlParameter("@RemainingToonie", sac_Log.RemainingToonie), new SqlParameter("@RemainingLoonie", sac_Log.RemainingLoonie), new SqlParameter("@RemainingQuarter", sac_Log.RemainingQuarter), new SqlParameter("@RemainingDime", sac_Log.RemainingDime), new SqlParameter("@RemainingNickel", sac_Log.RemainingNickel), new SqlParameter("@TimeStamp", sac_Log.TimeStamp) }; sac_Log.LogID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Sac_Log_Insert", parameters); }
public void Insert(DVV DigitoVV) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Tabla", DigitoVV.tabla), new SqlParameter("@DVV", DigitoVV.dvv) }; SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "InsertDVV", parameters); }
/// <summary> /// Updates a record in the Sol_AutoNumbers table. /// </summary> public virtual int UpdateRBillNumber(int agencyID, int folioID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AgencyID", agencyID), new SqlParameter("@FolioID", folioID) }; return((int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Sol_AutoNumbers_UpdateRBillNumber", parameters)); }
public void InsertIdDireccion(int IdDir, int IdItem) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@IdItemOrdenDeTrabajo", IdItem), new SqlParameter("@IdDireccion", IdDir) }; SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ItemIdDireccionInsert", parameters); }
/// <summary> /// Saves a record to the EstadoPedido table. /// </summary> public void Insert(EstadoPedidoEntidad estadoPedido) { ValidationUtility.ValidateArgument("estadoPedido", estadoPedido); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripcionEstadoPedido", estadoPedido.DescripcionEstadoPedido) }; estadoPedido.IdEstadoPedido = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "EstadoPedidoInsert", parameters); }
/// <summary> /// Saves a record to the TipoTel table. /// </summary> public void Insert(TipoTelEntidad tipoTel) { ValidationUtility.ValidateArgument("tipoTel", tipoTel); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripcionTipoTel", tipoTel.DescripcionTipoTel) }; tipoTel.IdTipoTel = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "TipoTelInsert", parameters); }
/// <summary> /// Saves a record to the Patente table. /// </summary> public void Insert(PatenteEntidad patente) { ValidationUtility.ValidateArgument("patente", patente); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@NombrePatente", patente.NombrePatente) }; patente.IdPatente = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "PatenteInsert", parameters); }
/// <summary> /// Saves a record to the Vir_Conveyor table. /// </summary> public virtual void Insert(Vir_Conveyor vir_Conveyor) { ValidationUtility.ValidateArgument("vir_Conveyor", vir_Conveyor); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ConveyorDescription", vir_Conveyor.ConveyorDescription) }; vir_Conveyor.ConveyorID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Vir_Conveyor_Insert", parameters); }
/// <summary> /// Saves a record to the Marca table. /// </summary> public void Insert(MarcaEntidad marca) { ValidationUtility.ValidateArgument("marca", marca); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripcionMarca", marca.DescripcionMarca) }; marca.IdMarca = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "MarcaInsert", parameters); }
/// <summary> /// Saves a record to the HANG_SAN_XUAT table. /// </summary> public void Insert(HANGSANXUAT_DTO HangSanXuat) { ValidationUtility.ValidateArgument("HangSanXuat", HangSanXuat); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TEN_HANG_XE", HangSanXuat.TenHangXe) }; HangSanXuat.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_HangSanXuat_Insert", parameters); }
public void Insert(IdiomaEntidad lenguaje) { ValidationUtility.ValidateArgument("lenguaje", lenguaje); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Descripcion", lenguaje.Descripcion) }; SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "IdiomaInsert", parameters); }
/// <summary> /// Saves a record to the Qds_CardType table. /// </summary> public virtual void Insert(Qds_CardType qds_CardType) { ValidationUtility.ValidateArgument("qds_CardType", qds_CardType); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CardType", qds_CardType.CardType) }; qds_CardType.CardTypeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Qds_CardType_Insert", parameters); }
/// <summary> /// Saves a record to the TipoComprobante table. /// </summary> public void Insert(TipoComprobanteEntidad tipoComprobante) { ValidationUtility.ValidateArgument("tipoComprobante", tipoComprobante); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripTipoComprobante", tipoComprobante.DescripTipoComprobante) }; tipoComprobante.IdTipoComprobante = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "TipoComprobanteInsert", parameters); }
/// <summary> /// Saves a record to the Familia table. /// </summary> public void Insert(FamiliaEntidad familia) { ValidationUtility.ValidateArgument("familia", familia); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@NombreFamilia", familia.NombreFamilia) }; familia.IdFamilia = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "FamiliaInsert", parameters); }
/// <summary> /// Saves a record to the sol_ContainerTypes table. /// </summary> public virtual void Insert(Sol_ContainerType sol_ContainerType) { ValidationUtility.ValidateArgument("sol_ContainerType", sol_ContainerType); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Description", sol_ContainerType.Description) }; sol_ContainerType.ContainerTypeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_ContainerTypes_Insert", parameters); }
/// <summary> /// Saves a record to the CondicionFiscal table. /// </summary> public void Insert(CondicionFiscalEntidad condicionFiscal) { ValidationUtility.ValidateArgument("condicionFiscal", condicionFiscal); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Descripcion", condicionFiscal.Descripcion) }; condicionFiscal.IdCondicionFiscal = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "CondicionFiscalInsert", parameters); }
/// <summary> /// Saves a record to the Vir_StagingMethod table. /// </summary> public virtual void Insert(Vir_StagingMethod vir_StagingMethod) { ValidationUtility.ValidateArgument("vir_StagingMethod", vir_StagingMethod); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@StagingMethodName", vir_StagingMethod.StagingMethodName) }; vir_StagingMethod.StagingMethodID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Vir_StagingMethod_Insert", parameters); }
/// <summary> /// Saves a record to the Categoria table. /// </summary> public void Insert(CategoriaEntidad categoria) { ValidationUtility.ValidateArgument("categoria", categoria); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripCategoria", categoria.DescripCategoria) }; categoria.IdCategoria = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "CategoriaInsert", parameters); }
public void Insert(OrdenDeTrabajoEntidad listaODT) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@IdUsuario", listaODT._MiUsuario.IdUsuario), new SqlParameter("@Fecha", DateTime.Now), new SqlParameter("@IdEstado", 1), }; SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "OrdenInsert", parameters); }
/// <summary> /// Saves a record to the sol_StandardDozen table. /// </summary> public virtual void Insert(Sol_StandardDozen sol_StandardDozen) { ValidationUtility.ValidateArgument("sol_StandardDozen", sol_StandardDozen); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Quantity", sol_StandardDozen.Quantity) }; sol_StandardDozen.StandardDozenID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_StandardDozen_Insert", parameters); }
/// <summary> /// Saves a record to the FormaPago table. /// </summary> public void Insert(FormaPagoEntidad formaPago) { ValidationUtility.ValidateArgument("formaPago", formaPago); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DescripFormaPago", formaPago.DescripFormaPago) }; formaPago.IdFormaPago = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "FormaPagoInsert", parameters); }
public int ObtenerIDAdqByIdSucIdProdIdAdq(int IdAdquisicion, int IdSucursal, int IdProducto) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@IdAdquisicion", IdAdquisicion), new SqlParameter("@IdSucursal", IdSucursal), new SqlParameter("@IdProducto", IdProducto) }; return((int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ObtenerIDAdqByIdSucIdProdIdAdq", parameters)); }
/// <summary> /// Saves a record to the IvaProducto table. /// </summary> public void Insert(IvaProductoEntidad ivaProducto) { ValidationUtility.ValidateArgument("ivaProducto", ivaProducto); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@PorcentajeIvaProd", ivaProducto.PorcentajeIvaProd) }; ivaProducto.IdIvaProducto = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "IvaProductoInsert", parameters); }
/// <summary> /// Saves a record to the UsuarioTipo table. /// </summary> public void Insert(UsuarioTipoEntidad usuarioTipo) { ValidationUtility.ValidateArgument("usuarioTipo", usuarioTipo); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Descripcion", usuarioTipo.Descripcion) }; usuarioTipo.IdUsuarioTipo = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "UsuarioTipoInsert", parameters); }