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