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