/// <summary> /// Deletes a SalutationType record /// </summary> public static int Delete(SalutationTypeDO DO) { SqlParameter _SalutationID = new SqlParameter("SalutationID", SqlDbType.VarChar); _SalutationID.Value = DO.SalutationID; SqlParameter[] _params = new SqlParameter[] { _SalutationID }; return DataCommon.ExecuteScalar("[dbo].[SalutationType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new SalutationType record /// </summary> public static void Create(SalutationTypeDO DO) { SqlParameter _SalutationID = new SqlParameter("SalutationID", SqlDbType.VarChar); _SalutationID.Value = DO.SalutationID; SqlParameter[] _params = new SqlParameter[] { _SalutationID }; DataCommon.ExecuteNonQuery("[dbo].[SalutationType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all SalutationType records /// </summary> public static SalutationTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[SalutationType_GetAll]", new SqlParameter[] { }, "dbo"); List<SalutationTypeDO> objs = new List<SalutationTypeDO>(); while(sr.Read()){ SalutationTypeDO obj = new SalutationTypeDO(); obj.SalutationID = sr.GetString(sr.GetOrdinal("SalutationID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects SalutationType records by PK /// </summary> public static SalutationTypeDO[] GetByPK(String SalutationID) { SqlParameter _SalutationID = new SqlParameter("SalutationID", SqlDbType.VarChar); _SalutationID.Value = SalutationID; SqlParameter[] _params = new SqlParameter[] { _SalutationID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[SalutationType_GetByPK]", _params, "dbo"); List<SalutationTypeDO> objs = new List<SalutationTypeDO>(); while(sr.Read()) { SalutationTypeDO obj = new SalutationTypeDO(); obj.SalutationID = sr.GetString(sr.GetOrdinal("SalutationID")); objs.Add(obj); } return objs.ToArray(); }