/// <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))); }