public static int Insert(TerritorioInfo _TerritorioInfo)
{
//Execute the query and return the new Guid
object retval = _AdoHelper.ExecuteScalar(ConnectionString, "TerritorioInsert",
new SqlParameter("@Descripcion", _TerritorioInfo.Descripcion),
new SqlParameter("@Responsable", _TerritorioInfo.Responsable),
new SqlParameter("@Abrv", _TerritorioInfo.Abrv)
);
return Int32.Parse(retval.ToString());
}
public static void Delete(TerritorioInfo _TerritorioInfo)
{
try
{
_AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "TerritorioDelete",
new SqlParameter("@TerritorioId", _TerritorioInfo.TerritorioId)
);
}
catch (SqlException ex)
{
//Este numero es cuando tiene refernecia a otras tablas
if (ex.Number != 547)
throw;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Creates a new instance of the Territorio class and populates it with data from the specified SqlDataReader.
/// </summary>
private static TerritorioInfo MakeTerritorio(SqlDataReader dataReader)
{
TerritorioInfo territorio = new TerritorioInfo();
if (dataReader.IsDBNull(TerritorioId) == false)
territorio.TerritorioId = dataReader.GetInt32(TerritorioId);
if (dataReader.IsDBNull(Descripcion) == false)
territorio.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(Responsable) == false)
territorio.Responsable = dataReader.GetInt32(Responsable);
if (dataReader.IsDBNull(Abrv) == false)
territorio.Abrv = dataReader.GetString(Abrv);
return territorio;
}
public static void Update(TerritorioInfo _TerritorioInfo)
{
_AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "TerritorioUpdate",
new SqlParameter("@TerritorioId", _TerritorioInfo.TerritorioId),
new SqlParameter("@Descripcion", _TerritorioInfo.Descripcion),
new SqlParameter("@Responsable", _TerritorioInfo.Responsable),
new SqlParameter("@Abrv", _TerritorioInfo.Abrv)
);
}
