/// <summary>
/// Creates a new PondSpecificDesignAndAsBuilt record using async
/// </summary>
public static async Task<int> CreateAsync(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
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[PondSpecificDesignAndAsBuilt_Insert]", _params, pid);
}
/// <summary>
/// Gets all PondSpecificDesignAndAsBuilt records
/// </summary>
public static PondSpecificDesignAndAsBuiltDO[] GetAll()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PondSpecificDesignAndAsBuilt_GetAll]", new SqlParameter[] { }, pid);
List<PondSpecificDesignAndAsBuiltDO> objs = new List<PondSpecificDesignAndAsBuiltDO>();
while(sr.Read()){
PondSpecificDesignAndAsBuiltDO obj = new PondSpecificDesignAndAsBuiltDO();
obj.PondSpecificDesignAndAsBuiltID = sr.GetInt32(sr.GetOrdinal("PondSpecificDesignAndAsBuiltID"));
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>
/// Selects PondSpecificDesignAndAsBuilt records by PK
/// </summary>
public static async Task<PondSpecificDesignAndAsBuiltDO[]> GetByPKAsync(Int32 PondSpecificDesignAndAsBuiltID)
{
SqlParameter _PondSpecificDesignAndAsBuiltID = new SqlParameter("PondSpecificDesignAndAsBuiltID", SqlDbType.Int);
_PondSpecificDesignAndAsBuiltID.Value = PondSpecificDesignAndAsBuiltID;
SqlParameter[] _params = new SqlParameter[] {
_PondSpecificDesignAndAsBuiltID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[PondSpecificDesignAndAsBuilt_GetByPK]", _params, pid);
List<PondSpecificDesignAndAsBuiltDO> objs = new List<PondSpecificDesignAndAsBuiltDO>();
while(sr.Read())
{
PondSpecificDesignAndAsBuiltDO obj = new PondSpecificDesignAndAsBuiltDO();
obj.PondSpecificDesignAndAsBuiltID = sr.GetInt32(sr.GetOrdinal("PondSpecificDesignAndAsBuiltID"));
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>
/// Deletes a PondSpecificDesignAndAsBuilt record
/// </summary>
public static async Task<int> DeleteAsync(PondSpecificDesignAndAsBuiltDO DO)
{
SqlParameter _PondSpecificDesignAndAsBuiltID = new SqlParameter("PondSpecificDesignAndAsBuiltID", SqlDbType.Int);
_PondSpecificDesignAndAsBuiltID.Value = DO.PondSpecificDesignAndAsBuiltID;
SqlParameter[] _params = new SqlParameter[] {
_PondSpecificDesignAndAsBuiltID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[PondSpecificDesignAndAsBuilt_Delete]", _params, pid);
}