/// <summary>
        /// Deletes the role site.
        /// </summary>
        /// <param name="roleSiteEntity">The role site entity.</param>
        /// <returns></returns>
        public string DeleteRoleSite(RoleSiteEntity roleSiteEntity)
        {
            const string sql = @"uspDelete_RoleSite";

            object[] parms = { "@RoleSiteID", roleSiteEntity.RoleSiteId };
            return(Db.Delete(sql, true, parms));
        }
 /// <summary>
 /// Takes the specified role site entity.
 /// </summary>
 /// <param name="roleSiteEntity">The role site entity.</param>
 /// <returns></returns>
 private static object[] Take(RoleSiteEntity roleSiteEntity)
 {
     return(new object[]
     {
         @"RoleSiteID", roleSiteEntity.RoleSiteId,
         @"RoleID", roleSiteEntity.RoleId,
         @"SiteID", roleSiteEntity.SiteId,
         @"PermissionID", roleSiteEntity.PermissionId
     });
 }
        /// <summary>
        /// Inserts the role site.
        /// </summary>
        /// <param name="roleSiteEntity">The role site entity.</param>
        /// <returns></returns>
        public int InsertRoleSite(RoleSiteEntity roleSiteEntity)
        {
            const string sql = @"uspInsert_RoleSite";

            return(Db.Insert(sql, true, Take(roleSiteEntity)));
        }