public int RoleCreate( Guid roleGuid, Guid siteGuid, int siteId, string roleName) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("INSERT INTO mp_Roles "); sqlCommand.Append("("); sqlCommand.Append("SiteID, "); sqlCommand.Append("RoleName, "); sqlCommand.Append("DisplayName, "); sqlCommand.Append("SiteGuid, "); sqlCommand.Append("RoleGuid "); sqlCommand.Append(")"); sqlCommand.Append(" VALUES "); sqlCommand.Append("("); sqlCommand.Append("@SiteID, "); sqlCommand.Append("@RoleName, "); sqlCommand.Append("@DisplayName, "); sqlCommand.Append("@SiteGuid, "); sqlCommand.Append("@RoleGuid "); sqlCommand.Append(")"); sqlCommand.Append(";"); SqlCeParameter[] arParams = new SqlCeParameter[5]; arParams[0] = new SqlCeParameter("@SiteID", SqlDbType.Int); arParams[0].Value = siteId; arParams[1] = new SqlCeParameter("@RoleName", SqlDbType.NVarChar, 50); arParams[1].Value = roleName; arParams[2] = new SqlCeParameter("@DisplayName", SqlDbType.NVarChar, 50); arParams[2].Value = roleName; arParams[3] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier); arParams[3].Value = siteGuid; arParams[4] = new SqlCeParameter("@RoleGuid", SqlDbType.UniqueIdentifier); arParams[4].Value = roleGuid; int newId = Convert.ToInt32(AdoHelper.DoInsertGetIdentitiy( connectionString, CommandType.Text, sqlCommand.ToString(), arParams)); return(newId); }
public int Create( int siteId, string userId, string claimType, string claimValue) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("INSERT INTO mp_UserClaims "); sqlCommand.Append("("); sqlCommand.Append("SiteId, "); sqlCommand.Append("UserId, "); sqlCommand.Append("ClaimType, "); sqlCommand.Append("ClaimValue "); sqlCommand.Append(")"); sqlCommand.Append(" VALUES "); sqlCommand.Append("("); sqlCommand.Append("@SiteId, "); sqlCommand.Append("@UserId, "); sqlCommand.Append("@ClaimType, "); sqlCommand.Append("@ClaimValue "); sqlCommand.Append(")"); sqlCommand.Append(";"); SqlCeParameter[] arParams = new SqlCeParameter[4]; arParams[0] = new SqlCeParameter("@UserId", SqlDbType.NVarChar, 128); arParams[0].Value = userId; arParams[1] = new SqlCeParameter("@ClaimType", SqlDbType.NText); arParams[1].Value = claimType; arParams[2] = new SqlCeParameter("@ClaimValue", SqlDbType.NText); arParams[2].Value = claimValue; arParams[3] = new SqlCeParameter("@SiteId", SqlDbType.Int); arParams[3].Value = siteId; int newId = Convert.ToInt32(AdoHelper.DoInsertGetIdentitiy( connectionString, CommandType.Text, sqlCommand.ToString(), arParams)); return(newId); }
/// <summary> /// Inserts a row in the mp_BannedIPAddresses table. Returns new integer id. /// </summary> /// <param name="bannedIP"> bannedIP </param> /// <param name="bannedUTC"> bannedUTC </param> /// <param name="bannedReason"> bannedReason </param> /// <returns>int</returns> public int Add( string bannedIP, DateTime bannedUtc, string bannedReason) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("INSERT INTO mp_BannedIPAddresses "); sqlCommand.Append("("); sqlCommand.Append("BannedIP, "); sqlCommand.Append("BannedUTC, "); sqlCommand.Append("BannedReason "); sqlCommand.Append(")"); sqlCommand.Append(" VALUES "); sqlCommand.Append("("); sqlCommand.Append("@BannedIP, "); sqlCommand.Append("@BannedUTC, "); sqlCommand.Append("@BannedReason "); sqlCommand.Append(")"); sqlCommand.Append(";"); SqlCeParameter[] arParams = new SqlCeParameter[3]; arParams[0] = new SqlCeParameter("@BannedIP", SqlDbType.NVarChar, 50); arParams[0].Value = bannedIP; arParams[1] = new SqlCeParameter("@BannedUTC", SqlDbType.DateTime); arParams[1].Value = bannedUtc; arParams[2] = new SqlCeParameter("@BannedReason", SqlDbType.NVarChar, 255); arParams[2].Value = bannedReason; int newId = Convert.ToInt32( AdoHelper.DoInsertGetIdentitiy( connectionString, CommandType.Text, sqlCommand.ToString(), arParams)); return(newId); }
/// <summary> /// Inserts a row in the mp_SystemLog table. Returns new integer id. /// </summary> /// <param name="logDate"> logDate </param> /// <param name="ipAddress"> ipAddress </param> /// <param name="culture"> culture </param> /// <param name="url"> url </param> /// <param name="shortUrl"> shortUrl </param> /// <param name="thread"> thread </param> /// <param name="logLevel"> logLevel </param> /// <param name="logger"> logger </param> /// <param name="message"> message </param> /// <returns>int</returns> public int Create( DateTime logDate, string ipAddress, string culture, string url, string shortUrl, string thread, string logLevel, string logger, string message) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("INSERT INTO mp_SystemLog "); sqlCommand.Append("("); sqlCommand.Append("LogDate, "); sqlCommand.Append("IpAddress, "); sqlCommand.Append("Culture, "); sqlCommand.Append("Url, "); sqlCommand.Append("ShortUrl, "); sqlCommand.Append("Thread, "); sqlCommand.Append("LogLevel, "); sqlCommand.Append("Logger, "); sqlCommand.Append("Message "); sqlCommand.Append(")"); sqlCommand.Append(" VALUES "); sqlCommand.Append("("); sqlCommand.Append("@LogDate, "); sqlCommand.Append("@IpAddress, "); sqlCommand.Append("@Culture, "); sqlCommand.Append("@Url, "); sqlCommand.Append("@ShortUrl, "); sqlCommand.Append("@Thread, "); sqlCommand.Append("@LogLevel, "); sqlCommand.Append("@Logger, "); sqlCommand.Append("@Message "); sqlCommand.Append(")"); sqlCommand.Append(";"); SqlCeParameter[] arParams = new SqlCeParameter[9]; arParams[0] = new SqlCeParameter("@LogDate", SqlDbType.DateTime); arParams[0].Value = logDate; arParams[1] = new SqlCeParameter("@IpAddress", SqlDbType.NVarChar, 50); arParams[1].Value = ipAddress; arParams[2] = new SqlCeParameter("@Culture", SqlDbType.NVarChar, 10); arParams[2].Value = culture; arParams[3] = new SqlCeParameter("@Url", SqlDbType.NText); arParams[3].Value = url; arParams[4] = new SqlCeParameter("@ShortUrl", SqlDbType.NVarChar, 255); arParams[4].Value = shortUrl; arParams[5] = new SqlCeParameter("@Thread", SqlDbType.NVarChar, 255); arParams[5].Value = thread; arParams[6] = new SqlCeParameter("@LogLevel", SqlDbType.NVarChar, 20); arParams[6].Value = logLevel; arParams[7] = new SqlCeParameter("@Logger", SqlDbType.NVarChar, 255); arParams[7].Value = logger; arParams[8] = new SqlCeParameter("@Message", SqlDbType.NText); arParams[8].Value = message; int newId = Convert.ToInt32(AdoHelper.DoInsertGetIdentitiy( connectionString, CommandType.Text, sqlCommand.ToString(), arParams)); return newId; }