public static int Insert(CargoInfo _CargoInfo)
{
//Execute the query and return the new Guid
object retval = _AdoHelper.ExecuteScalar(ConnectionString, "CargoInsert",
new SqlParameter("@Descripcion", _CargoInfo.Descripcion),
new SqlParameter("@Empresa", _CargoInfo.Empresa),
new SqlParameter("@Orden", _CargoInfo.Orden)
);
return Int32.Parse(retval.ToString());
}
/// <summary>
/// Creates a new instance of the Cargo class and populates it with data from the specified SqlDataReader.
/// </summary>
private static CargoInfo MakeCargo(SqlDataReader dataReader)
{
CargoInfo cargo = new CargoInfo();
if (dataReader.IsDBNull(CargoId) == false)
cargo.CargoId = dataReader.GetInt32(CargoId);
if (dataReader.IsDBNull(Descripcion) == false)
cargo.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(Empresa) == false)
cargo.Empresa = dataReader.GetString(Empresa);
if (dataReader.IsDBNull(Orden) == false)
cargo.Orden = dataReader.GetByte(Orden);
return cargo;
}
public static void Delete(CargoInfo _CargoInfo)
{
_AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "CargoDelete",
new SqlParameter("@CargoId", _CargoInfo.CargoId)
);
}
public static void Update(CargoInfo _CargoInfo)
{
_AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "CargoUpdate",
new SqlParameter("@CargoId", _CargoInfo.CargoId),
new SqlParameter("@Descripcion", _CargoInfo.Descripcion),
new SqlParameter("@Empresa", _CargoInfo.Empresa),
new SqlParameter("@Orden", _CargoInfo.Orden)
);
}
