/// <summary> /// Deletes a ApplicationType record /// </summary> public static int Delete(ApplicationTypeDO DO) { SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar); _ApplicationTypeID.Value = DO.ApplicationTypeID; SqlParameter[] _params = new SqlParameter[] { _ApplicationTypeID }; return DataCommon.ExecuteScalar("[dbo].[ApplicationType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new ApplicationType record /// </summary> public static void Create(ApplicationTypeDO DO) { SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar); _ApplicationTypeID.Value = DO.ApplicationTypeID; SqlParameter[] _params = new SqlParameter[] { _ApplicationTypeID }; DataCommon.ExecuteNonQuery("[dbo].[ApplicationType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all ApplicationType records /// </summary> public static ApplicationTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ApplicationType_GetAll]", new SqlParameter[] { }, "dbo"); List<ApplicationTypeDO> objs = new List<ApplicationTypeDO>(); while(sr.Read()){ ApplicationTypeDO obj = new ApplicationTypeDO(); obj.ApplicationTypeID = sr.GetString(sr.GetOrdinal("ApplicationTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects ApplicationType records by PK /// </summary> public static ApplicationTypeDO[] GetByPK(String ApplicationTypeID) { SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar); _ApplicationTypeID.Value = ApplicationTypeID; SqlParameter[] _params = new SqlParameter[] { _ApplicationTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ApplicationType_GetByPK]", _params, "dbo"); List<ApplicationTypeDO> objs = new List<ApplicationTypeDO>(); while(sr.Read()) { ApplicationTypeDO obj = new ApplicationTypeDO(); obj.ApplicationTypeID = sr.GetString(sr.GetOrdinal("ApplicationTypeID")); objs.Add(obj); } return objs.ToArray(); }