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