/// <summary>
/// Deletes a PondSpecificDesignAndAsBuilt record
/// </summary>
public static int Delete(PondSpecificDesignAndAsBuiltDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PondID = new SqlParameter("PondID", SqlDbType.VarChar);
_PermitKey.Value = DO.PermitKey;
_PondID.Value = DO.PondID;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PondID
};
return DataCommon.ExecuteScalar("[dbo].[PondSpecificDesignAndAsBuilt_Delete]", _params, "dbo");
}
/// <summary>
/// Gets all PondSpecificDesignAndAsBuilt records
/// </summary>
public static PondSpecificDesignAndAsBuiltDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PondSpecificDesignAndAsBuilt_GetAll]", new SqlParameter[] { }, "dbo");
List<PondSpecificDesignAndAsBuiltDO> objs = new List<PondSpecificDesignAndAsBuiltDO>();
while(sr.Read()){
PondSpecificDesignAndAsBuiltDO obj = new PondSpecificDesignAndAsBuiltDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.PondID = sr.GetString(sr.GetOrdinal("PondID"));
obj.DesignAttachmentID = sr.GetInt32(sr.GetOrdinal("DesignAttachmentID"));
if (sr.IsDBNull(sr.GetOrdinal("AsBuiltAttachmentID"))) { obj.AsBuiltAttachmentID = null; } else { obj.AsBuiltAttachmentID = sr.GetInt32(sr.GetOrdinal("AsBuiltAttachmentID")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Creates a new PondSpecificDesignAndAsBuilt record
/// </summary>
public static void Create(PondSpecificDesignAndAsBuiltDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PondID = new SqlParameter("PondID", SqlDbType.VarChar);
SqlParameter _DesignAttachmentID = new SqlParameter("DesignAttachmentID", SqlDbType.Int);
SqlParameter _AsBuiltAttachmentID = new SqlParameter("AsBuiltAttachmentID", SqlDbType.Int);
_PermitKey.Value = DO.PermitKey;
_PondID.Value = DO.PondID;
_DesignAttachmentID.Value = DO.DesignAttachmentID;
_AsBuiltAttachmentID.Value = DO.AsBuiltAttachmentID;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PondID,
_DesignAttachmentID,
_AsBuiltAttachmentID
};
DataCommon.ExecuteNonQuery("[dbo].[PondSpecificDesignAndAsBuilt_Insert]", _params, "dbo");
}
/// <summary>
/// Selects PondSpecificDesignAndAsBuilt records by PK
/// </summary>
public static PondSpecificDesignAndAsBuiltDO[] GetByPK(Int32 PermitKey,
String PondID)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _PondID = new SqlParameter("PondID", SqlDbType.VarChar);
_PermitKey.Value = PermitKey;
_PondID.Value = PondID;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_PondID
};
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PondSpecificDesignAndAsBuilt_GetByPK]", _params, "dbo");
List<PondSpecificDesignAndAsBuiltDO> objs = new List<PondSpecificDesignAndAsBuiltDO>();
while(sr.Read())
{
PondSpecificDesignAndAsBuiltDO obj = new PondSpecificDesignAndAsBuiltDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.PondID = sr.GetString(sr.GetOrdinal("PondID"));
obj.DesignAttachmentID = sr.GetInt32(sr.GetOrdinal("DesignAttachmentID"));
if (sr.IsDBNull(sr.GetOrdinal("AsBuiltAttachmentID"))) { obj.AsBuiltAttachmentID = null; } else { obj.AsBuiltAttachmentID = sr.GetInt32(sr.GetOrdinal("AsBuiltAttachmentID")); }
objs.Add(obj);
}
return objs.ToArray();
}
