/// <summary> /// Creates a new EmailConfirmationLanguage record using async /// </summary> public static async Task<int> CreateAsync(EmailConfirmationLanguageDO DO) { SqlParameter _EmailConfirmationType = new SqlParameter("EmailConfirmationType", SqlDbType.VarChar); SqlParameter _Subject = new SqlParameter("Subject", SqlDbType.VarChar); SqlParameter _Body = new SqlParameter("Body", SqlDbType.VarChar); _EmailConfirmationType.Value = DO.EmailConfirmationType; _Subject.Value = DO.Subject; _Body.Value = DO.Body; SqlParameter[] _params = new SqlParameter[] { _EmailConfirmationType, _Subject, _Body }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[EmailConfirmationLanguage_Insert]", _params, pid); }
/// <summary> /// Updates a EmailConfirmationLanguage record and returns the number of records affected /// </summary> public static int Update(EmailConfirmationLanguageDO DO) { SqlParameter _EmailConfirmationLanguageID = new SqlParameter("EmailConfirmationLanguageID", SqlDbType.Int); SqlParameter _EmailConfirmationType = new SqlParameter("EmailConfirmationType", SqlDbType.VarChar); SqlParameter _Subject = new SqlParameter("Subject", SqlDbType.VarChar); SqlParameter _Body = new SqlParameter("Body", SqlDbType.VarChar); _EmailConfirmationLanguageID.Value = DO.EmailConfirmationLanguageID; _EmailConfirmationType.Value = DO.EmailConfirmationType; _Subject.Value = DO.Subject; _Body.Value = DO.Body; SqlParameter[] _params = new SqlParameter[] { _EmailConfirmationLanguageID, _EmailConfirmationType, _Subject, _Body }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[EmailConfirmationLanguage_Update]", _params, pid); }
/// <summary> /// Gets all EmailConfirmationLanguage records /// </summary> public static async Task<EmailConfirmationLanguageDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[EmailConfirmationLanguage_GetAll]", new SqlParameter[] { }, pid); List<EmailConfirmationLanguageDO> objs = new List<EmailConfirmationLanguageDO>(); while(sr.Read()){ EmailConfirmationLanguageDO obj = new EmailConfirmationLanguageDO(); obj.EmailConfirmationLanguageID = sr.GetInt32(sr.GetOrdinal("EmailConfirmationLanguageID")); obj.EmailConfirmationType = sr.GetString(sr.GetOrdinal("EmailConfirmationType")); obj.Subject = sr.GetString(sr.GetOrdinal("Subject")); obj.Body = sr.GetString(sr.GetOrdinal("Body")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects EmailConfirmationLanguage records by PK /// </summary> public static async Task<EmailConfirmationLanguageDO[]> GetByPKAsync(Int32 EmailConfirmationLanguageID) { SqlParameter _EmailConfirmationLanguageID = new SqlParameter("EmailConfirmationLanguageID", SqlDbType.Int); _EmailConfirmationLanguageID.Value = EmailConfirmationLanguageID; SqlParameter[] _params = new SqlParameter[] { _EmailConfirmationLanguageID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[EmailConfirmationLanguage_GetByPK]", _params, pid); List<EmailConfirmationLanguageDO> objs = new List<EmailConfirmationLanguageDO>(); while(sr.Read()) { EmailConfirmationLanguageDO obj = new EmailConfirmationLanguageDO(); obj.EmailConfirmationLanguageID = sr.GetInt32(sr.GetOrdinal("EmailConfirmationLanguageID")); obj.EmailConfirmationType = sr.GetString(sr.GetOrdinal("EmailConfirmationType")); obj.Subject = sr.GetString(sr.GetOrdinal("Subject")); obj.Body = sr.GetString(sr.GetOrdinal("Body")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a EmailConfirmationLanguage record /// </summary> public static async Task<int> DeleteAsync(EmailConfirmationLanguageDO DO) { SqlParameter _EmailConfirmationLanguageID = new SqlParameter("EmailConfirmationLanguageID", SqlDbType.Int); _EmailConfirmationLanguageID.Value = DO.EmailConfirmationLanguageID; SqlParameter[] _params = new SqlParameter[] { _EmailConfirmationLanguageID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[EmailConfirmationLanguage_Delete]", _params, pid); }